Macro runs by itself (and it's not in autoexec)

[DrPat]

I have a macro which opens a query and prints a report based on that query. It's executed by a command button and it works fine.

Problem: The macro periodically runs without calling it.

I inserted a message box as the first command to alert me and remember what I did immediately prior the macro running. There doesn't seem to be any rhyme or reason to it.

Has anyone ever experienced this? Am i crazy? Is there a fix?

(You don't have to answer the second question)

Thanks,
Pat

 

[DrPat]

160 views and no one has had this happen to them or heard of it?

Anyone?

 

[pbaldy]

Never heard of it, and can't see how it could happen. Perhaps use a tool like V-Tools to search the entire db for the macro name. Maybe that will turn up where it's getting called from.

 

[DrPat]

I think that I 'fixed' it. If anyone's interested, I'll fill them in.

The DB in question has undergone a lot of amateurish editing (on my part of course) with lots of objects created, edited and deleted. I had a hunch that lots of unnecessary code was still resident.

My solution was to create a new database and import all the objects from the old one.

Guess what? No unwanted macro running and the DB runs faster.