|
 |
access thread: Error 0
Message #1 by "Ajay Jain" <ajain@i...> on Thu, 25 Jul 2002 11:55:36 -0400
|
|
Hello All:
I am facing this wierd problem of Error 0. I open a report in preview mode
on click of a button on form. In the ReportHeader_Format event I have error
handler label
On Error GoTo er
........statements
er:
Fx_RegisterError
"Report_rptMonthlyTrend_PayErrorRates.ReportHeader_Format", "Error # " &
Err.Number & " : " & Err.Description
I am logging all the errors in database through this function. Now,
everytime I fire this report the control goes to Error handler label
alwyays. It happens in all other events also. The Error number I see is 0
and Error description is blank. What could be the reasons behind this Error
0.
Any help is highly appreciated.
Thanks
Ajay
Message #2 by braxis@b... on Thu, 25 Jul 2002 17:30:12 +0100 (BST)
|
|
Ajay
I suspect that you've left out the exit sub (or exit function for functions) command just before your error handler label.
So, every time you run through the code, the error reporting code is running, even though there is no error to report.
Brian
> from: Ajay Jain <ajain@i...>
> date: Thu, 25 Jul 2002 16:55:36
> to: access@p...
> subject: Re: [access] Error 0
>
> Hello All:
>
> I am facing this wierd problem of Error 0. I open a report in preview mode
> on click of a button on form. In the ReportHeader_Format event I have error
> handler label
>
> On Error GoTo er
> ........statements
>
>
>
> er:
> Fx_RegisterError
> "Report_rptMonthlyTrend_PayErrorRates.ReportHeader_Format", "Error # " &
> Err.Number & " : " & Err.Description
>
> I am logging all the errors in database through this function. Now,
> everytime I fire this report the control goes to Error handler label
> alwyays. It happens in all other events also. The Error number I see is 0
> and Error description is blank. What could be the reasons behind this Error
> 0.
>
> Any help is highly appreciated.
>
> Thanks
> Ajay
>
>
Message #3 by "Gerald, Rand" <RGerald@u...> on Thu, 25 Jul 2002 12:24:03 -0500
|
|
ALWAYS precede the error-handler logic with an Exit Sub statement.
Failure
to do so will cause the logic to fall into the error handler with an
error
cold of zero even if there is no error.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Ajay Jain [mailto:ajain@i...]
Sent: Thursday, July 25, 2002 10:56 AM
To: Access
Subject: [access] Error 0
Hello All:
I am facing this wierd problem of Error 0. I open a report in preview
mode
on click of a button on form. In the ReportHeader_Format event I have
error
handler label
On Error GoTo er
........statements
er:
Fx_RegisterError
"Report_rptMonthlyTrend_PayErrorRates.ReportHeader_Format", "Error # "
&
Err.Number & " : " & Err.Description
I am logging all the errors in database through this function. Now,
everytime I fire this report the control goes to Error handler label
alwyays. It happens in all other events also. The Error number I see is
0
and Error description is blank. What could be the reasons behind this
Error
0.
Any help is highly appreciated.
Thanks
Ajay
Message #4 by "Gerald, Rand" <RGerald@u...> on Thu, 25 Jul 2002 12:59:08 -0500
|
|
Error cold of zero
Make that Error code of zero.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Gerald, Rand [mailto:RGerald@u...]
Sent: Thursday, July 25, 2002 12:24 PM
To: Access
Subject: [access] RE: Error 0
ALWAYS precede the error-handler logic with an Exit Sub statement.
Failure
to do so will cause the logic to fall into the error handler with an
error
cold of zero even if there is no error.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Ajay Jain [mailto:ajain@i...]
Sent: Thursday, July 25, 2002 10:56 AM
To: Access
Subject: [access] Error 0
Hello All:
I am facing this wierd problem of Error 0. I open a report in preview
mode
on click of a button on form. In the ReportHeader_Format event I have
error
handler label
On Error GoTo er
........statements
er:
Fx_RegisterError
"Report_rptMonthlyTrend_PayErrorRates.ReportHeader_Format", "Error # "
&
Err.Number & " : " & Err.Description
I am logging all the errors in database through this function. Now,
everytime I fire this report the control goes to Error handler label
alwyays. It happens in all other events also. The Error number I see is
0
and Error description is blank. What could be the reasons behind this
Error
0.
Any help is highly appreciated.
Thanks
Ajay
|
|
|
View Cart
