Report

T

Tony9703

I created a report. It required no Macros. At some point, I was
experimented with a Macro. It was accidentally saved as Macro1. Today, I
saw it and deleted it, knowing it was inconsequential. However, when I went
to open my report it said it couldn't find Macro1. I create a blank macro,
and titled it Marcro1. My report then opened. I deleted it again, and tried
to open the report. Again, it wouldn't open. I figured out that it does
open under design view, but that's it. What happened? Is there anywhere I
can check to see if there is a relationship between the two that I wasn't
aware of (I guess that would make it an affair by definition)? I checked
relationships and object dependencies and there's nothing there, at least.
 
L

Lynn Trapp

Tony,
Open your report in design view. Open the property sheet for the report and
see if Macro1 is in any of the fields.
 
L

Lynn Trapp

Ok. You may find it attached to one of the controls on your report then.
Check the property sheet for every control on the report.

Do you have any code behind your report?
 
J

Jeff Boyce

If the Macro1 is not referenced anywhere in sight...

This may be totally out in left field ... does the Original Poster have
Track Name AutoCorrect checked on in Tools/Options?

If so, what happens if it is unchecked, the database Compacted & Repaired,
and the report retested w/o Macro1?

Jeff Boyce
Microsoft Office/Access MVP
 
J

James

Im looking for a job with computers but I have no college classes top back
me . Any help ?
 
Top