Form Broken after Compacting DB

[misssoysauce]

Hi,

I have created an Access 2000 database for work. It has the usual stuff, and one key form, which is a revenue calculator. I had not compacted my database for 2 weeks. When I did (a couple days ago) the all-important form now comes up with repeated error messages that say, 'run-time error 13' 'type mismatch'. All of my calculations are broken and come up with #Error in the field. Now I have looked at the help files for this, and I don't know what to do. The form worked perfectly before compaction... why is it doing this, and how can I fix it?? No one seems to have problems with compaction, why am I??

Thanks!

 

[lupins46]

It always does this for users with silly names-)

Try creating a new empty database and importing everything into it.
If you have used DAO syntax then make sure you have a reference set to DAO3.6 (you will not get this by default in A2000). If you have not used ADO then deselect the ADO reference.

 

[M8KWR]

go into your code window and run compile and save all module, and see if that brings up any errors.

Have you tried compacting it from another computer and seeing of that works.

 

[misssoysauce]

Thanks for your replies! But I still need help...

I tried compiling it and it didn't work. I can't try anything on a different computer because at the moment, I have the only computer with Access on it. After I tried the compiling, the form also now does not seem to work in the original DB, or the backup I made of it either. (it was working before). On the copy I compiled, the same '13' messages come up, along with some new ones, (but only sometimes) I think it's # 43, about automation problems. Now I am wondering, is this something wrong with my database as a whole, and I need to start over, or what??

What did I do?!?!

 

[lupins46]

It sounds like you might have reference problems.
Open any module and choose Tools>References.
If there are any marked as missing then you need to deselect and reselect the entry and you also need to be sure that the list of references is correct for your application. Once you have fixed this list close it and Debug>Compile again.

 

[misssoysauce]

I looked at the references, and it seems to be o.k. It's a very simple program, and it worked before. Could references un-tick themselves? Because otherwise I am puzzled as to why it was working and now seems to have quit.

I also created a new database and imported the necessary tables, queries and forms into it. When I run the calculator now, the error message says 'run time error 2447, There is an invalid use of the .dot, the !bang, or invalid parentheses. It highlights a bound field from the database, which really confuses me. There is no help file for this, and then when I click 'debug' it sends me to code that is in no way related to the bound field, nor does it have any . or ! and in the immediate window, the () work fine. Plus, it worked fine before! I am at my wits end with this thing, and completely out of ideas, other than taking it home and testing it on my computer.

Sigh... if you have any other suggestions, I would really love them.

 

[lupins46]

Did you say that you get no errors when you compile the application?

 

[misssoysauce]

yes, and I am hiding my head in shame because I figured it out. Long story short, when I remedied a previous problem I changed the data in one field, and then forgot to bring that change over to the calculator. My sincere apologies for being such a total nitwit!!

 

[lupins46]

No problem.