Want ALL remnants of missing form deleted from module

G

Gannonator

How can I delete all remnants of a deleted form? Every time mdb is opened,
user is presented with error message saying "form_xyz is missing or
misspelled. If you are opening a Macro then..." blah, blah, blah. It's
irritating because the form is no longer needed.
I've gone through every Macro, Query, and went to the VB module (Alt+F11) to
delete all references to it, but no joy.

Can you tell me how I can completely remove any references to a deleted Form?
 
R

Roger Carlson

Go to this site: http://www.rickworld.com/download.html and download the
program "Find and Replace" for your version of Access. It's a great tool.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Gannonator said:
How can I delete all remnants of a deleted form? Every time mdb is opened,
user is presented with error message saying "form_xyz is missing or
misspelled. If you are opening a Macro then..." blah, blah, blah. It's
irritating because the form is no longer needed.
I've gone through every Macro, Query, and went to the VB module (Alt+F11) to
delete all references to it, but no joy.

Can you tell me how I can completely remove any references to a deleted
Click to expand...
Form?
 
D

Dirk Goldgar

Gannonator said:
How can I delete all remnants of a deleted form? Every time mdb is
opened, user is presented with error message saying "form_xyz is
missing or misspelled. If you are opening a Macro then..." blah,
blah, blah. It's irritating because the form is no longer needed.
I've gone through every Macro, Query, and went to the VB module
(Alt+F11) to delete all references to it, but no joy.

Can you tell me how I can completely remove any references to a
deleted Form?
Click to expand...

It sounds like that form is set as the startup form. Click Tools ->
Startup... and change the Display Form/Page option to "(none)".
 
G

Gannonator

Thanks Dirk; that prevents the message at the startup of the mdb. However,
Compact and Repair still brings up the message several times. There must be
references to the form in many more places.
The exact verbage is "The form name "Gifting" is misspelled or fefers to a
form that doesn't exist" (Yah)

The Startup did not call for this form, but, setting Startup to "none" lets
us open the mdb without seeing it. The users don't Compact and Repair. I do.
 
G

Gannonator

Roger;
I went there and downloaded it. Installed on my desktop and it seems to have
solved the problem... for me. Desktop only.
Our environment uses Terminal Services for all of the Users. Going to the
server, and running the mdb as a USER, from the source location, the same
annoying error message comes up. I tried to install it on the file server
(where the Users are) as Admin (so I had all the rights) and sent about 4
error messages to Microsoft as the mdb had to close and repair itself.
But,,, it seemed to work on a stand-alone desktop. Thanks.
 
Top