By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,224 Members | 1,630 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,224 IT Pros & Developers. It's quick & easy.

Run Time Error Question

P: n/a
Don
I have a form that uses an Image object to open a report (the report is
based on a query). I used the image object because the MS command buttons
are dull looking. All of this works well. The problem occurs if I choose
to cancel when the "enter parameter box" appears. The query prompts for two
inputs, name, then start date and end date (I guess that's three prompts).
When I click cancel I get the "Run Time Error 2501 The Open Report Action
Was Canceled". What do I need to do to stop this?

While I'm asking questions I'd like to ask another. I'm trying to add a
calendar to this form, in particular to this action. When I click on this
Image object the prompts come up asking for name then start date then end
date. How can I attach a calendar to this action? I've tried several
calendars but haven't gotten anywhere. I had used Allen Browne's calendar
in another db but I can't make it work in this one, I think because I'm
using an image object. to open a report.

Thanks again,
Don...........
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Br
Don wrote:
I have a form that uses an Image object to open a report (the report
is based on a query). I used the image object because the MS command
buttons are dull looking. All of this works well. The problem
occurs if I choose to cancel when the "enter parameter box" appears.
The query prompts for two inputs, name, then start date and end date
(I guess that's three prompts). When I click cancel I get the "Run
Time Error 2501 The Open Report Action Was Canceled". What do I need
to do to stop this?


It's a valid error message. To not see it you'd need to put in your own
error routines.

eg.

On error goto myFunction_err

.....

myFunction_Exit:
End Sub
myFunction_err:
MsgBox Err.Description, 48, "Error in myFunction ' comment out to not
show message
resume myFunction_Exit

<>

--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.