Valuable resource for learning VBA for Access?

  • Thread starter Thread starter Willam Lamberto
  • Start date Start date
W

Willam Lamberto

I'm currently developing an Access database for a small company,
and am essentially teaching myself along the way. I built a
small database for a project in school during a short stint in a
computer-related major, but other than that I have very little
experience when it comes to the "guts" of building a reliable
database. So, can anyone here suggest a comprehensive resource I
could use as both a means of teaching myself Visual Basic for
Access AND as an effective tool for reference? Online or in
print; doesn't matter. I'm learning this stuff right now piece
by piece and as needed, which is both incredibly slow and not
very condusive to retaining anything. Thanks in advance for any
suggestions.

-Willis
 
I would recommend "Access 2002 Developer's Handbook" (ISBN # 0-7821-4009-2), authors Paul
Litwin, Ken Getz, and Mike Gunderloy and "VBA Developer's Handbook" (ISBN #
0-7821-1951-4), authors Ken Getz and Mike Gilbert. Both books are printed by Sybex.
 
From the Microsoft Web Site:
http://www.microsoft.com/MSPress/books/5162.asp

Microsoft® Access 2002 Visual Basic® for Applications Step by Step

About the Book
Take creative control of the built-in programming language in Access 2002!
Teach yourself how to use Microsoftâ Visual Basic® for Applications (VBA) to
take command of Access Version 2002. Choose your own best starting point in
this self-paced guide to learn how to automate databases, write your own
functions and procedures, customize menus and toolbars, connect applications
to the Web, and more. Easy-to-follow lessons with real-world scenarios and
examples show you exactly how to maximize the built-in programming power in
Access 2002. Numerous screenshots and a CD full of practice files help you
master step-by-step programming procedures. Find out how to create custom
solutions with Access and this book-then keep it nearby as an ongoing
desktop reference to VBA functions and features. Learn at your own pace how
to:

.. Customize an application with Visual Basic
.. Find and filter records in a form
.. Respond to data-entry events
.. Write your own functions
.. Monitor and debug your code
.. Respond to errors and unexpected conditions
.. Gather information in a dialog box
.. Navigate through your application
.. Display custom menus and toolbars for applications
.. Put final touches on an application
.. Explore objects and collections
.. Customize reports and create data access pages
.. Share data with other applications
.. Connect applications to the Web

As for reference, the help file in the VBA IDE window and MSDN are both
good. But groups.google.com has always been one of the best resources for
me.

Hope this helps,
- Glen
 
Back
Top