Clearing a table

  • Thread starter Thread starter X
  • Start date Start date
X

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
 
Put this code in the OnClick event of a button on your form:

DoCmd.SetWarnings False
DoCmd.RunSQL ("DELETE * FROM NameOfTable;")
DoCmd.SetWarnings False
 
Use the code type before but last set warnings should be
set to True so it reads
 
Yes, Thanks. I copied and pasted but forgot to change False to True in the last
line of code.

Appreciate you catching this!
 
Also the form should Me.Requery :-)

TC


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

Appreciate you catching this!
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
Use Mainform checkbox uncheck to clear subform and subform table 3
How to export table from outlook into ms access table? 0
VBA - retrieve data on last create named range from previous inserted named range 0
#Deleted 1
Button to delete all records of a table 8
Use of Subform? 1
Nested Subforms - Intermediate Table 0

Back
Top