resources?

[n8kindt]

i knew next to nothing about vba no more than 2 weeks ago. as a beginner, i've found (http://allenbrowne.com/tips.html, http://www.functionx.com/access/, this site, Microsoft help files, and Googling to be sufficient (for the most part) in my quest for knowledge. what are some additional resources for programming vba (or anything access related) that you frequently refer to?

[mshmyob]

There are many books and sites out there for Access but I would make another suggestion.

I don't know if you are also new to database design but I have noticed that most people jump into Access and start programming without the basic knowledge of database design. This causes them a lot of grief since a poorly designed database structure from the beginnig cannot be improved upon no matter how good you are at programming.

I would therefore suggest (if you don't know database design concepts) that you start there. A good book on design is

Database Systems - Design, Implementation, and Management - By Peter Rob, Carlos Coronel.

I have the 6th and 7th edition with the 7th being the best.

This will step you through how to design (ERD, RSD, Normalization, etc.)
Has basic SQL and advanced SQL.
Web Database Development (using Coldfusion)
Distributed Design

and a bunch of other things about database desgin.

Start with a good foundation and the rest is easy.

cheers,

i knew next to nothing about vba no more than 2 weeks ago. as a beginner, i've found (http://allenbrowne.com/tips.html, http://www.functionx.com/access/, this site, Microsoft help files, and Googling to be sufficient (for the most part) in my quest for knowledge. what are some additional resources for programming vba (or anything access related) that you frequently refer to?

[missinglinq]

I assume, from the URL, that this site is part of the functionx.com site you already have, but I coud find no direct link from that site to this one:

http://www.functionx.com/vbaccess/index.htm

This page has a primer laid out with 23 well defined, clearly named chapters that cover all the baiscs and is the best site for a beginner that I've ever come across.

Linq ;0)>

[n8kindt]

I assume, from the URL, that this site is part of the functionx.com site you already have, but I coud find no direct link from that site to this one:

http://www.functionx.com/vbaccess/index.htm

This page has a primer laid out with 23 well defined, clearly named chapters that cover all the baiscs and is the best site for a beginner that I've ever come across.

Linq ;0)>

wow, that is a jackpot. thanks for the link! and i will definitely look into getting a hold of that book. thanks Linq!

cheers,
nate