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

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

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. This is useful f...

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

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, num...

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

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