If you ever suddenly find that trapping Error 2501 when a report has no data
no longer works, don't do what I did and spend 3 hours looking for a
non-existent bug, simply check that the "Break in Class Module" option is
selected.
We recently had a change in IT provider and I'm guessing that some of their
hocus-pocus tampered with my Access settings ... GRRR!
Keith. www.keithwilby.com 6 1738
On Wed, 30 May 2007 10:45:59 +0100, "Keith Wilby" <he**@there.com>
wrote:
That setting is machine specific. Did your IT firm make this
adjustment on your machine? Seems unlikely, but a handy scapegoat it
is.
-Tom.
>If you ever suddenly find that trapping Error 2501 when a report has no data no longer works, don't do what I did and spend 3 hours looking for a non-existent bug, simply check that the "Break in Class Module" option is selected.
We recently had a change in IT provider and I'm guessing that some of their hocus-pocus tampered with my Access settings ... GRRR!
Keith. www.keithwilby.com
"Tom van Stiphout" <no*************@cox.netwrote in message
news:80********************************@4ax.com...
On Wed, 30 May 2007 10:45:59 +0100, "Keith Wilby" <he**@there.com>
wrote:
That setting is machine specific. Did your IT firm make this
adjustment on your machine? Seems unlikely, but a handy scapegoat it
is.
I've no idea Tom, all I know is that the error trap suddenly stopped working
and it roughly coincided with the takeover. It isn't a setting I'd change
and the new provider has brought all sorts of policy changes. I'm not
suggesting they'd do this on purpose but it might have been a side-effect
another change.
I have a question - if the setting is machine specific then will the error
handling fail on other machines if the "default" setting is "Break on all
errors" even though I've set the option otherwise? If it is machine
specific then it's not much use in this respect.
Regards,
Keith.
"Tom van Stiphout" <no*************@cox.netwrote in message
news:80********************************@4ax.com...
On Wed, 30 May 2007 10:45:59 +0100, "Keith Wilby" <he**@there.com>
wrote:
That setting is machine specific.
Tom, the help would tend to suggest otherwise:
"Specifies the settings, error handling, and compile settings for your
current Visual Basic project."
Regards,
Keith.
On Wed, 30 May 2007 16:36:07 +0100, "Keith Wilby" <he**@there.com>
wrote:
I wasn't sure myself, you I set it in project 1, opened project 2 and
it was set the same way, set it to another value and reopened project
1 and it was set to this other value. So I concluded it was machine
specific, not db specific.
-Tom.
>"Tom van Stiphout" <no*************@cox.netwrote in message news:80********************************@4ax.com.. .
>On Wed, 30 May 2007 10:45:59 +0100, "Keith Wilby" <he**@there.com> wrote:
That setting is machine specific.
Tom, the help would tend to suggest otherwise:
"Specifies the settings, error handling, and compile settings for your current Visual Basic project."
Regards, Keith.
On Wed, 30 May 2007 16:04:19 +0100, "Keith Wilby" <he**@there.com>
wrote:
Another change?
That would have to be a registry change (I'm thinking that's where
Access would save this option). Not impossible, but not very likely
either.
Are you sure you didn't set this option programmatically (SetOption)?
-Tom.
>"Tom van Stiphout" <no*************@cox.netwrote in message news:80********************************@4ax.com.. .
>On Wed, 30 May 2007 10:45:59 +0100, "Keith Wilby" <he**@there.com> wrote:
That setting is machine specific. Did your IT firm make this adjustment on your machine? Seems unlikely, but a handy scapegoat it is. I've no idea Tom, all I know is that the error trap suddenly stopped working and it roughly coincided with the takeover. It isn't a setting I'd change and the new provider has brought all sorts of policy changes. I'm not suggesting they'd do this on purpose but it might have been a side-effect another change.
I have a question - if the setting is machine specific then will the error handling fail on other machines if the "default" setting is "Break on all errors" even though I've set the option otherwise? If it is machine specific then it's not much use in this respect.
Regards, Keith.
"Tom van Stiphout" <no*************@cox.netwrote in message
news:i8********************************@4ax.com...
On Wed, 30 May 2007 16:04:19 +0100, "Keith Wilby" <he**@there.com>
wrote:
Another change?
That would have to be a registry change (I'm thinking that's where
Access would save this option). Not impossible, but not very likely
either.
Are you sure you didn't set this option programmatically (SetOption)?
No that I know of. It could very well be operator incompetence but I think
I'd have remembered making that change. Anyway, all is well now :-)
Keith. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: ColinWard |
last post by:
My previous message was blank so Im trying again. I have a button on a
form which opens the Import dialogue box. This works fine except if I
click on the "X" to close the form I get Run-Time Error...
|
by: Bob Dydd |
last post by:
Hi everyone
It's me again.
I have an access 2000 database with 12 landscape reports which
sometimes have to be FAXED and other times printed, so I have written
the following code and put it...
|
by: fearblanco |
last post by:
Hello - I am receiving the below error message when attempting to open
a report. This database is used by approximately 20 users and only one
user is having this problem (even I can't duplicate...
|
by: Ed Robichaud |
last post by:
I'm temporarily stumped on how to handle/suppress an error (2501) if a user
cancels sending an email. I'm using DoCmd.SendObject to trigger an Outlook
send window, which works OK, but if the msg...
|
by: Keith |
last post by:
I have the following code in the On No Data event of a report:
****
On Error GoTo err_trap
MsgBox "No items matching criteria.", vbInformation, gcApplication
Cancel = True
err_trap:
If...
|
by: Anthony England |
last post by:
I am considering general error handling routines and have written a sample
function to look up an ID in a table. The function returns True if it can
find the ID and create a recordset based on...
|
by: Keith Wilby |
last post by:
In an old A97 app I trap for error 2501 in a report's calling code just in
case there are no records to return (set cancel = True in the report's No
Data event). This doesn't seem to work in my...
|
by: sara |
last post by:
I have a report that runs fine with data. If there is no data, I have
its NO Data event sending a MsgBox and cancelling the report.
Then it seems I still get the 2501 message on the Open Report...
|
by: fperri |
last post by:
Hello,
I have a form in Access for users to do updates from. I'm trying to catch the error 2501 that pops up if they say cancel to the prompt that tells them how many records they are going to...
|
by: sassy2009 |
last post by:
Hello,
I am running an insert query from xl spreadsheet using the DoCmd.RunSQL to insert values from the spreadsheet into the Access database. When i run this query it gives an error saying "...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |