Macro code object

[ingeje]

Hi,

Does anyone knows in which object we can find a macro code (for access 97)
Thanks in advance

 

[hermanlaksko]

Maybe I am completely wrong and have misunderstood you but you should be able to find this under Macro.

Let me know what your problem is and I will see what I can do 4 U

Herman

 

[ingeje]

Thank Herman,
In fact I would like to reach the "code" (or actions or what a macro is doing) through VBA programming. Why ? I have a lot of menus with a lot of buttons (and macro attached to it): I must to provide users with informations about chain of all the menus. So the idea to reach the code of the macro by VBA (too long to go through all the buttons of all the menus by hand!)to know the next menus called.

Thanks

 

[hermanlaksko]

OhhhhhhhKayyy so you want to convert all the macros to code..... Yes ....... Sry cant help you here....... Just kidding ;-)

Its very simple:

1. in the access menu goto tools
2. goto macro
3. goto convert macros to VBA!

This will drop the whole bunch into vba and you can now use them from here dont forget to delete the macros - ONCE the code has been tested - and remember to change the properties/on action on each button.

All the best

Herman