visual basic

[Ads]

This is probably a stupid question to some.
I'm learing a lot about access. The books I have give examples of
expressions that I guess are Visual Basic? But doesn't actually say outright
that Visual basic is vital.
Also I bought a book on Visual Basic to get me started and it doesn't
mention anywhere about it's use in Access.
What I'm looking for is a way of learning how to write the code itself. in
events. Like when to put the quotation marks, the brackets, full stops etc.
Thanks
A

 

[Rick Brandt]

This is probably a stupid question to some.
I'm learing a lot about access. The books I have give examples of
expressions that I guess are Visual Basic? But doesn't actually say
outright that Visual basic is vital.
Also I bought a book on Visual Basic to get me started and it doesn't
mention anywhere about it's use in Access.
What I'm looking for is a way of learning how to write the code
itself. in events. Like when to put the quotation marks, the
brackets, full stops etc. Thanks
A

The code you see in those books is VBA (Visual Basic for Applications) which
is a sort of sub-set of VB so a VB book while using the same language is not
a good resource. Most advanced Access books will cover the use of VBA code.

 

[CS]

What I'm looking for is a way of learning how to write the code itself. in
events. Like when to put the quotation marks, the brackets, full stops etc.
Thanks
A

Two books that have recently been helpful to me are Susan Novalis' "Access
97 Macro & VBA Handbook" and Smith and Sussman's "Beginning Access 2000
VBA". I am somewhat proficient in macros, have programmed some simple form
functions in Outlook in the past, but am a total VBA beginner in terms of
using it with Access.

Carol

 

[Ads]

Thanks. I'll Look out for them.

According to this book I have on VB, it comes with MS Office.
But I can't seem to find it. When I look at custom install
components, I see VB for Applications and VBA Help but wen I finsih the
installation, all I can find installed is Digital Certificate for VBA
projects.
(Office 2-003)
A

 

[Douglas J. Steele]

VBA = VB for Applications.

 

[Ed Warren]

You will not 'see' a shortcut for VBA, you get to it by opening MS Access
and then opening a new module. That opens the VBA code designer.
You can get some quick insight on how to start just by building a macro or
two, converting them to code modules and looking at how Access builds the
code (this was enough for me to 'get the taste of VBA) (I had programmed in
Basic, in the past). Also the help screens in VBA are fairly good sources.

Lots of luck

Ed Warren.