By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,668 Members | 1,620 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,668 IT Pros & Developers. It's quick & easy.

Links to useful sites

MMcCarthy
Expert Mod 10K+
P: 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.
Nov 12 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.