I'm getting an intermittent error which I'm not sure how to track down.
It started last night. I was working on a form that I was happy with. I'd been 'testing' it as I went along and all was OK. I can't quite remember the sequence of events but I either closed access and reopened it or I restarted my project from within access and I got my first screen up screen A. I was then going to double click on an item on that screen which should bring up screen B. From there with a further double click it takes me to screen C the one I had been working on.
With the double click on screen A i get an error message saying file doesn't exists and I'm thrown into the VBA for screen C! Nothing was highlighted but I was thrown into design mode for screen C. screen B and screen C are instances(?) of a collection. Closing the screen C it stops the code. I then started to wonder what was going on trying to get to screen B in different ways. It suddenly started working again without me really doing anything. I tried it a few times and all was well. I out it down to access getting tangled up so ignored it until just now. I've just fired up the application and got the same error. Again I was trying to figure out what the problem is and it's gone again and I can't replicate.
So.....
What could it have been? How do you track these sort of errors down and get rid of them.
Oh and recently I've been getting access is not responding. It then wants me to save a backup and restart. What could be causing this and is it related to the above?
It started last night. I was working on a form that I was happy with. I'd been 'testing' it as I went along and all was OK. I can't quite remember the sequence of events but I either closed access and reopened it or I restarted my project from within access and I got my first screen up screen A. I was then going to double click on an item on that screen which should bring up screen B. From there with a further double click it takes me to screen C the one I had been working on.
With the double click on screen A i get an error message saying file doesn't exists and I'm thrown into the VBA for screen C! Nothing was highlighted but I was thrown into design mode for screen C. screen B and screen C are instances(?) of a collection. Closing the screen C it stops the code. I then started to wonder what was going on trying to get to screen B in different ways. It suddenly started working again without me really doing anything. I tried it a few times and all was well. I out it down to access getting tangled up so ignored it until just now. I've just fired up the application and got the same error. Again I was trying to figure out what the problem is and it's gone again and I can't replicate.
So.....
What could it have been? How do you track these sort of errors down and get rid of them.
Oh and recently I've been getting access is not responding. It then wants me to save a backup and restart. What could be causing this and is it related to the above?