How do I view a macros code?

[Oscar]

When I create command buttons on a form (using the wizard) eg Close Form, I can go and see the code the button uses by going into the Class Module. I would like to do the same with some macros I have created so that I can learn the VB code. How do I view the code for my macros?

 

[Pat Hartman]

There is no code module associated with a macro. If you want to see what code a macro would generate, you can use the menu option that converts it to VBA. When you use this option, nothing happens to the macro. It remains unchanged. Access adds a new module to the modules window that contains the code you asked it to generate.

 

[Dgavilanes]

Macro Code?

you mention

." If you want to see what code a macro would generate, you can use the menu option that converts it to VBA. "


Where and how do I get there, I'm a novice when it comes to this

can you help please.


thanks

Dennis

 

[Pat Hartman]

Go to the macro tab of the db window. Click on a macro to select it. From the menu select Tools/Macro/Convert Macro to Visual Basic.

 

[Dgavilanes]

Re:Macro/Menu

Thanks Pat:

Its so easy, I was looking in the wrong areas

Thanks Pat, I'm learning so much from you

Dennis