14,534
This is a list of technical site links that many of our experts find useful. They are often included in posts in answer to repeated questions so I am posting a list of them here for convenience.
These sites are not advertisements and if any site here causes users any problems please let me know. They are only meant to include links that contain answers to frequently asked questions.
Of course if there is anything on any of these sites you don't understand please post your questions in the forum.
PLEASE NOTE: Some of these sites do have popup/popunders. There is not much we can do about them but you should probably have your popup blocker turned on.
How to structure your tables
This site was written by Microsoft for Access 2000. However, the rules basically hold true for any database structure and should be read by anyone building a database who doesn't fully understand the importance of normalisation and how to do it.
So many of the problems our posters encounter can be traced back to the incorrect structure of their tables.
As with all these sites you can ask any questions on the forum if there is anything you don't fully understand.
http://support.microsoft.com/kb/209534/
Access Security
This site goes into great detail about all aspects of Microsoft Access security features and should answer any questions on the subject.
http://www.jmwild.com/Accesssecurity.htm
Tutorials and General Help
This site has something for both the beginner and the advanced user. It provides tutorials, general how-to's on everything from table structure, to VBA. It also has a page which covers all commonly used functions.
http://www.techonthenet.com/access/index.php
Snippets of code
There are some very useful snippets of code here for commonly preformed actions using VBA (Not just in Access).
http://www.vba-programmer.com/
Forms and Subforms
So many questions in this forum are on how to refer to and from subforms using code. This is the definitive answer from the MS MVP's.
http://www.mvps.org/access/forms/frm0031.htm
DAO using Recordsets
This is a site written by Allen Brown pointing out the top 10 most common errors when using DAO with recordsets and how to solve them of course.
http://allenbrowne.com/ser-29.html
Allen Browne is another of Microsofts MVP's and his site is full of useful tips for all levels.
http://allenbrowne.com/tips.html
Advanced Users
Some classes of useful code written by Michael Kaplan. For those of you who don't know him he's a former MS MVP and is considered one of the gurus of Access.
http://www.trigeminal.com/codes.asp?1033
The following are some very good white papers from the FMS site.
Microsoft Access within a Organisation's Database Strategy
FMS Technical Papers
Useful Code
Stephen Lebans, another MS MVP has a site full of useful downloadable code, including my favourite for turning the mousewheel on and off.
Although, we cannot stand by any code downloaded from a website Stephens code has been used by many experts and I've heard nothing of any problems with it.
http://www.lebans.com/toc.htm
Useful Add-In
MZ-Tools 3.0 is a freeware add-in for Visual Basic 6.0, Visual Basic 5.0 and the Visual Basic For Applications editor (provided by a VBA-enabled application such as those in Office 2000 and higher) which adds several productivity features to the IDE.
