How do i use VBA in Microsoft Access

[Guest_imported]

Hi everyone,

i am writing a database for a college project and have been asked to incorporate VBA into the database.

However i have never used VBA before but have used Access many times, does anyone have some hints or tips about VBA in access.

any links to relevant pages or any hints or tips would be appreciated.

Thanks

 

[Muttley]

Recommend that you look at the FAQs for the Access forum, they contain a great many useful points re: Access VBA.

One thing that you might want to try is to record an Access Macro and then use the 'Convert Macro to VB' option from the Tools - Macros menu. This will give you some pointers, but remember that there are many ways to skin a cat, so don't let this curb your creativity!

 

[RickSpr]

If you have access to a copy of the Microsoft Developer Network (MSDN) Library, it contains a book called "Microsoft Access 2000: Building Applications With Forms and Reports". I learned VBA from an earlier edition, and thought it was a very good way to learn. The book is also available in hardcopy from Microsoft, I think, and might be available at your library.

Muttley's suggestion is a good way to learn a bit about VBA, but let me warn you: the converted macro code, while it will probably work, very often will not be the best way to code it if you were writing in VBA in the first place. If you are to be graded on your efforts, you should be aware that the instructor will probably be able to tell that you converted a macro rather than understood how to write code. Rick Sprague

 

[jimmythegeek]

Access Programming for Dummies. People think the Dummies books are not as good as the so called "Technical" books, but for learning how to do things, this one was particularly good.

Jim Lunde
compugeeks@hotmail.com
Custom Application Development

 

[rafe]

Another suggestion along the lines of Muttley's is using an Access wizard to generate some controls ... say buttons for finding a record for example... & then looking at the VBA code the wizard creates.

It won't teach rock solid techinque but they gave me ideas, when I was starting out in VBA, on how to go about getting things done.

 

[Guest_imported]

A great starter is "Beginning Access 2000 VBA" WROX pub