Standard Code

These are a series of modules that I've found useful in multiple applications. Hence, I've put them into a single Access file so that I can then Import them into new applications, deleting the unused portions as appropriate. There are also a couple of forms.

Module	Description
modArray	Code to initialize and manipulate a circular array.
modBkgndColor	Sets the Back Color of controls in a form and its subforms to the Back Color of the form's detail background.
modBrowsFldr	VBA interface to shell32.dll to browse for a folder.
modComDlgAPI	VBA interface to comdlg32 to display the file open interface
modCreditCardVal	Functions to validate credit card numbers.
modCrypto	VBA interface to advapi32.dll crypto functions.
modFunctions	A variety of functions such as testing to see if a form is loaded, a file name is valid, retrieving the nth parameter in a string, etc.
modInetAPI	VBA interface to wininet.dll to open, read, and close internet files.
modLnkdFile	Subroutines to manipulate Access linked files.
modPosition	VBA interface to user32.dll window positioning functions. (Works OK on maximized windows - not so good on others.)
modRegistry	VBA interface to advapi32.dll registry functions.

This is freeware with no warranty.

This zip file contains the several module files so they can be modified.

Release history
Detailed release history

Format: zip file 191k).
Last updated: December 31, 2008.
Download now

Access Tools

Code Samples