Macro Blank

[grizzfan]

We built a database and went to move it to a different computer. The database linked fine, but when we went to run one of the macros, it was blank.

The weird part is there are other macros in the database and they are there. For some reason, this one macro shows blank.

Is there a simple fix for this?

Thank you!

 

[ranman256]

Odd, but view the macro on the original PC.
try exporting it to the copy,
or
write down the steps,then rebuild it on the target PC.

 

[grizzfan]

I would, but there are many "If" actions built into the macro.

I was trying to look online and I was curious if the "Macro Settings" under the Trust Center may have something to do with it...

 

[grizzfan]

The message I receive is

"Cannot open or run macro 'macro name,' because it is not valid.

 

[Micron]

Just guessing here because I don't use macros.
Look at the list of references and see if any are marked "missing". Alt F11 should open a vbe window, and the references dialog is available from the Tools menu. Maybe the macro uses a method or something that it needs but can't find on the 2nd pc. If the other macros work, it probably isn't a Trusted Locations issue.

If that doesn't help, there must be an error number associated with the error message?
Did you simply copy this db to another pc, or did you create a new db there and import everything? If the latter, maybe you forgot to import a module or something else that's needed.