The pages on this site give tips for the use of MS Access
2000 programmers, primarily beginners, although intermediate level people may also find
some ideas. Most of these tips will also work in Access 97 and 2002, although some minor
changes may be required. Some of the tips offer free Access sample databases.
Why have
I created
this site?
I am an MS Access instructor and programmer. I started to
frequent several newsgroups that deal with MS Access issues, primarily to exercise my
knowledge, thereby making me more useful to my students. As I answered the questions of
people who were obviously just starting out, I thought it would be good to capture those
answers in this format.
What is
my "help" philosophy?
"Give a man a fish and he will eat for a day, teach
a man to fish and he will eat for a lifetime."
Many of my tips will be a bit incomplete. Hopefully most of my visitors will appreciate
that fact. I will give enough ideas to get you started, and, if necessary and available,
references to other resources. Many of the shortcomings in my code examples will (should)
be obvious.
Example: dim db as database and set db=currentdb
You will also have to add error checking.
Is there a
role for you?
Definitely! If you are experimenting with one of the tips and
find a neat shortcut or alternative, e-mail me with your solution. If we have your
permission, we will publish your idea, along with your first name and city of residence.
What if you have questions?
My e-mail address is on every page of this site, however, I
cannot guarantee that I will be able to answer all questions. I recommend that you also
frequent the various newsgroups for Access users. Either use a newsgroup reader (eg.
Outlook Express or Free Agent) or go to www.google.com
and use their archives under the "group" tab. See tip027
for further details on google.
If you have a business in the Toronto region of southern
Ontario, the Manxman is available on contract to program your MS Access systems, or train
your staff in the use of Access. Click here for more
information.
Who is the
Manxman?
The Manxman is Richard Killey, of Hamilton (50 km west of Toronto),
Ontario, Canada. He has over 20 years of experience in the computer industry, as a trainer
and a programmer. About 1/2 of that time was as a Fortran programmer for a major mine
complex in northern Canada. Richard started using MS Access 97 in 1997. Richard became a
proud grandpa for the first time in Oct 2002.
Why
Manxman? Richard's dad's father was born on the Isle of Man, and the term Manx means
"of the Isle of Man."
For some other great MS Access sites, as well
as other useful links, click here.
This site is a member of WebRing.
To browse visit Here.
Access Database Repair and Recovery -
We provide instant, 24HR Microsoft Access
database repair service, 7 days per week, worldwide. Free corrupt database analysis
and report. Will beat any competitors price.