Access Tips and Tricks

This will be expanded in due course to provide general help on MS Access garnered from my experiences over the years. This is very much a when there's a spare moment or two page.

VBA String functions
Mid$, Left$ and so on are contained within one of the mandatory Access reference libraries. For Access 2000 and later.

I made up the ‘String Theory’ single form Acc2000 database from a diagnostic mdb (which includes a lot more than just this) that I send to customers on occasion; if the strings and a few other things work, then the Access mandatory references are probably OK.

It serves as a reminder and checker for string function parameters.  It could also be used for demonstrating what string functions do in training.

Download strthy.zip

Access References
Heres a little something to check your references in Access 2000, which I've taken from the Access Developers Handbook and changed a little.  It is left as an mda for you to hack as you wish.  All copyrights to Sybex and Getz, Litwin and Gilbert wholly acknowledged.  The original from the ADH allows you to add references.

Load RefCheck as a library and then you should see what references you've got set without having to open the VBA editor. It will print a report of same.  It may well work in versions of Access later than 2000 but I haven't tested it so will not vouch for it.
Download -RefCheck.zip

Links for people who give their time freely to help others, these are all MS Access MVP's and the info and advice you get from these links is pure gold.  More power to them each and all.