Introduction
This website is dedicated to collecting Access VBA code snippets. With the advent of faster and more reliable network infrastructure, and the possibility to not only use a file-based storage system, but Sharepoint and MS SQL Server as well, Access seems to have acquired a new lease on life. It certainly seems to be regaining popularity in the corporate world. Having done a fair bit of consulting for Access 2003 database development and deployments lately, here's my collection of handy code snippets that are a must-have to get serious work done with Access. I'm mostly using Access 2003, since that still provides for user-level security; why this was dropped from Access 2007 is beyond me, there are still many situtations where this is just the right fit, especially when combined with RWOP queries.
You can use the examples given here as you see fit, but please retain the attribution. I don't provide any guarantees, here, neither explicit or implied, about the usability of these snippets for a particular end. A fair few of the examples will be rough-and-ready to improve the readability, you may need to add error handling if you want to use them in a real-life implementation.
(1 vote)