Macro Question

[jo15765]

There are several macro's in a database that I did not create. I am wanting to view what the macro actually does, but I do not know how to look at the code that runs when the macro is executed. Can someone tell me how to do this?

[ajetrumpet]

look in design view, jo. all the info is there. if code is run, look at the function name and search for it in the vbe.

btw, I've noticed that when you post questions you post A LOT of them at one time. Sometimes one right after the other. Any particular reason for this??

[jo15765]

i looked in design view but i didn't see the macro's. maybe it is a option in one of the toolbars?

the reason i will often post is i inherited several databases, and either i am trying to decipher the code already in the database, or i am attempting to make an enhancement that i can not discover how to do by 1) trial and error 2) googling and/or searching the forum or 3) searching in a access 2000 handbook that i have.

[ajetrumpet]

i looked in design view but i didn't see the macro's.

for someone that's experienced in Access, this statement is a little bit strange, jo.

I said look in the design view of the MACROS themselves. I'm not really sure what design view you're talking about.

Do you have any experience looking at a macro object in design view?? You know that a macro is an object that's located in the database window, right?

[jo15765]

When I open up the design view of the macro it looks similar to a table (at least imo) and it has an "action" column and it shows the macro name. I don't see what happens when this macro is run, and that is what I am trying to see.

No, I have no experiance with macro's. If this is even possible, I am wanting to view the "event code" (what happens when the macro is run) so I can tie these macro's into the big picture of the database I am working on.

[jo15765]

Disregard I just found it. I just had to click the macro, and then go to tools, macro's and then convert macro to VB and I can view the code there.

[ssanfu]

Macros are not VBA code.

You converted a macro to VBA. When you are looking at the macro in design view, click on the macro "Action" column, then look towards the bottom of the screen.

If the action was "OpenForm", the dialog box at the bottom of the screen would have a line "Form Name" caption and a place to enter the form name.

As you moved down the action column, you would see the different arguments for each action.

Again, Macros and VBA code are not the same thing.