delete code problem

B

bob

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

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
 
Top