Reference information...

[cheuschober]

Does anyone, perchance, have a good recommendation for a moderately paced beginners reference / tutorial for vba programming for Access? Online, or in paper--either is okay.

I would like to be able to learn some vba for a few databases I'm working on to make them slightly more 'bulletproof' and a bit flashier but I just don't know where to begin.

Thnx much,
Chad

 

[RoyVidar]

In my opinion, Access <version> Developers Handbook, Sybex, by Getz, Litwin and Gilbert is the best reference. It does however require (in my opinion) some degree of programming experience to get the full benefit.

Mastering Access <version> Desktop Development, Sams, by Alison Balter is also a good book, and in my opinion allows an intermediate Access user to gain lot of knowledge.

What say others?

 

[pono1]

I essentially share Vidar's view of the "Developers Guide." It's a terrific resource (I think its "class" examples are horrible, though -- in the Access 2000 version), but it does assume you already know some VBA. Perhaps if you purchased it with the idea that it will be something to grow into, you might find it less overwhelming and, worst of the worse, discouraging. Learning how to code, for most people, comes slowly, in bits and pieces, often re-learning the same bits and pieces you forgot about since the last project.

Regards,
Tim

 

[cheuschober]

Thanks for the replies but...

First off, thank you for the replies... I've looked into the aforementioned developer's book and I'm thinking about a purchase, but before I grab ahold of a book like that, I do think I need something to understand the basics of vba coding.

I have the Access 2002 Bible from when I was blindly venturing into this program -- it's sooo useless to me as it only seems to want to tell me how to build the Mountain Animal Hospital Database as opposed to intelligently and accurately describe all of the functions of this massive program!

Anyway, this Bible is quite useless to me. I tend to pick things up quickly for just being an actor without a whit of training that's not self-taught (more quickly than the average dummies guide, at least) so oft-times reference books are good quick ways for me to learn, that is, once I have a base understanding of what's going on. It's how I taught myself css, php, and html at least. Right now, I'm lacking that base so I just need some place to look for a basic understanding of how vba works--the basic properties, syntax, etc...

Any help would be appreciated. Thanks again for the tips, though...

~Chad

 

[pono1]

In between now and the post that recommends a good Access VBA primer, here are some terms you can research in the VBA help file:

data types
declaring variables
What is a procedure?
subprocedure
function
module
mime
statements
debug
Stanislavsky
Stop
For...Next Statement
Harold Pinter

Consider giving yourself a project or two -- nothing big and there's no need to worry about finishing -- create a calculator, a recipe DB, something -- this will deepen your knowledge beyond the definitions and discrete examples.

If you get the time, browse this and the Forms forum and take a shot at solving someone's problem, even if you might not, in the end, post your code...

Regards,
Tim

 

[cheuschober]

In between now and the post that recommends a good Access VBA primer, here are some terms you can research in the VBA help file:

data types
declaring variables
What is a procedure?
subprocedure
function
module
mime
statements
debug
Stanislavsky
Stop
For...Next Statement
Harold Pinter

Consider giving yourself a project or two -- nothing big and there's no need to worry about finishing -- create a calculator, a recipe DB, something -- this will deepen your knowledge beyond the definitions and discrete examples.

If you get the time, browse this and the Forms forum and take a shot at solving someone's problem, even if you might not, in the end, post your code...

Regards,
Tim

Thanks for the assistance there, Tim... I'll take those suggestions... Oh, and the additionals on the list were both noted and appreciated...

Sincerely,
~Chad