Macro verses VB

T

Tom Antrim

Hello
A general question. I want to convert macros to VB. I have
been using macros and find I need a better understanding
of VB. What would be a good book to explain this?
 
G

Guest

hi,
access has that built into it.
click macros in the db window then
goto tools>macros>convert macro to vb
follow the wizard.
 
A

Arvin Meyer

Tom Antrim said:
Hello
A general question. I want to convert macros to VB. I have
been using macros and find I need a better understanding
of VB. What would be a good book to explain this?
Click to expand...

Simple macros follow the DoCmd syntax. So, if you want to:

Close = DoCmd.Close
Quit = DoCmd.Quit
Echo = DoCmd.Echo (True or False)
etc.

There are others, but DoCmd will get you through most of them. There is also
a conversion utility that does the same thing and will add simple error
handling. Go to Tools ... Macros ... Convert Macros To VBA
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top