Need real good development book for Access 2k7

[Guest]

So far I've gone thru Access Help, Access for Dummies, How to do everything
with Microsoft Access 2007 - by Virgina Andersen. These books are decent to
start with , but I have gotten to a place where I need more meat in the books.

The items I am running into are such as:
Entering a new patient and trying to assign a MD from another table and
get "Access engine cannot find record in table with key matching fields"

Or another form that can change the foreign key of a patients table to
another key in the MD's table thru another form.

Or having a form that contains a button that brings up another form that
converts lbs to kgs and getting the converted value to return to main calling
form.

TYIA

 

[Douglas J. Steele]

They don't come much better than Access 2007 Inside Out, by John Viescas and
Jeff Conrad.
http://www.microsoft.com/mspress/books/9784.aspx

 

[Guest]

It sounds like you are looking for a book that will tell you EXACTLY how to
do everything that you want to, and solve every problem that you may ever
encounter. Such a book does not exist. Books are good for some things, like
design principles, how to create tables, queries, etc., but they will only
get you so far. At some point in the development of your DB you'll have to do
some research on you own, combined with some trial and error, to accomplish
what you want.

My suggestion would be don't spend more money on books. There are plenty of
good websites out there, and if you need more specific help forums like this
are great help. I have probably learned as much from the posts in this forum
as I ever did from a book.