How to trace macros?

[sudakov]

Hello,
I have inherited a DB where most of programming is done using MACROS, not code.
I receive an error during execution.

Does anyone know how to trace macros?

Thanks.
sudakov

 

[Andrzejek]

Aren't MACROS just pieces of code? Hit Alt-F11 and look if you can find the code for the macros.

Or, instead of macro - Run... click: Edit.

Have fun.

---- Andy

 

[MakeItSo]

Macros won't show up in the VB Editor, Andy.
But you can of course click "Tools-->Macros-->Convert macro to Visual Basic".
After that it'll be normal code and you can debug it like any other code snippet...
;-)

[navy]"We had to turn off that service to comply with the CDA Bill."[/navy]
- The Bastard Operator From Hell

 

[randy700]

In the help files, search for Convert macro to code.

Randy