This is a page of resources that we hope you will use and enjoy. The resources will be added to over time, so please come back to check for new pages.
You are welcome to use the samples from this site, as long as you cite this site as the source. If you want help with implementing any of the concepts found here, please contact DataWright to discuss your requirements.
If you want to manipulate or loop through records in code, Access requires you to create a recordset first. You can use a table or a query as the source of the recordset data. Here is a collection of samples to help you out.
Once you have created queries and become comfortable with using calculations in Access queries, you can do a lot of useful stuff. Sometimes, however, you need some more techniques. This collection (some simple, some not so simple) will help you extend your toolbox.
At some stage you will probably need to build a booking system. Often you will need to find a way to avoid double-bookings; this article shows one approach.
Documenting your database usually gets left to the last minute. The database documenter built into Access will create a report for you, but you get no control over the formatting and it's not particularly easy to sort or search the information. By adding some tools to do the job you can save yourself a lot of time, and create useful and relevant documentation for yourself and others to use. This series of articles will grow over time to provide some of that toolset for you.
Listboxes and Combo boxes are very versatile. You can use them to reduce data entry, to filter forms, queries and reports, and (in the case of listboxes) you can make multiple selections.
Here is a collection of tips for working with listboxes and combo boxes
If you build, or inherit, a database with the wrong structure, you will find yourself fighting your data to get useful reports. This section has articles that will help you to design your tables correctly, and reorganise tables into better structures.
Often you will find yourself importing text files or Excel worksheets into Access. If you only do a few a week, you can consider doing the process manually. But if you import multiple files at a time, some automation is handy. Take a look at these tips.