delete code problem

[bob]

Private Sub cmd_Deletetemp_Click()
DELETE from tempattendance;Error...end of statement missing
End Sub

 

[TC]

Bob, you will usually get more help if you keep your posts short & concise;
er...

Try:

dbengine(0)(0).execute "DELETE from tempattanendance", dbfailonerror

I assume you relize that this will delete all records from the specified
table.

HTH,
TC