VBA & Visual Basic?

[Marco Simone]

Hi,

I am learning access and if someone can answer me what is difference between
Visual basic for applications and Visual Basic 6. Is it a same language,
just that VBA is for Office applications? Is the code same in both
languages?

Thanks in advance,
Marco

 

[Bruce M. Thompson]

I am learning access and if someone can answer me what is difference between

Visual basic for applications and Visual Basic 6. Is it a same language,
just that VBA is for Office applications? Is the code same in both
languages?

VBA is a subset of VB. It is, more or less, targeted at Office applications and
automation.

 

[Marshall Barton]

I am learning access and if someone can answer me what is difference between
Visual basic for applications and Visual Basic 6. Is it a same language,
just that VBA is for Office applications? Is the code same in both
languages?

The difference in the language is minimal. The stumbling
block for most people is the huge diffference in the library
object models. E.g. the form and control objects are so
different that you should develop a completely new mindset
when using them (VB- data control vs. Access bound forms).
In general, Access is very data centric and many data
activities require no code at all.

 

[Gene Hora]

I hope it's not too rude to "coat-tail" in here; at least in the same vein
of thinking. I also work with Access in a layman's sort of way for a few
years. I would like to extend my knowledge to some programming in VBA. I've
been looking at VB6 and doing some preliminary study, but am wondering if it
would be more practical just to go with VBA since I don't intend to look
outside the MS Office (actually Access) arena. If VBA is the best way to
go, how does one acquire the VBA program; I can't seem to find it listed
anywhere. Or does one just use commercial study guides and work within a
particular application?

I don't want to dive in too deeply into VB6 if it means a longer learning
curve than VBA. Any sage advice would be welcome.

 

[Rick Brandt]

I hope it's not too rude to "coat-tail" in here; at least in the same vein
of thinking. I also work with Access in a layman's sort of way for a few
years. I would like to extend my knowledge to some programming in VBA. I've
been looking at VB6 and doing some preliminary study, but am wondering if it
would be more practical just to go with VBA since I don't intend to look
outside the MS Office (actually Access) arena. If VBA is the best way to
go, how does one acquire the VBA program; I can't seem to find it listed
anywhere. Or does one just use commercial study guides and work within a
particular application?

VBA comes with Office automatically. If you have Office you have VBA. VBA
is not a separate programming environment like VB.

Open an Access file then go to the modules tab and press [New]. You will
be in a VBA code window. That's how you work in VBA.

 

[Gene Hora]

Thanks for the quick and informative reply. It's what I needed.

I hope it's not too rude to "coat-tail" in here; at least in the same vein
of thinking. I also work with Access in a layman's sort of way for a few
years. I would like to extend my knowledge to some programming in VBA. I've
been looking at VB6 and doing some preliminary study, but am wondering

if

it
would be more practical just to go with VBA since I don't intend to look
outside the MS Office (actually Access) arena. If VBA is the best way to
go, how does one acquire the VBA program; I can't seem to find it listed
anywhere. Or does one just use commercial study guides and work within a
particular application?

VBA comes with Office automatically. If you have Office you have VBA. VBA
is not a separate programming environment like VB.

Open an Access file then go to the modules tab and press [New]. You will
be in a VBA code window. That's how you work in VBA.

 

[Marshall Barton]

I hope it's not too rude to "coat-tail" in here; at least in the same vein
of thinking. I also work with Access in a layman's sort of way for a few
years. I would like to extend my knowledge to some programming in VBA. I've
been looking at VB6 and doing some preliminary study, but am wondering if it
would be more practical just to go with VBA since I don't intend to look
outside the MS Office (actually Access) arena. If VBA is the best way to
go, how does one acquire the VBA program; I can't seem to find it listed
anywhere. Or does one just use commercial study guides and work within a
particular application?

I don't want to dive in too deeply into VB6 if it means a longer learning
curve than VBA. Any sage advice would be welcome.

As I said before, the object models are very different. So
I think it would be not be much benefit towards learning
Access VBA. I really want to emphasize that the VB/VBA
language is a small part of the learning curve, it's the
object models and their nuances that take up the bulk of
your study time.
--
Marsh
MVP [MS Access]

 

[Alex]

VBA - Automation - Outlook 2003 & SBS 2003

How can I automate the sending of an email without the
security warnings using VBA in access only ?

Alternatively how can I do it if I am only knowledgeable
on writting code in access ie using Outlook object only.

 

[Cheryl Fischer]

How can I automate the sending of an email without the

security warnings using VBA in access only ?

According to Outlook MVP Sue Mosher: "The security dialogs that pop up when
an application tries to access certain Outlook properties and methods are
designed to inhibit the spread of viruses via Outlook; see
http://www.slipstick.com/outlook/esecup.htm#autosec. They cannot be simply
turned on or off with a user option or registry setting.

However, Outlook 2003 does not show security prompts on three specific types
of applications:

-- VBScript code in published, non-oneoff Outlook forms

-- Outlook VBA code that uses the intrinsic Application object

-- Outlook COM add-ins properly constructed to derive all objects from
the Application object passed by the OnConnection event."

And, here is a link to a March 2003 article by Sue on the subject of Outlook
2003 and its use of the security prompt: http://tinyurl.com/3eqmv

Alternatively how can I do it if I am only knowledgeable
on writting code in access ie using Outlook object only.

Whatever application you use to automate creating and sending Outlook
emails, you will be using some form of Outlook VBA.

 

[TC]

Jumping in here, the OP may want to consider using a 3rd party control
(Ostrosoft, Socketwrench, BLAT, etc.) to send emails directly from VBA,
without relying on >any< email client on the user's PC. This solves all such
problems, permanently

HTH,
TC