Category Archives: Function Library

The Function Library contains single procedures of VBA code that can be used in your projects

AddTrustedLocation

Access 2007 and Access 2010 use trusted locations as a security measure to help prevent users opening a database from an unknown source which could include malicious code. Typically, if you open a database that is not in a trusted location, Access will display a security message asking if you want to open the file.
Continue reading →

ConvertQuote

The inbuilt Replace() function isn’t available in versions of Access prior to A2000, so the following function will handle single quotes for SQL purposes. For versions of Access from A2000 upwards, the Replace() function can be used
Continue reading →