vba platform

[Mike M.]

I am new to VBA and attempting to learn it so I can code the forms needed
for the access database which I have developed but not turned over to the
users yet.

I have found several helpful sites with free tutorials to get started, but I
have run into a snag and don't know how to proceed or who to ask. The one
site on which I am trying to follow along on a lesson plan for VBA is
http://www.profsr.com/vb/vbintro.htm. The problem is that the programs that
I write following the examples there don't work.

I am using the VBA 6.3 editor in Word to write the code but the examples are
evidently using a different version or something. I was able to follow the
coding examples on the VBA page at the MVP site:
http://www.word.mvps.org/FAQs/MacrosVBA/VBABasicsIn15Mins.htm, and they
worked fine, so I'm thinking that somehow the VBA vehicle that the other
site is using is somehow different in some way. Or is it something to do
with the Active Document that the MVP site talks about but the other does
not? Can you help get me on the right track?

Thank you - Mike

 

[Tony Jollans]

That link points to a VB tutorial (not VBA). I quote directly from it:

"Visual Basic for Applications (VBA) is the language used to tie Microsoft
Office products together. It links Word and Excel applications, for example.
Although it is very similar to standard VB, it does have several particular
techniques that must be learned on their own."

There is much in VB that is not needed in VBA because the environments are
different. Stick to VBA resources, at least to begin with, otherwise you
will get confused

 

[Doug Robbins - Word MVP]

And if you are working with forms in Access, that is where you should be
developing. There may not be much code that you need to write, depending
upon exactly what your forms are doing.

Probably a lot better to post your questions to
microsoft.public.access.formscoding

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Mike M.]

Thanks Tony - that helps..

That link points to a VB tutorial (not VBA). I quote directly from it:

"Visual Basic for Applications (VBA) is the language used to tie Microsoft
Office products together. It links Word and Excel applications, for
example. Although it is very similar to standard VB, it does have several
particular techniques that must be learned on their own."

There is much in VB that is not needed in VBA because the environments are
different. Stick to VBA resources, at least to begin with, otherwise you
will get confused

 

[Mike M.]

Thanks Doug - I'll do that.

And if you are working with forms in Access, that is where you should be
developing. There may not be much code that you need to write, depending
upon exactly what your forms are doing.

Probably a lot better to post your questions to
microsoft.public.access.formscoding

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP