Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-27-2002, 05:51 AM   #1
CALV
Registered User
 
Join Date: Apr 2001
Location: UK
Posts: 74
Thanks: 0
Thanked 0 Times in 0 Posts
CALV
ON ERROR GOTO not working

Hi all,

Access2000

For some reason, on error goto doesnt work, it just breaks with an error rather then carrying out the GOTO, does anyone have any suggestions? I can stop it TOTALLY by removing the tick in startup/use special keys but I dont what that !! has anyone any suggestions?

CALV is offline   Reply With Quote
Old 03-27-2002, 10:35 AM   #2
cpod
Newly Registered User
 
Join Date: Nov 2001
Posts: 107
Thanks: 0
Thanked 0 Times in 0 Posts
cpod is on a distinguished road
The error handler can only handle one error at a time.

Are you clearing the error handler by executing a Resume, Exit Sub, Exit Function, or Exit Property statement? If the error handler is not cleared by running one of these statements before another error is encountered then that error will not be handled.
cpod is offline   Reply With Quote
Old 03-28-2002, 12:41 AM   #3
anna the third
Member
 
Join Date: Sep 2001
Location: Leuven,Vlaams Brabant,Belgium
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
anna the third
In the VBA interface
go to tools>options
select the "GENERAL" tab
under "ERROR TRAPPING"
see if "BREAK ON ALL ERRORS ISN'T CHECKED"

anna

anna the third is offline   Reply With Quote
Old 03-28-2002, 03:40 AM   #4
CALV
Registered User
 
Join Date: Apr 2001
Location: UK
Posts: 74
Thanks: 0
Thanked 0 Times in 0 Posts
CALV
Thanks for the replies, unfortunately Im off sick now so cant test it- it works fine here so the code is fine, I'll check for the tick on monday.
CALV is offline   Reply With Quote
Old 03-30-2002, 10:45 AM   #5
CALV
Registered User
 
Join Date: Apr 2001
Location: UK
Posts: 74
Thanks: 0
Thanked 0 Times in 0 Posts
CALV
Thanks a lot, it was the break on all errors that was causing it.

CALV is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 11:02 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World