473,554 Members | 2,268 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Error 2501 The OpenReport action was cancelled... HELP!

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 this error on my
own PC). The command being used is

DoCmd.OpenRepor t "rptSYS_ChangeI nARDaily", acViewPreview

OR

DoCmd.OpenRepor t "rptSYS_ChangeI nARDaily", acViewPreview, , "Collector=
'" & cmbAnalyst.Valu e & "'"

This one particular user gets the following message:

Error: 2501 - ErrorDesc: The OpenReport action was canceled

Can anybody explain why this would happen to only one person? The data
is there, so I can't see why the report would cancel.
Please help,
fe********@gmai l.com

Nov 13 '05 #1
5 28926
fe********@gmai l.com wrote:
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 this error on my
own PC). The command being used is

DoCmd.OpenRepor t "rptSYS_ChangeI nARDaily", acViewPreview

OR

DoCmd.OpenRepor t "rptSYS_ChangeI nARDaily", acViewPreview, , "Collector=
'" & cmbAnalyst.Valu e & "'"

This one particular user gets the following message:

Error: 2501 - ErrorDesc: The OpenReport action was canceled

Can anybody explain why this would happen to only one person? The data
is there, so I can't see why the report would cancel.
Please help,
fe********@gmai l.com


It's possible you have the OnNoData to cancel the report or you have a
Cancel in the OnOpen event. If so, in the calling form, add to your
error routine
If Err.Number <> 2501 then msgbox Err.Description
Resume YourExitStateme ntLine
Nov 13 '05 #2
This would make sense but the other 19 people using the same exact
report dont have this problem.

and there is no OnNoData event or OnOpen event for this report.
I'll try what suggested and hope it works :)

Nov 13 '05 #3
fe********@gmai l.com wrote:
This would make sense but the other 19 people using the same exact
report dont have this problem.

and there is no OnNoData event or OnOpen event for this report.
I'll try what suggested and hope it works :)


Open your code window and to to the
DoCmd.OpenRepor t "rptSYS_ChangeI nARDaily", acViewPreview
line. On the vertical bar, click on it so you can step through the
process. Then exectute from the bad machine and follow the steps the
code takes. See where this program takes you.

Sometimes I place Msgboxes like "I am Here" and "Here I am again" to see
where execution processes are being performed.

Do you have any code in the report? Maybe there is something being done
that stops aborts the code. That is why stepping through the code may
help. Good luck.
Nov 13 '05 #4
hi
I have got exactly the same problem, and I cannot fix it.
can you know what software your user has installed on his machine?
Can you make this test : open your database on the machine you have the
problem, modify a form, and view the code (use the menu bar "view, code")
can you tell me if it is working?
thank you
Eric

Nov 13 '05 #5
I fixed it
just uninstall your printer, and re-install it
Nov 13 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
8449
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 2501: the DoMenuItem was Cancelled". How can I trap this error so that it doesn't display but simply closes the form? Thanks Colin
5
744
by: Bob | last post by:
Hi Everybody I hope you can help. 2 related questions. 1. I am looking for a way to replace the confusing message box that comes up when a user trys to open a form without putting data in it. ie ..Syntax Error(Missing Operator) In queryexpression '=" & Me! DoCmd.OpenForm stDocName, , , stLinkCriteria
0
1326
by: mondo3 | last post by:
Someone had previously created an access 2000 database (tables and forms together in a single .mdb file). The .mdb file was located on a server, and two users (on two separate computers) share this database. It was working fine until last week, when one of the users told me they can no longer share the database...when they use the save button...
4
9434
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 Err.Number = 2501 Then Exit Sub
8
2443
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 command, even though I have the code to trap Err 2501 (from many postings - all looked the same to me) on the button the user pressed to get the...
2
5014
by: dkohel | last post by:
What is wrong with the following code? I am trying to filter a form based on the selection of a combobox named cblPRD Dim currentFilter currentFilter = " = '" & Me!cboPRD & "'" Filter = currentFilter DoCmd.ApplyFilter , Filter When the code executes, I trap and receive the following error...
3
2377
by: razjafry | last post by:
Hi, I am trying to create a combo box to search record on the base of ID but it gives runtime error message 2501 "the openform action was cancelled" all the times. I posted this question before but remained unresolved for ID search criteria http://bytes.com/forum/thread757878.html I changed the data source from table to query but still...
17
3118
by: trose178 | last post by:
Good day all, I am working on a multi-select list box for a standard question checklist database and I am running into a syntax error in the code that I cannot seem to correct. I will also note that I am using Allen Browne's multi-select list box for a report as a guide. I should also note that my access skills are not the best so I may need...
7
15918
sassy2009
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 " Run-time error 2501 RunSQL action was cancelled". I know why this is happening and it's because of the message box that appears when an action query is...
0
7611
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7812
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8051
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7574
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7894
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5442
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3579
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3561
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1145
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.