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