Recommend Access 2003 book?

[Kevin]

I went to Barnes and Noble this afternoon hoping to find a book which
would update me from my initial introduction to Access, circa '97, to
now (2003). The books I read back then (Running Access, Mastering
Access, the "bubble book", Access Cookbook helped back then, but were
more than a bit fuzzy about things I think I should really know more
about, like class modules and collections. I finally discovered how to
construct class modules and cut-and-pasted code for collections since
then, and love them both as tools, but have never felt like I really
understood what the hell I'm doing. Can anyone recommend a book which
explains the theory and practice of these guys without going into
excessive detail about which button to click to bring up Properties?

I'm smart enough to have constructed code which writes class module code
for a table or a field, but not smart enough to really understand what
I'm doing there.

What would help me here?

Thanks,

Kevin

 

[Sandra Daigle]

Hi Kevin,

My favorite source of information on classes is the The Access(2000 or
above) Developers Handbook. (Litwin, Getz and Gilbert). They offer an
excellent discussion of the principle behind classes and collections and
illustrate this with several usable examples.

Also, here are some links to articles about classes -

Class Modules - Simplify and Accelerate Your Development Processes
Class Act By Ken Getz and Mike Gilbert
http://www.microsoft.com/OfficeDev/Articles/classmod.htm

Advanced Class Modules
By Ken Getz and Mike Gilbert
http://www.microsoft.com/OfficeDev/Articles/AdvClMod.htm

For a few working examples take a look at

clsCtlGroups
http://www.daiglenet.com/MSAccess.htm

http://www.lebans.com/PrintLines.htm