Access 2000 VBA Programming Texts

[Guest]

I am working with Access 2000 and need to do some serious VBA programming to
manipulate several tables in this budget accounting application I am writing.
What this procedure does is coordinate 3 tables to produce a report, some
budgeting calculations and organize the data into an email to the supervisor.
I started with Beginning Access 2000 VBA by Smith & Sussman, but need to
take the next step to perform actual database field-level manipulation. What
is the best book that can guide me through how to do this?I am tempted by
Access 2000 Developer;s Handbook Desktop Ed Vol 1 (Getz & Gilbert), Alison
Balter's Mastering Access 2000 Development and Microsoft Access 2000
Development Unleashed (Forte, Ralston & Howe). I don't need another bloody
"This is a database" manual, nor a full-blown language reference guide. I
need solid examples and instruction - any suggestions?

 

[John Nurick]

Hi Roy,

I find the Access xxx Developer's Handbook very useful and have no
hesitation recommending it.

However, of the tasks you mention,
-If the database structure is right, "coordinating tables" would
normally be handled within the database engine (relational integrity,
validation rules) with no VBA programming whatever.
-"budgeting calculations" and "organising the data" can usually be
handled in queries (i.e. in SQL), with little or no VBA.

So make sure the structure is right, and maybe also get a SQL text such
as SQL Queries for Mere Mortals (Hernandez & Viescas).