By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,894 Members | 1,942 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,894 IT Pros & Developers. It's quick & easy.

error code that trigged "on error" branch

P: 2
Folks:

I'm an Access newbie, trying to modify an existing application and running into an error that I don't understand.

A tree view control is being loaded from an Access table and the "on error" branch is being triggered for reasons beyond me.

How do I find the actual error Access error code ( for which there would presumably be more information available ) that triggered the "on error" ?

I have a breakpoint set and don't know what to type into the debugger window to retrieve the code.

Thanks much.
Jan 4 '08 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,491
In the first line after the error is trapped (probably the line after the label you skip to in the On Error statement) add :
Expand|Select|Wrap|Line Numbers
  1. Call MsgBox("Source      = " & Err.Source & vbCRLF & _
  2.             "Number      = " & Err.Number & vbCRLF & _
  3.             "Description = " & Err.Description)
Jan 4 '08 #2

P: 2
In the first line after the error is trapped (probably the line after the label you skip to in the On Error statement) add :
Expand|Select|Wrap|Line Numbers
  1. Call MsgBox("Source      = " & Err.Source & vbCRLF & _
  2.             "Number      = " & Err.Number & vbCRLF & _
  3.             "Description = " & Err.Description)
Beautiful, thank you very much.
Jan 4 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.