Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How do i use VBA in Microsoft Access

How do i use VBA in Microsoft Access

How do i use VBA in Microsoft Access

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.


RE: How do i use VBA in Microsoft Access

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!

RE: How do i use VBA in Microsoft Access

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

RE: How do i use VBA in Microsoft Access

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
Custom Application Development

RE: How do i use VBA in Microsoft Access

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.

RE: How do i use VBA in Microsoft Access

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close