HELP! Form doesn't exist/module not found

Hi. I was trying to clean up my database and found I wasn't using a form
(FormName). So I changed the name to (~FormName). Then I deleted
(~FormName).

I can no longer see (~FormName) in the database window (where you select
tables, queries, forms...). However, in the VB code window on the side bar,
I see Form_~FormName. When I select the code, I receive an error message
"The form name is misspelled or refers to a form that doesn't exist". True.
But I can't cut or delete the form out of the list of forms.

As you can imagine, my db is not working at all with the bogus reference.
When I try to compact and repair, this error msg appears: table
TempMSysAccessObjects already exists. With no opportunity to change the temp
table name (even if I knew what that meant).

I thought I was doing the right thing renaming the form and then deleting
it. What did I do wrong and can it be saved. Thanks!

Sorry- I'll repost in the configuration group...



"Stephanie" wrote:

Hi. I was trying to clean up my database and found I wasn't using a form
(FormName). So I changed the name to (~FormName). Then I deleted
(~FormName).

I can no longer see (~FormName) in the database window (where you select
tables, queries, forms...). However, in the VB code window on the side bar,
I see Form_~FormName. When I select the code, I receive an error message
"The form name is misspelled or refers to a form that doesn't exist". True.
But I can't cut or delete the form out of the list of forms.

As you can imagine, my db is not working at all with the bogus reference.
When I try to compact and repair, this error msg appears: table
TempMSysAccessObjects already exists. With no opportunity to change the temp
table name (even if I knew what that meant).

I thought I was doing the right thing renaming the form and then deleting
it. What did I do wrong and can it be saved. Thanks!

Did you ever get a solution to this problem? If so, what was it?

"Stephanie" wrote:

Hi. I was trying to clean up my database and found I wasn't using a form
(FormName). So I changed the name to (~FormName). Then I deleted
(~FormName).

I can no longer see (~FormName) in the database window (where you select
tables, queries, forms...). However, in the VB code window on the side bar,
I see Form_~FormName. When I select the code, I receive an error message
"The form name is misspelled or refers to a form that doesn't exist". True.
But I can't cut or delete the form out of the list of forms.

As you can imagine, my db is not working at all with the bogus reference.
When I try to compact and repair, this error msg appears: table
TempMSysAccessObjects already exists. With no opportunity to change the temp
table name (even if I knew what that meant).

I thought I was doing the right thing renaming the form and then deleting
it. What did I do wrong and can it be saved. Thanks!

Sorry- I don't often check old posts.

Look at this;
http://www.microsoft.com/office/comm...xp=&sloc=en-us

"gm2149" wrote:

Did you ever get a solution to this problem? If so, what was it?

"Stephanie" wrote:

Hi. I was trying to clean up my database and found I wasn't using a form
(FormName). So I changed the name to (~FormName). Then I deleted
(~FormName).

I can no longer see (~FormName) in the database window (where you select
tables, queries, forms...). However, in the VB code window on the side bar,
I see Form_~FormName. When I select the code, I receive an error message
"The form name is misspelled or refers to a form that doesn't exist". True.
But I can't cut or delete the form out of the list of forms.

As you can imagine, my db is not working at all with the bogus reference.
When I try to compact and repair, this error msg appears: table
TempMSysAccessObjects already exists. With no opportunity to change the temp
table name (even if I knew what that meant).

I thought I was doing the right thing renaming the form and then deleting
it. What did I do wrong and can it be saved. Thanks!