Clear Table after Mail Merge

[Guest]

Hello,

I am using database by Albert D. Kallal
with a simple Mail Merge form for the following info.:

Cust Name, Address, City, State, Zip and so on....... I put in several
records, click Merge to Word and it export to the documents. It is a great
way to merge and works like a gem!! My question is this:

Once the data in the table has been exported, I want access to delete the
records from the table sort of one time use for that data. Then when I open
the form for the next days data input, I will start from record 1 and repeat
the process. Is this possible??

Thanks!!!

 

[Guest]

Build a "Delete" Query that deletes all the records in the table you are
talking about.

Open up the "Event" on the "Merge" button you referred to.

On the line of code after the table export insert a:

DoCmd.OpenQuery "qry_Mydeletequery"

This will delete all the records in the table

 

[Guest]

Thank Jeff!!

Build a "Delete" Query that deletes all the records in the table you are
talking about.

Open up the "Event" on the "Merge" button you referred to.

On the line of code after the table export insert a:

DoCmd.OpenQuery "qry_Mydeletequery"

This will delete all the records in the table