Macros versus Code

K

Ken

What are the advantages/disadvantages to using Macros versus Code? I have stayed away from using macros for I thought I read somewhere that these are not as reliable as code. Any input is appreciated.
 
A

Arvin Meyer

Ken said:
What are the advantages/disadvantages to using Macros versus Code? I have
Click to expand...
stayed away from using macros for I thought I read somewhere that these are
not as reliable as code. Any input is appreciated.

I have not written any macros in about 6 or 7 years because code is easier
once you've learned how. The main reason often given for using code is error
handling. Macros don't have decent error handling. I have not found any
reliability problems with macros on systems I've inherited, it's just that
they are limited and VBA code is not. Try running any api code with a macro
.... you can't. Try using a macro in a query ... you can't.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
V

Van T. Dinh

Besides what Arvin wrote, VBA codes can do a lot more than Macros. One
example is using the Recordset to process / update Table data.

Macros are fairly reliable but fairly underpowered c.f. VBA codes. Only in
one occasion that I found the Macros were converted incorrectly when the
database was converted from Access 2.0 to Access 2000.

--
HTH
Van T. Dinh
MVP (Access)



Ken said:
What are the advantages/disadvantages to using Macros versus Code? I have
Click to expand...
stayed away from using macros for I thought I read somewhere that these are
not as reliable as code. Any input is appreciated.
 
Top