M
Michael
I have an Access database that will on occasion ignore some of the VBA
code for various objects.
For example, I have a form which has code in the Form_Current event.
After a period of time, the code in the Form_Current sub will stop
being executed. There is no error reported by Access and there is no
error logged that I can find in the Event Viewer.
In order to "correct" the issue, I cut the code from the Form_Current
sub, save the form, and paste the code back into the Form_Current
sub. The code will then be executed again. The code is not changed,
I simply cut, save, and paste.
Using "/decompile" and then recompiling the code does not correct the
issue; it must be cut and pasted.
I have experienced this intermittently for some time now but twice now
in the past week. Once the issue happens for a given event, that
event will fail to execute the code until it is cut and pasted.
However, it isn't always the same event, nor is it the same object.
Sometimes it is the form current event sometimes it is a command
button click event; it varies. It also varies from object to object
happening on different forms.
I'm at a loss as to what causes the issue. Does anyone have any
recommendations on other things to check?
Thanks in advance,
Michael
code for various objects.
For example, I have a form which has code in the Form_Current event.
After a period of time, the code in the Form_Current sub will stop
being executed. There is no error reported by Access and there is no
error logged that I can find in the Event Viewer.
In order to "correct" the issue, I cut the code from the Form_Current
sub, save the form, and paste the code back into the Form_Current
sub. The code will then be executed again. The code is not changed,
I simply cut, save, and paste.
Using "/decompile" and then recompiling the code does not correct the
issue; it must be cut and pasted.
I have experienced this intermittently for some time now but twice now
in the past week. Once the issue happens for a given event, that
event will fail to execute the code until it is cut and pasted.
However, it isn't always the same event, nor is it the same object.
Sometimes it is the form current event sometimes it is a command
button click event; it varies. It also varies from object to object
happening on different forms.
I'm at a loss as to what causes the issue. Does anyone have any
recommendations on other things to check?
Thanks in advance,
Michael