How to view the VBA structure of Automated Macros?

[Bigdaddrock]

I am not very conversant in the use of VBA. However, I make extensive use of the Macros in Access. Is there a way of viewing the VBA behind the various Macros?

[Stewart Ross]

Hi. Macros in Access are really a hangover from its early days of development, long before the development of the Visual Basic for Applications language now used in programming across the MS Office applications.

Access macros are not translated behind-the-scenes into VBA the way Excel 'macros' are. In Excel, a 'macro' is no longer recorded as a series of discrete actions - a named macro is a front for a subroutine containing VBA code which you can see if you look at the code modules lying behind the worksheets in the workbook.

There is no analogous facility in Access, so I'm sorry to say that if you really are using Access macros they remain composed of discrete actions. There is no VBA code hidden away from you that we can show you how to reveal.

-Stewart

[Bigdaddrock]

Thanks, I appreciate your saving me the time. I will take more advantage of using the Tabs on my forms and following the menu prompts. They create VBA code, which I can then "doctor up" and "merge" to allow me to do the multiple tasks that many "joined" macros allow me to do. Just requires a bit of "cut and paste" and a bit of creativity. Unfortunately, I do not have the time to learn VBA.

[NeoPa]

We can always help there. We do quite a lot of that sort of thing already would you believe ;-)