I was reviewing some code in a vba standard module (not related to the open form) and all of a sudden it switched back to the form (which was in normal view). My hands were no where near the keyboard or mouse. I noticed the form flicker (no flicker prior to the switch). To my knowledge, I don't have a timer event. I do have a current event that hides/unhides text and changes some captions. I did a compact and repair (which I do at least once a day anyway) and when I opened up the accdb, all the code was gone. I copied a file from yesterday and when I opened I noticed a message at the bottom saying it was repairing and this too "lost" the code. I then created a new db from scratch and imported all the objects except for the vba and there was new table I hadn't seen before titled "MSysCompactError" and I opened it up and this was inside:
Anyone experience something like this? Could it be because I was using it on a network drive? This time, I have created the new db on my hd, but will still need to eventually link to data on the network.
It's a very small db (1,448kb) that I'm just starting to build. The only change since I closed the file yesterday and opened it today was to delete a record in a table (directly in the table not the form) and I decided to create a new module and move some code into the new module. The second time, I copied the backup and didn't do anything to the file. Hopefully creating a new db and importing the tables, queries and forms and manually pasting in the vba modules will solve the issue as I would be most disappointed if I can no longer use the work I've already done.
In the new db I have manually added in the vba code (copy/paste from a text file). Since the code behind form seems to still be there, I left it as is.ErrorCode ErrorDescription ErrorRecid ErrorTable
-1206 Could not find field 'Description'. MSysObjects
Anyone experience something like this? Could it be because I was using it on a network drive? This time, I have created the new db on my hd, but will still need to eventually link to data on the network.
It's a very small db (1,448kb) that I'm just starting to build. The only change since I closed the file yesterday and opened it today was to delete a record in a table (directly in the table not the form) and I decided to create a new module and move some code into the new module. The second time, I copied the backup and didn't do anything to the file. Hopefully creating a new db and importing the tables, queries and forms and manually pasting in the vba modules will solve the issue as I would be most disappointed if I can no longer use the work I've already done.