How to enable the scripting error warnings again?

[James Bowyer]

When I try to run a script that isn't working, instead of popping up with the error message and taking me to viasual basic showing me where the problem is, it does nothing!!

Very annoying as I cant tell where any problems are!

What have i done to it?

[TheSmileyCoder]

What may have happened is that you have used a command like:

On Error Resume Next

basicly telling the program to ignore errors.
To resume normal error handling you can write:

On Error Goto 0

There are probably other ways you can achieve what you have done, by modifying the settings, but before looking into all that I would start by rebooting your PC and see if that doesn't solve the problem.

[James Bowyer]

Nope, I tried writing that AFTER I had the original problem just to see if I could get the code to run.

[TheSmileyCoder]

Is your error handling disabled for all your code?

Is your code running at all? Have you tried putting a

msgbox "Test" 

at the beginning of the code to verify that it is indeed running?

Otherwise try doing a decompile. You can achieve this by selecting (Windows) Start ->Run and typing:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /decompile

(Modify as appropriate) and then open your database while holding down SHIFT, and then open VBA and select Debug->Compile.

Hope some of that helps.

TheSmileyCoder

[James Bowyer]

That worked! Yay! (the decompile Bit)

Thankyou very much!

[TheSmileyCoder]

Yay - Im happy to hear that.
TheSmileyCoder