Just wondering if anyone new of any books that contain examples of code, functions, syntax, etc. I would like to have a good reference that I could go to instead of searching the internet everytime I need to try something new.

Thanks in advance.

You didn't say which version you are using, but I'm in the middle of reading

Access 2007 VBA by Teresa Hennig, Rob Cooper, Geoffry Griffith, and Armen Stein

which appears to be a good reference book.

Thanks. I use both Access 2000 and 2007. So i will check out the book you mentioned. Thanks again

The best books were the ones that used to ship with Access, but the ship no more :(

Here is the next best thing to the books:

http://msdn2.microsoft.com/en-us/library/sh9ywfdk(VS.80).aspx

My next suggestion is to get comfortable with the vba object browser. Start with the Access library, then look around in the docmd class. Then look around in the VBA library. All of the functions etc are there. Just highlight most anything in the object browser and help will pop up - :)

From a VB/A point of view:

VB & VBA in a nutshell. from O'Reilly
If you know what you want to do (ie I want a dynamic array, to use left() etc) but can't remember the syntax this book is excellent.

Mastering Access <version> from Sybex is also worth a look, huge book covering just about everything you might want to know from Forms, to queries to table design.

Access cookbook (o'Reilly is my favourite)

doesn't try to cover everything, just practical examples of real world issues

My favorite for learning by example is also the Access Cookbook. I learned VBA from the first edition of this book. I also like VBA in a nutshell as a reference and the VBA book recommended by Bob.