Hello
I have been developing a case management database over the past few years, every 6 months I make a few changes like new forms or reports and then a case team use it. Never had any trouble or issues.
On the last update I had to convert the file to a 2007 format. The uses all have Microsoft 2010 and all databases open fine. But for some reason after a while the database just stops working. The main form on opening is there but the command button doesn’t work. Also even if I open other forms from the navigation bar, random command buttons don’t work. When I then go to the design of a form & look at the “on click” for the command buttons “Event Proceedure” is still there but when I click on that & open the VBA, the code is gone, just get:
Private Sub open_case_dets_Click()
End Sub
Luckily I keep a blank master of the database so I have just taken a clean master & copied over all the data BUT I need to prevent this from happening again.
Trusted locations is fine & the “Enable Content” pop up is always selected. I tried “compile & compact” tool, but still command button not working & code gone.
I dont think anything can be done to the "Broken" database so i am wondering if I should take the current blank master back up & sort that to prevent this issue from happening again. Perhaps a "Debug & Compile" and/or perhaps convert to accde
I am completely self taught – so go gently on me!
Many thanks in advance for any advice
:banghead:
I have been developing a case management database over the past few years, every 6 months I make a few changes like new forms or reports and then a case team use it. Never had any trouble or issues.
On the last update I had to convert the file to a 2007 format. The uses all have Microsoft 2010 and all databases open fine. But for some reason after a while the database just stops working. The main form on opening is there but the command button doesn’t work. Also even if I open other forms from the navigation bar, random command buttons don’t work. When I then go to the design of a form & look at the “on click” for the command buttons “Event Proceedure” is still there but when I click on that & open the VBA, the code is gone, just get:
Private Sub open_case_dets_Click()
End Sub
Luckily I keep a blank master of the database so I have just taken a clean master & copied over all the data BUT I need to prevent this from happening again.
Trusted locations is fine & the “Enable Content” pop up is always selected. I tried “compile & compact” tool, but still command button not working & code gone.
I dont think anything can be done to the "Broken" database so i am wondering if I should take the current blank master back up & sort that to prevent this issue from happening again. Perhaps a "Debug & Compile" and/or perhaps convert to accde
I am completely self taught – so go gently on me!
Many thanks in advance for any advice
:banghead:
Last edited: