Hi, I just found an error on my db and was looking for some advice.
I was working on my forms, looking to improve some things, when by mere accident I clicked the compact & repair button. After that, the welcome form started giving me error #5.
Looking through, the problem was the Select case statement, some thing like this:
Then I found the same error on other forms, but decided it was too much to investigate so I gave up.
But then, just for curiosity, tried to repair another backup, and the errors also appeared, so it was not an isolated problem.
I have tried to repair the db againt, tried to import the same forms from a backup, tried reinstalling the references but nothing seems to work so far.
Any idea what could have happened?
Meanwhile I am going to try to save all the forms that I do not have on the back up, but I'm afraid that this error could appear again any time on the future.
I was working on my forms, looking to improve some things, when by mere accident I clicked the compact & repair button. After that, the welcome form started giving me error #5.
Looking through, the problem was the Select case statement, some thing like this:
Code:
Dim str as String
str = function() 'funcion gives back a "F" or a "M"
Select case Str
case "M" ' HERE COMES THE ERROR'
Then I found the same error on other forms, but decided it was too much to investigate so I gave up.
But then, just for curiosity, tried to repair another backup, and the errors also appeared, so it was not an isolated problem.
I have tried to repair the db againt, tried to import the same forms from a backup, tried reinstalling the references but nothing seems to work so far.
Any idea what could have happened?
Meanwhile I am going to try to save all the forms that I do not have on the back up, but I'm afraid that this error could appear again any time on the future.