vba platform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike M. - 31 Jan 2007 16:35 GMT

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

Reply to this Message

Tony Jollans - 31 Jan 2007 18:06 GMT

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 :-)

Signature

Enjoy,
Tony

>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
[quoted text clipped - 16 lines]
>
> Thank you - Mike

Reply to this Message

Mike M. - 31 Jan 2007 21:18 GMT

Thanks Tony - that helps..

> That link points to a VB tutorial (not VBA). I quote directly from it:
>
[quoted text clipped - 27 lines]
>>
>> Thank you - Mike

Reply to this Message

Doug Robbins - Word MVP - 31 Jan 2007 18:26 GMT

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

Signature

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

Reply to this Message

Mike M. - 31 Jan 2007 21:19 GMT

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
[quoted text clipped - 23 lines]
>>
>> Thank you - Mike

Reply to this Message

Rate this thread: