423,850 Members | 1,562 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,850 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.OpenReport "rptSYS_ChangeInARDaily", acViewPreview

OR

DoCmd.OpenReport "rptSYS_ChangeInARDaily", acViewPreview, , "Collector=
'" & cmbAnalyst.Value & "'"

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********@gmail.com

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
fe********@gmail.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.OpenReport "rptSYS_ChangeInARDaily", acViewPreview

OR

DoCmd.OpenReport "rptSYS_ChangeInARDaily", acViewPreview, , "Collector=
'" & cmbAnalyst.Value & "'"

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********@gmail.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 YourExitStatementLine
Nov 13 '05 #2

P: n/a
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

P: n/a
fe********@gmail.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.OpenReport "rptSYS_ChangeInARDaily", 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

P: n/a
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

P: n/a
I fixed it
just uninstall your printer, and re-install it
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.