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.
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.
