Hi,

I have an access database (ver 2000). When I open the database, i get an error message

 "You cancelled the previous operation"

Also, when I try and open and compile a for, I get another error message :

 "The form name Form1 is mispelled or refers to a form that doesn't exist".

The second error is a bit strange as I havent had any forms called "Form1" or any macros etc.

PLEASE HELP!!!




Ta!

Tim

Tim

__________________
Tim

Take a look at where the debugger stops in your VBA code. That error message usually means that you used a function where an argument for it is misspelled or is calling a table, field, form, report, etc. that doesn't exist.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Hi Greg,

Many thanks for your reply!!!

it seems to stop at the "Option Compare Database" line at the very top of the VB code (happens on any form I open).

Any ideas?????



Tim

I don't see how that line causes that problem. Try recompiling the database.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Do you get the error if you open the mdb while holding down a shift key? Do you have any missing references? Have you tried creating a new empty db and importing everything into the new db?

HTH RuralGuy (RG for short) acXP WinXP Pro

Hi tim did u solve the prob , if not try to sent the error commend that u hsve in the VB module (cupy & paste the comm ) in the mess then we can analys the prob .If ur not have "From1" then in the place of "From1" type the from name that u have (del & type)\*""TRY THIS ONE""*
 Bye
 Pap

ive got a similar problem like this, i have an existing Access97 database that works fine, however after converting to Access2003 when i open it, it says "The form name MEDREC is misspelled or refers to a form that doesnt exist. If the invalid form name is in a macro, an Action Failed dialog box will display the macro name and the macro's arguments after you click OK. Open the Macro window, and enter the correct form name".

However when i click OK i dont have access to correct the form name and the dialog box just shuts down and i cannot access the database.

In any case, i know that from opening it in Access97 the form name MEDREC does indeed exist. so i dont know what is going on. I tried holding shift button down while opening and this time i at least got access to the tables, queries, forms whereby the form MEDREC wasnt there.

Any ideas? thanks.

Hi,

Sounds like the mdb file is damaged or something. I think you may try Advanced Access Repair at http://www.datanumen.com/aar/. This tool is rather useful in salvaging damaged Access MDB files.

Hope this helps.

Alan


fyz

This problem occurs when you use some reserve word or a corrupt form or database. In this situation you should replace the bad form with a copy from a backed up version of the database. If still you get error then use access repair utility. You can use stellar phoenix access recovery utility which repairs forms, tables even modules and macros.
Download link: http://www.repair-access-file.com
Hope it helps