Need help Learning VBA

[kdoran]

I have been using access 2000 for a short period now. I am asking for help in pointing me in the right direction to learning VBA on the web or other. Your responses are greatly appreciated.

Thanks in advance,

Kelly

 

[scriverb]

Big request with so little time and room in these postings. But, the way I learned it was to use the Wizard on a form and create all types of buttons and functions. Then go behind these objects and dig into the code using ACCESS Help of the F1 key to access the command and learn the code one function at a time.

Hope this gets you started.

Bob Scriver

 

[markphsd]

Or use macros, then convert them to VBA, that's how I first started.. about 2 years ago now. And what have I learned?.... the agony of defeat. It's fun though.

Also, Learn the hot keys, they make working faster, such as alt+f11 to get to the code.

peace out.

Mark P.

Bleh

 

[jfgambit]

Kelly:

A very helpful book is by Ken Getz:
VBA Developer's Handbook

and
Access 2000 Developer's Handbook

Good Luck


"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"

 

[patweb]

For me and I think for many many others learning VBA is an ongoing learning process. You have a database requirement and you look for solutions. But of course you have to start from somewhere.

I'm using a mix of knowledge resources :
1. VBA Course (two to tree days), essential for the basics.
(recordsets, instructions, functions...)
2. HELP in Access (F1).
3. VBA manual (still learning a lot of my book access 95).
4. Writing a macro and convert this to VBA (save as).
5. Posting questions on forums.
6. Reading and trying to understand VBA code examples.
7. Keywords in search engines (

http://www.google.com)

8. Asking VBA Masters or Colleagues.

Your demand is very important. I would have make faster progress in my learning process if someone has guided me to the best resources.

pat (humble access fan).

 

[Garridon]

The areas you want to focus on are:

* If statements
* Select case statements
* Dim statements

I took a class on Basic VBA because I had been struggling to learn how to program in it. Learning those three things really helped me take a big jump in my skills.

 

[Rick39]

Here are a couple of links that may be of use to you:

http://msdn.microsoft.com/library/d...eovroffice2000visualbasicprogrammersguide.asp

http://www.lacher.com/toc/tutvba1.htm

(Excel)

 

[stickers]

One more thing - as someone who was very recently in the same position!

Don't be scared of things you don't instantly understand - for instance I spent ages ignoring the Domain functions. I was writing huge long bits of code, when if I had used a domain function, one line would have done!!

I would definitely recommend a course though, as soon as you can - you can get there by yourself, but it's a lot more frustrating.

good luck!!

Sarah

 

[Jack58]

I have a Microsoft Press Book Titled "Microsoft Access Visual Basic for Applications Fundamentals. The ISDN for this book is 0-7356-0592-0.

The book has excellent step by step instructions and a cD Rom to show examples of what they are talking about.

Hope this will help, it sure has helped me.


Best of Luck



Jack