 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / January 2006Err.Number does not work
I get a zero and a blank when I write err.number and err.description into my error MsgBox. If I write error$ I get a message with no number. There wa a similar question posted on 11/21 and I tried the suggested solution to no avail. Thank you for your consideration. I'm not sure why the Err.Description doesn't work I just use Err to get the number, and Error to get the description.  Signature\\// Live Long and Prosper \\// > I get a zero and a blank when I write err.number and err.description into my > error MsgBox. > If I write error$ I get a message with no number. > There wa a similar question posted on 11/21 and I tried the suggested > solution to no avail. > Thank you for your consideration. Thanks, Ofer. That worked just fine. > I'm not sure why the Err.Description doesn't work > I just use Err to get the number, and Error to get the description. [quoted text clipped - 5 lines] > > solution to no avail. > > Thank you for your consideration. > I get a zero and a blank when I write err.number and err.description > into my error MsgBox. > If I write error$ I get a message with no number. > There wa a similar question posted on 11/21 and I tried the suggested > solution to no avail. > Thank you for your consideration. It sounds like you're accessing the Err object when there's no error, or the original error has been cleared. Please post the relevant code. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) Normally you code like this: Exit Sub Catch: MsgBox Err.Number & ": " & err.description End Sub If you accidentally loose the "Exit Sub" line you will get the problem you are reporting. (david) > I get a zero and a blank when I write err.number and err.description into my > error MsgBox. > If I write error$ I get a message with no number. > There wa a similar question posted on 11/21 and I tried the suggested > solution to no avail. > Thank you for your consideration. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.