Posts

  • Generic function to copy Excel data between workbooks

    I needed a way to ensure that some Excel workbooks that were being completed by customers and uploaded to a server for analysis and subsequent loading into a database, were not being tampered with. Certainly...

  • 2006 Super Fund Performance

    I just noticed that I forgot to post last year’s results for the Bainsworld Superannuation Fund. Our investment earnings rate for 2006 was 11.7% which seems a little low given the way the Australian market...

  • 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...

subscribe via RSS