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