Form - All controls on form stop working and return error

[vad77]

I have this problem on a form where all controls stop working and return an error.


It could be any event, On-Current, After Update, On-Click. To get things working again all I have to do is go into desgin mode and open up the VBA code window. I do not need to make any changes to code just open and then close it again and all the controls start working again. This happens every time I close and open the database. I did a compact and repair on the database but it does not correct the issue. I even rebooted my pc and still it keeps happening.
Does anyone know why this happens and how I can correct the database so it won't happen again?
If a copy of my database is needed to answer the question please let me know so I can prepare a copy of the databse with just sample data.
Thanks in advance for your responses.

9:15 - I had stated that I did not have to go into VBA to clear the problem, that is no longer true.

[John_G]

Are you compiling your VBA code after you update it? It could be a compile error somewhere. In the VBA code window, select debug - compile.

[vad77]

That's the thing I don't need to edit any code just open the VBA window and close it, go back to form view and everything is working. I did a complie and it did not detect any errors. Here is the thing there were no changes made to the as far as BA code is concerned. Just some table, form and querey changes. Basiclly I added a couple of fields to my database. But it was working fine after the changes. I came back from vacation opened it and this started happeing.
Another thing when I first created this database a year ago I did start it out as a FE/BE type since I thought other people needed access. I named the front end with FE at the begging of the file name. When I discovered I was the only one to maintain this data I scratched the FE/BE deal and renamed the file removing the FE. When I am in the VBA window it has the original name of the file at the top. But that's the way it has been all along and I never had any problems except when I fat fingered code and had to correct. But nothing like this before. Don't know it that makes any difference but just thought I mention it. I also have an audit trail built but that is working fine.

[lfpm062010]

Not sure if this will fix your problem.

If your database is still FE/BE, did you re-link your table after you change/add fields on the tables.

[vad77]

No it no longer is a FE/BE, before I finished designing and building the database early last year it wwas determined I was the only person to access and maintain database. So when I starting using it it was a standard database. I maintain a list of contractors that used to be maintained on an Excel spreadsheet. When I took over I moved it to Access and then export the data once a month to excel and send it out.

[Missinglinq]

Has the code ever run without opening in Design View and then running it in Form View? If 'no,' I suspect that the Folder the file resides in needs to be declared as 'Trusted.'

To "Trust" your folder, click:

• Office Button (top left)
• Access Options (bottom of dialog)
• Trust Center (left)
• Trust Center Settings (button)
• Trusted Locations (left)
• Add new location (button)

Access will run code, when going from Design View to running it, in Form View, even with the Folder not 'trusted,' but will balk when opened directly in Form View, under the same conditions.

Linq ;0)>

[vad77]

Sorry for such a delay is responding as last week was a really busy week. Yes my database resides in a trusted folder. As of lFriday the problem seems to have cleared itself, don't know why or how but all controls work on open. I can't explain the reason or a fix but just that it started working again. So I will close this thread with no clear solution as to a fix.

[Missinglinq]

...As of Friday the problem seems to have cleared itself...

Don't you hate when that happens! I'd be especially careful, given what's already happened, to make frequent backups!

Glad you're up and running, again!

Linq ;0)>

[vad77]

I have a program called FBackup5 which automaticlly backups all my databases twice a day. I also back it up manually just before I am going to make major changes.