DELETING RECORDS!!

[Milan]

I HAVE A TABLE WHICH IS BOUND TO A FORM. I NEED TO DELETE ALL RECORDS IN THE TABLE THAT HAVE BEEN CREATED YESTERDAY, THROUGH CODE. THE DATE(YESTERDAY) WOULD BE ON THE FORM IN AN UNBOUND CONTROL. ANYIDEAS!!!

MANY THANKS

 

[llkhoutx]

Create a delete query with the required date in the criteria anbd run it on some event, then requery your form.

 

[dontcare]

Try,

Dim db as database
Dim sql as string

set db=currentdb

sql="DELETE * FROM tblYourTable WHERE fldDate = '" & Me.[YourUnboundControl] & "'"

db.Execute sql

db.close