delete and reset

  • Thread starter Thread starter Help an Access Idiot
  • Start date Start date
H

Help an Access Idiot

How can you set a database table up to automaticly delete
and reset for next days data?

Thank you ahead of time for any assistance.
Packskum the pathetic.
 
Create a Delete Query in the database and then run this
either on Database exit or on Database Open as it fits to
your situation.

Dim Delete As String
Delete = "qry_Delete"
docmd setwarnings true/False 'to see confirmation of the
deletes.
DoCmd.OpenQuery Delete, acViewNormal, acEdit
DoCmd.Close acQuery, Delete
 
Back
Top