Were to start learning the code

[StefanV]

Hi,

I'm new to this group. I did my share of programming back in the days of dBase and Foxpro for DOS. Big programs, lots of db's, tons of code. My last upgrade was Visual Foxpro 6.0 :) and I never really got into that version.
Now I have a, what I consider, simple project. I want to make a prgram in Access to help me to quote, keep up inventory, report some instructions on actions to be take. Not to complicated in my mind. Then I actually started.
Seting up db's and relations, no problem,
Creating forms, no problem,
Using automated functions, not to hard to understand.
Writing the syntax for my events, very frustrating !

I got some books on Acces, but they don't really get into coding.
I've done my share of VB coding in excel, but access goes much further that that. So I do my internet searching, but I do not know the keywords yet, of the functions I'm looking for.

Like, this morning I was looking how to use the value of a field in an open db in my calculations. I don't know the syntax. I know the db is open and pointing at the right record, but not a part of the form I'm working in. Can't seem to find how to address it,...

So I'm looking for some websites, or books, that I could read through to update me on the syntax of VB to write code for MS access. Any place I can download like a reference guide for the commands?

Any good advice where to start?

Thanks!
Stefan

[Scott Price]

The Access/VBA help files are actually quite extensive with help for specific commands.

I assume you know that when within the VBA editor window you can position your cursor within any word, press F1 and the help file specific to that word will pop up? Also, by pressing F2 you will call up the object browser window, which allows you to view most of the supported commands, properties, objects, methods, keywords, etc. in VBA.

Within Access, pressing F1 will open the help window as well. Browsing the Table of Contents will show a wide variety of help topics, including one of the most important: the Microsoft Jet SQL Reference.

Beyond these resources, you can try the Access 200X Developers Handbook series by Getz and Litwin, I've not used them myself, but hear that they are the gold standard... In general, any book on Access that is at least 2 inches thick should be a good desktop reference.

Regards,
Scott