How do I view a macros code?

Oscar

Registered User.
Local time
Today, 21:37
Joined
Dec 9, 2002
Messages
23
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?
 
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.
 
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
 
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.
 
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
 

Users who are viewing this thread

Back
Top Bottom