Is this possible - insert records based on results in a query

  • Thread starter Thread starter Andrew H
  • Start date Start date
A

Andrew H

I have only started using Access recently and am still finding my feet
with it so I don't know if you can do this in one step.

I have created a report that sends out letters to customers, based on
the dates entered by the user. This works fine but what i would also
like to do is insert a record in the workorders table showing that a
letter has been sent out.

Is this possible in one step? I could create a second append query that
would use the same criteria as the query that selects the records for
printing and then create workorders in that way, but if I can just hit
the button to run the report and it does it all in one move, then that
would be even better.
 
I have only started using Access recently and am still finding my feet
with it so I don't know if you can do this in one step.

I have created a report that sends out letters to customers, based on
the dates entered by the user. This works fine but what i would also
like to do is insert a record in the workorders table showing that a
letter has been sent out.

Is this possible in one step? I could create a second append query that
would use the same criteria as the query that selects the records for
printing and then create workorders in that way, but if I can just hit
the button to run the report and it does it all in one move, then that
would be even better.
Click to expand...

Sure; the button - whether it uses a Macro or (better) VBA code - can
both run an Append query and also open a Report. If you need help
doing this, please post the code that you're currently using, and the
name of the append query.

John W. Vinson[MVP]
 
Back
Top