T
t-bone
I've got 5 reports in my database with parameter queries.
I set up the switchboard, and now the queries cause the
print event to fire when the reports are viewed, even
though the switchboard is set up as preview. What do I do
to fix that?
Furthermore, if the user previews the report but
chooses 'cancel' in the parameter query, the user receives
the macro 'halt' error. How do I set up the CancelEvent
function when the user cancels during the report's query?
Finally, one report has a query that asks for a start
date, end date, and customer name OR customer ID. When I
run the macro for the report from the macro area in the
database, it runs fine. When the user chooses it from the
switchboard, the query asks for: start date, end date,
customer name, start date, end date. WHY?!?! I'm
beginning to think switchboards are the devil . . .
Thanks,
Tonda
I set up the switchboard, and now the queries cause the
print event to fire when the reports are viewed, even
though the switchboard is set up as preview. What do I do
to fix that?
Furthermore, if the user previews the report but
chooses 'cancel' in the parameter query, the user receives
the macro 'halt' error. How do I set up the CancelEvent
function when the user cancels during the report's query?
Finally, one report has a query that asks for a start
date, end date, and customer name OR customer ID. When I
run the macro for the report from the macro area in the
database, it runs fine. When the user chooses it from the
switchboard, the query asks for: start date, end date,
customer name, start date, end date. WHY?!?! I'm
beginning to think switchboards are the devil . . .
Thanks,
Tonda