Need help in finding Macro definition

[sdondeti]

Hi all, I trying to find out the macro's definition in my access application, below is the sample code in one of the methods.

Dim stDocName As String
stDocName = "HomePage Override"
DoCmd.RunMacro stDocName

I searched all the database i couldn't find the macro nammed with "HomePage Override" and all others.

When RunMacro is called where is it getting stDocName? Can some one help me to open this macro definition. Past two days i am struggling to find out. please help me out.

Thanks,

[RuralGuy]

Examine your macros for "HomePage Override". First click the Macro icon on the Database left hand pane. Look inside each macro and see if you can find that string.

[sdondeti]

Thanks for your reply.

I examine in macros i don't find not even one macro in my database. I even looked under tools > macros , i don't find any to run. But in my application there are many docmd.runmacro commands called.

Thanks,

[RuralGuy]

Do you open your db while holding down a <SHIFT> key? Does it change anything? Can you zip up and post your db?

[sdondeti]

yes i opened by holding <shift> key. db is of 126mb size and it's a highly important data available.

Thanks,

[RuralGuy]

How about creating a new empty db and importing everything but the data in the tables? Access lets you just import the structure of the tables. that way the forms will load but you will not have exposted and sensitive data. Compact and Repair and then zip up the db and see what size you have. If over 2MB then maybe one of the free file hosting sites.

[sdondeti]

Is it ok if i sent you personally, its important application my client is being used.
Thanks,

[RuralGuy]

Just open the db and go to Tools>Options>View tab and select "Show Hidden Objects".

[sdondeti]

Great, Appreciated. Thank you very much for your help.

How can i see the code from these macros objects?

[RuralGuy]

Just select one and go into design mode.

[sdondeti]

Hi RG,

Thank you for you help. I opened in Design mode it took me to a spread sheet with condition & action columns as below:
[Forms]![QA Home]![Selection Criteria]=1
Is there any thing i have to set properties to view the code?

Thanks,

[RuralGuy]

There is *no* code for a macro. It is a macro. Help might assist in understanding how macro's work. If you wanted, you could open a macro in design mode and then SaveAs Module which would create a module with the code that would do the same thing as the macro. You would then have a duplicate procedure and need to delete one of them or you would have an error if you tried to run.