Error message: Form doesn't exist

[Guest]

I created a macro to call a form and later on I deleted both the macro and
the form. However, Access keeps sending an error message whenever I start it.
The message says "the form name XXX is misspelled or refers to a form that
doesn't exist."

How can I stop the annoying messge coming up again?

Thanks,

 

[Steve Schapel]

C.D.,

Do you have an AutoExec macro which references the deleted form?
Have a look under the database's Tools|Startup menu, and see if the form
is nominated there in the Display Form/Page setting.
If not, do you have another form nominated as Display Form/Page on
startup? If so, check any code or macro on this form, for example Open,
Load, Current events, to see if it is referencing the deleted form.

 

[Guest]

Hi, Steve, Thank you. the problem has been solved. It was in the start up
option.

Another question. I use a switchboard to access some reports. How to make
those reports stay before the switchboard after they are opened? and in full
size?

 

[Steve Schapel]

C.D.

If the report is previewing behind the switchboard form, it would
possibly indicate that the Popup property of the switchboard form is set
to Yes. If so, consider whether this is really necessary. If it is,
then you will have to include actions in the report-previewing macro to
either close, hide, or minimize the switchboard, and then another macro
to open, unhide, or maximize it on the Close event of the report.

You can use the RunCommand action in a macro, and then the Command of
Zoom x% (you have a number of choices), for controlling the display of
the report preview.

 

[Guest]

Thank you very much, Steve.

I checked the Popup property of the switchboard and found it is set to NO.
This switchboard also calls other reports created by others and all of these
reports show on top of the switchboard. I have compared the properties of
these report and didn't see any difference from my reports.

I cannot use a macro to close the switchboard because my reports are created
for other users who may want to view more and may not know how to find the
switchboard again.

Really appreciate your help.

 

[Guest]

And please offer more input if you know the answer to my problem posted in
the previous message.

Thank you,

 

[Steve Schapel]

C.D.

You could try a Select Object action after the OpenReport action, to
bring the report preview to the front.