Access 2003 vs 2007 VBA Training.

[wob]

I'm trying to get some VBA training sorted out. However, the courses I'm looking at are either 2007 (or 2010) specific.

We use Access 2003 here. I could probably get some 2003 training sorted out, but it wouldn't be with the company I want to use.

If I went for a Access 2007 VBA course, how applicable would what I'm being taught, be to 2003?

I appreciate that this is a very general question - but for those of you that have VBA experience in both versions of Access, how much has changed? Do you think if you taught someone the basics of VBA in one version, that you'd expect them to have difficulty adapting what you'd teach them to 2003?

Opinions?

 

[Norie]

I don't think VBA for 2003 and 2007 has changed muchl.

Also anything you can do in 2003 should be supported in later versions.

What is it you want to learn to do with VBA?

Anything specific to 2007?

 

[wob]

Norie. Thank's for the reply. It's an introduction to VBA, so the course should cover the basics.

I have a little Excel VBA knowledge, but have only taught myself from books and recorded macros (and this forum of course) so would prefer to be taught Access VBA from scratch.

Edit: Should have added, I'm not expecting something specific from the course - I want a general knowledge of VBA for future projects.

Does anyone else have any opinions?

 

[Norie]

What are you going to be doing with VBA in Access?

This is a personal opinion but it seems like some people jump to using code when the functionality they want is there already and can be used without code.

That's not to say that there's anything wrong with using code, in fact it's definitely needed for some things, especially when working with forms.

Like I said just my opinion.

 

[xenou]

It may be true that knowing vba can hamper your knowledge of Access per se. That was true in my case. I started out designing many forms with unbound controls where I scripted all the updates in VBA. So I never learned to design proper forms using built in Access form behaviors with bound controls and a lot less code.

That said, no worries with Access 2007 and 2010. The fundamentals haven't changed much and good databases are mostly about good design. There's almost nothing that won't apply with little or no modification to Access 2003 (except working with menus). Feel free to stay with the company you like.