Form name doesn't exist error messge and I can't locate that form.

[matrix7410]

Hello,
Everytime I open up my database, I get an error message saying that my
form name "frmDataEntry" is misspelled or doesn't exist. I can not
locate this form name anywhere, eventhough I remember I had that name
but I deleted in. Is there any tips to locate this form name anywhere
in my database?

thanks!

 

[Jeanette Cunningham]

Hi
Do a backup then compact and repair. If you still get the error, check if
the name"frmDataEntry" is used in any macros, functions called from menus,
or as a startup form.
Have you searched the code for that form name?

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Al Campagna]

You can't locate the form, because it isn't there. That's why you're
getting an error.
You probably did delete the form, but somewhere in your code or macros,
you're still calling for it.
Just to be safe, use Tools/Options/View HiddenObjects = True.

Some prime suspects to check...
1. Is there a Macro by the name of AutoExec. AutoExec runs every
time the application is opened, and before any forms have opened.
(Hint: holding the shift key while starting your app will
bypass the AutoExec)
2. If you have a default form that loads upon opening the app,
check that for any reference to frmDataEntry.
3. Also check the query behind the default form.

Try those suggestions. I'm thinking it's the AutoExec macro...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[matrix7410]

    You can't locate the form, because it isn't there.  That's why you're
getting an error.
    You probably did delete the form, but somewhere in your code or macros,
you're still calling for it.
    Just to be safe, use Tools/Options/View HiddenObjects = True.

     Some prime suspects to check...
        1.  Is there a Macro by the name of AutoExec. AutoExec runs every
time the application is opened, and before any forms have opened.
             (Hint: holding the shift key while starting your app will
bypass the AutoExec)
        2.  If you have a default form that loads upon opening the app,
check that for any reference to frmDataEntry.
        3.  Also check the query behind the default form.

     Try those suggestions.  I'm thinking it's the AutoExec macro....
--
    hth
    Al Campagna
    Microsoft Access MVP
   http://home.comcast.net/~cccsolutions/index.html

    "Find a job that you love... and you'll never work a day in your life."







- Show quoted text -

Hey Al, you are absolutely correct about the autoExec Macro. I held
down Shift key and opened the database and I did not get the error
message. How I do now locate that autoMacro and can I delete it?
thanks!

 

[Al Campagna]

In the case of A97, Macros should have a tab on the database screen...
the same as Tables, Forms, Queries, Modules.
In 2003 in the Objects column.
Or... most versions, select View/Database Objects from the main menu.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

You can't locate the form, because it isn't there. That's why you're
getting an error.
You probably did delete the form, but somewhere in your code or macros,
you're still calling for it.
Just to be safe, use Tools/Options/View HiddenObjects = True.

Some prime suspects to check...
1. Is there a Macro by the name of AutoExec. AutoExec runs every
time the application is opened, and before any forms have opened.
(Hint: holding the shift key while starting your app will
bypass the AutoExec)
2. If you have a default form that loads upon opening the app,
check that for any reference to frmDataEntry.
3. Also check the query behind the default form.

Try those suggestions. I'm thinking it's the AutoExec macro...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."







- Show quoted text -

Hey Al, you are absolutely correct about the autoExec Macro. I held
down Shift key and opened the database and I did not get the error
message. How I do now locate that autoMacro and can I delete it?
thanks!

 

[King Feener]

trick the stupid access.
USE the shift key to get it started.
create a totally new form which access says is missing or misspelled.
the form can be blank
save it
NEXT do compact and repair data base and save a copy
then if you wish you can open the application and delete the fake form you created.

hth kF



Posted as a reply to:

Re: Form name doesn't exist error messge and I can't locate that form.

In the case of A97, Macros should have a tab on the database screen...
the same as Tables, Forms, Queries, Modules
In 2003 in the Objects column
Or... most versions, select View/Database Objects from the main menu
--
ht
Al Campagn
Microsoft Access MV
http://home.comcast.net/~cccsolutions/index.htm

"Find a job that you love... and you'll never work a day in your life.


Hey Al, you are absolutely correct about the autoExec Macro. I hel
down Shift key and opened the database and I did not get the erro
message. How I do now locate that autoMacro and can I delete it
thanks!

EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx

 

[Jeff Boyce]

If you use Compact & Repair BEFORE saving a copy, you risk losing your
database. Make a backup first.

--

Regards

Jeff Boyce
Microsoft Office/Access MVP