General, random Access errors

[razorking]

So..I have a database that we have been using for some time. I made some minor changes today. Now I am seeing weird random error messages, usually when I try to open a form. Sometimes I get the parameter prompt thing, like it is expecting a field but cannot find it (as if you had removed it from the underlying query but not from the form). But the field it keeps prompting for still exists. also, this is clearly not it's issue because thertimes when you go to open the form it is happy as can be.

Other times clicking on the same button (to open a form) produces these VB errors. But other times no errors and everything works fine.

I have the databse set to open up at a form. That form has buttons to open other forms or do some other function. I can go in behind the scenes - Shift+open datbase - and twek around and maybe everything is working fine. Then I close it (it compacts on close) reopen it and there are the errors again. When it is working I can click the button, open and close the form over and over and it works great. Then I close and open the DB again and the errors are back. It's driving me crazy. How do I fix it if it is random or intermittent?

See attached image

 

[SOS]

Can you upload the database (I'm guessing not, but it doesn't hurt to ask) as it would be much easier to look around for problems than trying to come up with all sorts of possible things. Just my take on it.

 

[razorking]

Can you upload the database (I'm guessing not, but it doesn't hurt to ask) as it would be much easier to look around for problems than trying to come up with all sorts of possible things. Just my take on it.

I may be able to upload it. But, for the time being it seems to have settled down. I went in and changed all the buttons on the main form to use macros to open the forms associated with them, instead of using VBA to open the forms. And after that it has been good. I don't know if there is a direct correlation between my action and the result or maybe I just got lucky and it decided to settle down.

There must be some type of corruption somewhere. If it resurfaces I will try and upload the bugger.

Thanks!

 

[DCrake]

I know with mde's that if an error occurs Access just tells you that an error has occured when you clicked on a button say, but does not tell you the correct error. If you run it in the mdb you get the actual error that has occured. Are you running the in a complied state or not?

David