473,320 Members | 1,945 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Links to useful sites

MMcCarthy
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.

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
0 6125

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: valerian dinca | last post by:
Hi, This is my latest article for your consideration. If you think that this article could interest your subscribers it is free to reprint in your ezine and/or newsletter as long as you: 1....
0
by: Kurumi | last post by:
Here's how CSS can warn you about links to sites matching a "blacklist" you define. This might be useful in weeding out bogus search results, etc. It uses substring attribute matching (which is...
0
by: Cameron Laird | last post by:
QOTW: "I have a fake supervisor reference generator for job interviews, a fake house inspection generator for real estate transactions, and a fake parole testimony generator - maybe you could...
0
by: Cameron Laird | last post by:
QOTW: "Dictionaries are one of the most useful things in Python. Make sure you know how to take adavantage of them..." - Jeremy Sanders "Python has consistently failed to disappoint me." - Tal...
1
by: Gabriel Genelli | last post by:
QOTW: "A java class full of static methods translates to a python module populated with functions in general." - Arnaud Delobelle "Neurons are far more valuable than disk space, screen lines, or...
0
by: Gabriel Genellina | last post by:
QOTW: "Good God! Is there *anything* that python does not already do? I hardly feel the need to write programs anymore ... Its really 80% like of the questions that are asked here get answered...
0
by: Gabriel Genellina | last post by:
QOTW: "Stop thinking of three lines as 'extensive coding' and your problem disappears immediately." - Steve Holden "Hey, did you hear about the object-oriented version of COBOL? They call it...
0
by: Gabriel Genellina | last post by:
QOTW: "Regarding a Java programmer moving to Python, a lot of the mindset change is about the abundant use of built in data types of Python. So a Java programmer, when confronted with a problem,...
1
by: Gabriel Genellina | last post by:
QOTW: "here's always no best." - Lawrence Oluyede http://groups.google.com/group/comp.lang.python/msg/32bce47d185 ce42e "I actually do a lot of unit testing. I find it both annoying and highly...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.