Sales By Customer Error

  • Thread starter Thread starter keruing
  • Start date Start date
K

keruing

Hello,

I am running Access 2002 on Windows 2000. When getting
reports the Sales By Product and Receivables work fine but
all of a sudden when I try to get a Sales By Customer or
Sales By Employee report it rejects dates from 10/28/03
on. Please Help!!!
 
keruing said:
Hello,

I am running Access 2002 on Windows 2000. When getting
reports the Sales By Product and Receivables work fine but
all of a sudden when I try to get a Sales By Customer or
Sales By Employee report it rejects dates from 10/28/03
on. Please Help!!!
Click to expand...

Please post the SQL of the recordsources of the reports, and also the
Filter and FilterOn property of each report. What do you mean by
"rejects dates from 10/28/03 on"? That they just don't show up in the
reports?
 
Thank you for your response. From my switchboard I choose
Preview reports. Then click on Sales By Customer. This
brings up a box with a spot for a beginning date and an
end date. The begin date is accepted from 01/01/03 on. The
end date is accepted from 01/02/03 through 10/27/03, and
the reports are fine. If I input any end date from
10/28/03 on I get a notice saying "There was an error
executing your command" and it will not provide a report.
The filter property is blank and the Filter On says NO.>
 
Thank you for your response. From my switchboard I choose
Preview reports. Then click on Sales by Customer. This
brings up a box with a spot for a beginning date and an
end date. The begin date is accepted from 01/01/03 on. The
end date is accepted from 01/02/03 through 10/27/03, and
the reports are fine. If I input any end date from
10/28/03 on I get a notice saying "There was an error
executing your command" and it will not provide a report.
The filter property is blank and the Filter On says NO.>
 
keruing said:
Thank you for your response. From my switchboard I choose
Preview reports. Then click on Sales by Customer. This
brings up a box with a spot for a beginning date and an
end date. The begin date is accepted from 01/01/03 on. The
end date is accepted from 01/02/03 through 10/27/03, and
the reports are fine. If I input any end date from
10/28/03 on I get a notice saying "There was an error
executing your command" and it will not provide a report.
The filter property is blank and the Filter On says NO.
Click to expand...

The thing we have to determine is where the error is being raised.
Would I be right in thinking that when you choose Preview Reports on
your switchboard, you get another form displayed that allows you to
choose the report; for example, Sales by Customer? Would you please
post all the code from that form's code module? Then it seems you are
shown another form that prompts you for the begin date and end date.
Please post the code from that form's module, too. Finally, the report
itself may have a code module. If it does, please post the code in that
module, too. And finally, please post the recordsource of the report.
If that recordsource is a stored query, please post the SQL view of that
query.

Unfortunately, it may be that this is a macro-driven system, using
macros to run everything rather than VBA code. If so, it'll be harder
to track down the source of the problem, but please post the details of
the macros that are run in response to the various button-clicks on the
forms.
 
Back
Top