Macro verses VB

[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?

 

[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.

 

[Arvin Meyer]

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?

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