469,626 Members | 889 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,626 developers. It's quick & easy.

Links to useful sites

14,534 Expert Mod 8TB
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.


Access Security

This site goes into great detail about all aspects of Microsoft Access security features and should answer any questions on the subject.


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.


Snippets of code

There are some very useful snippets of code here for commonly preformed actions using VBA (Not just in Access).


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.


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.


Allen Browne is another of Microsofts MVP's and his site is full of useful tips for all levels.


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.


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.


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.
Nov 12 '06 #1
0 5818

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by valerian dinca | last post: by
reply views Thread by Cameron Laird | last post: by
reply views Thread by Cameron Laird | last post: by
1 post views Thread by Gabriel Genelli | last post: by
reply views Thread by Gabriel Genellina | last post: by
reply views Thread by Gabriel Genellina | last post: by
reply views Thread by Gabriel Genellina | last post: by
1 post views Thread by Gabriel Genellina | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.