Macro editing?

  • Thread starter Thread starter Bertie
  • Start date Start date
B

Bertie

I'm trying to make a set of commands to run inside access 2000. I want to
use the VB editor to do it (as I can code it but can't make the macro with
the stupid system access has) - is there any way to edit macro's with the
VB editors? And if not is there any way to make a module act like a macro?

Cheers,
 
You can select the desired macro and then from the Tools
Menu, select "Convert Macros to Visual Basic" from the
Macros option.

This will convert the Macro to Visual Basic code which
you can then edit from the VB editor.

HTH

Byron
 
-----Original Message-----
Yes but how do u then get it back to being a macro?
.
Click to expand...

To my knowledge there is no way to have the code again
become a macor. However, you could call the code (if you
make it into a function) from a macro.

By the way, you can use the code in the same places that
you would use a macro.

HTH
Byron
 
Back
Top