Clearing a table

[X]

Can anyone help me to figure out how to delete all the
records in a table from a form? Thank you for any help.

X

 

[PC Datasheet]

Put this code in the OnClick event of a button on your form:

DoCmd.SetWarnings False
DoCmd.RunSQL ("DELETE * FROM NameOfTable;")
DoCmd.SetWarnings False

 

[Hilo]

Use the code type before but last set warnings should be
set to True so it reads

 

[PC Datasheet]

Yes, Thanks. I copied and pasted but forgot to change False to True in the last
line of code.

Appreciate you catching this!

 

[TC]

Also the form should Me.Requery

TC

Yes, Thanks. I copied and pasted but forgot to change False to True in the last
line of code.

Appreciate you catching this!