Delete all records in a table

[Lightlancer]

hi there,

i have a macro that can delete all records from a table:

Delete * from [tblFakturatie]

Now i need to have this in VBA because, alot of checkboxes needs to reset and that i have written in VBA (dunno how to reset checkboxes in a form with a macro, and VBA is better, but that is my thinking.)

any ideas?

many Thanks in advance

Lightlancer

 

[TheAceMan1]

How are ya Lightlancer . . .

Try this:

[blue]   CurrentDb.Execute "Delete * from [tblFakturatie]", dbFailOnError[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886