I
Ian
i would like to run an update query when a report is printed. here's the
situation:
1. I have a db with client names and services. the reports are organized
with 1 client per page for services that have not been completed (one-to-many
join between the client and service tables). each service has a
completed/not -complete box.
2. we batch print the reports for all uncompleted services (report based on
a simple query to show the uncompleted services)
3. i would like to add another field (yes/no or better yet date) to the
services table for "printed". my thought that was that the report would be
modified to only show services that have not been printed or completed. when
the page for the report was printed a macro would start to run an append
query to modify the same query that created the report and either turn on the
"printed" yes no box or put the date in it.
can anyone suggest a way to make the macro run when the report is printed or
suggest a more refined way of solving the problem? I have no VBA knowledge
so it will have to be based on the macro builder or spelled out.
Thx. Ian.
situation:
1. I have a db with client names and services. the reports are organized
with 1 client per page for services that have not been completed (one-to-many
join between the client and service tables). each service has a
completed/not -complete box.
2. we batch print the reports for all uncompleted services (report based on
a simple query to show the uncompleted services)
3. i would like to add another field (yes/no or better yet date) to the
services table for "printed". my thought that was that the report would be
modified to only show services that have not been printed or completed. when
the page for the report was printed a macro would start to run an append
query to modify the same query that created the report and either turn on the
"printed" yes no box or put the date in it.
can anyone suggest a way to make the macro run when the report is printed or
suggest a more refined way of solving the problem? I have no VBA knowledge
so it will have to be based on the macro builder or spelled out.
Thx. Ian.