OpenForm Action

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using an Access Database that I did not create. Up to a certain point,
I can put in from date and to date and get combined information. My delimma
is, now, all of a sudden I put in a date range, lets say 10/1/04 to 10/11/04
and I get a message that says "The OpenForm Action was Canceled". It works
in September, and even in November for the first two days. Why am I getting
this message for October. If I enter a date range of 10/1 to 10/9 it works.
It appears that whatever happened, happened on the 10th. It will not let me
put the date range higher than 10/10/04. HELP ME!!!

I should let you know that I am an intermediate user of Access. Have not
taken any classes higher than this. But I am familiar with VBAs and how they
work.
 
i would start by putting a break in the code that runs (from a command
button, perhaps?) after you enter the pair of dates. then step through the
code so you can (hopefully) get a better picture of what is actually
happening - when you enter "acceptable" dates and when you enter
"unacceptable" dates.

hth
 
McBride said:
I am using an Access Database that I did not create. Up to a certain
point, I can put in from date and to date and get combined
information. My delimma is, now, all of a sudden I put in a date
range, lets say 10/1/04 to 10/11/04 and I get a message that says
"The OpenForm Action was Canceled". It works in September, and even
in November for the first two days. Why am I getting this message
for October. If I enter a date range of 10/1 to 10/9 it works. It
appears that whatever happened, happened on the 10th. It will not
let me put the date range higher than 10/10/04. HELP ME!!!

I should let you know that I am an intermediate user of Access. Have
not taken any classes higher than this. But I am familiar with VBAs
and how they work.
Click to expand...

Tina's advice on how to track this down is good, one additional thought
occurs to me. Are the dates you gave as examples above the actual dates
that are involved in this problem? If not, please post the exact dates
that provoke the transition from "working" to "not working". Could it
be that you start having problems when you enter a date where the day of
the month is greater than 12?
 
The dates in the sample are the actual dates where I begin to experience
problems. One other thing I should mention, This form also feeds off another
database where the actual data is entered. All the data entered in the main
database are numbers.
 
McBride said:
The dates in the sample are the actual dates where I begin to
experience problems. One other thing I should mention, This form
also feeds off another database where the actual data is entered.
All the data entered in the main database are numbers.
Click to expand...

I'm afraid I don't understand what you mean by that. When you say
"another database", are you talking about a separate MDB file? Or are
you confusing "database" with "table", as people are prone to do?
Please post the definitions of all the relevant tables, the recordsource
of the form that is being opened, and the code behind the command
button's Click event (or whatever other event is being called that
contains the code that tries and fails to open the form.
 
Back
Top