Error Messages

[Guest]

I get these messages 4 times each every time I open Access 2003. How can I
correct or delete the problem?

1. "The report name 'Name Tag' you entered is either the property sheet or
macro is misspelled or refers to a report that doesn't exist."

2. "The form name 'Names' is misspelled or refers to a form that doesn't
exist."

I think in both cases, they have been deleted. Also there are no macros seen
in database...

Help.

 

[Guest]

Go into Tools--Database Utilities and do a compact and repair. If that does
not fix your problem, create a new database and import all your existing
objects (forms, tables, queries, reports, modules etc.) to it.

Does your database compile? If not, correct any errors so it does.

Dorian

 

[Guest]

Do these messages appear when you open Access by itself or when you attempt
to open an MDB file?

Ray

 

[Guest]

First and easiest, see if you have a macro named Autoexec. If you do, rename
it and try to open it again.

Access will alway run a macro named Autoexec on startup if it finds one.

 

[Guest]

I did a compact and repair, but it didn't seem to make any difference.

RE: create a new database. I have a large database (3390 records with 90
fields each). How would I go about doing that?

 

[Guest]

Before you do all that, there are still a couple of things to check out.
First, there could be an Autoexec Macro,and it is hidden. To see if it is
there, go to Tools, Options, View tab, and check the Hidden Objects check box
in the Show section. Now see if it is there.

Also, Tools, StartUp and see if there is anything in the Display Form/Page.
If there is, there is a form opening that has code that is causing the
problems.

Have you tried holding down the Shift Key when you open the database?
Unless AllowBypassKeys has been turned off, that will allow you to bypass any
start up code.

 

[Guest]

I think it only happens when I open my main database - a mdb file. The
software or other databases don't have the problem.

 

[Guest]

Don't have a macro named Autoexec. I don't have any macros...

 

[Guest]

Plese see my last post. I really think it will resolve your problem,
particulary based on your response to Ray.

You will only get the messages you are getting when some code is trying to
execute. Code only excutes when you open an mdb file when either there is a
Macro named autoexec or if you have a form that opens when the database is
opened.

Even if you create a new database and copy all the objects from the existing
database, it will bring the Autoexce macro with the other objects.

You would be doing yourself a favor to look at the things I suggested.

 

[Guest]

Go into Tools-->Startup and see if your have something in the startup form
field at the top right hand corner. If you do have the name of a form there,
then go into that form and see if there is a Form_Open or Form_Load event
with code in it. That's probably the code that's causing the error.

 

[Guest]

Did you not read my last post? It may be hidden. Also, did you check your
start up options?

 

[Guest]

Yes, I have read all the Replys and have done what everyone has suggested.
Nothing to at this time has taken care of the problem.

I am convenienced it has to do with "refers to a Report that doesn't exist."
Is there a place to clear out code "behind" what I can see in the software?
Why is it trying to run a report that no longer exists?

 

[Guest]

If there is no autoexec macro and no form identified to run on startup, this
is a very unusual situation. If neither of the above exist Access should do
nothing when you open it. It may be you have a corrupt database. The first
thing to try would be a decompile. See this site for info on this:
http://www.mvps.org/access/bugs/bugs0008.htm

If that does not resolve the problem, then the next step would be to create
a new mdb file and copy all the objects from the old mdb to the new one.

Please let me know how this turns out. I have never seen a problem like
this before and would like to know the outcome for future reference.

Good luck.