Any Help with an Access Lockup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help please

Whilst running through my code I have suddenly got a Microsoft Access
dialogue box that says "Object variable or With block variable not set" It is
not one of my Dialogue's and must be system generated, however it has Locked
the whole of my Access enviroment up. All it does is create an annoying
"Donk" when I click on the "OK" Button and I can not move it or get into the
code to find out what I have done. It looks as though the only way I can
resolve the problem is to terminate the process via a "Ctrl Alt Del" probaply
loosing all the work I have done today.

Can anyone help?

Thanks Ray C
 
Hi Ray,

Have you tried CTRL-Break to cancel the code that may be running, or Alt-Tab
to switch to another application then back to Access (sometimes there is a
hidden message box that can be unhidden with this technique).

Otherwise, you are learning a valuable lesson - save once, save often.

Damian.
 
Hi Damian
I could switch to other open applications easily but do nothing with Access.
I did not know about trying tCTRL-Break and will remember that next time. In
the End I neede to do something and stoped the process via CTRL-ALT-DEL Task
Manager. Luckily I did do some backups as I was working so I did not loose to
much.

Lesson learned though ALWAYS Back Up before trying out any new Code.

Thanks so much for your help.

Regards RayC
 
Back
Top