Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vba

ResolvedVersion 2007

Herbert has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course

VBA

VBA SHORTCUTS

RE: VBA

Hi Herbert

Thank you for your question

Could you please expand on your question. Are you looking for quick ways to enter code into your VBE, a guide to the various object models, or best practice for coding in VBA

Thanks

Stephen

RE: VBA

Hi Stephen,

I am looking for quick ways to enter code into VBA, a guide to the various object models and best parctice for coding in VBA.

Thanks
Herbert

RE: VBA

Herbert,
There are lots of online resources, but the Microsoft MSDN library is the place to start.

Here's a link to a VBA Programmer's Guide:
http://msdn.microsoft.com/en-us/library/aa141393 (office.10).aspx

and here's some Access-specific material:
http://msdn.microsoft.com/en-us/library/dd941292.aspx

Basically, have a look around the whole library. Don't worry about which version of Office it relates to - as far as VBA is concerned it's all pretty much the same from 2000 onwards.

There's example code in this library, and much else available out on the web. Just Google "Access VBA" plus something specific, and you'll probably find what you want.

/Roy

RE: VBA

Note that the first URL hasn't linked properly because of the brackets.

Mon 27 Jul 2009: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.