Posts

  • How to tell if an Access Report was printed

    I needed to be able to determine if an Access Report had been actually sent to the printer (as opposed to just previewed on screen) so that I could update a log recording the fact....

  • Error when referring to Excel sheets collection by sheet name

    I’ve just had a frustrating couple of hours dealing with what appears to be a bug in the Excel Sheets collection when accessed from an Access VBA module. The application is an Access 2000 database...

  • Calculating compound annual growth rate (CAGR)

    Microsoft Excel comes with a lot of inbuilt functions that can be used in cell formulae and there are also a number of add-ins that provide specialised sets of functions to support statistical, numerical and...

  • Setting text edit mode on Access form fields made easy

    The Locked and Enabled properties of text-based controls - combo boxes, check boxes, list boxes and text boxes - control whether they can be changed or entered. But for the life of me, I can...

  • Finding the name of a control in an Access subform

    I’m currently developing a Microsoft Access based system and found myself continually needing to work out how to access a property of the control that contains a subform from code running in the subform (for...

  • 2005 Super Fund Performance

    We have just completed our accounts for 2005 and I’m happy to report that the Bainsworld Superannuation Fund returned 17.5% to its members after tax and all expenses for the last year. Not too shabby...

  • Super Fund management software

    BGL Corporate Solutions is the developer of Simple Fund, the software we use to administer our SMSF. It is a bit more high-powered than we need as it is designed for accountants to manage...

subscribe via RSS