Deleting data in table

  • Thread starter Thread starter Alex Martinez
  • Start date Start date
A

Alex Martinez

Hi,

I like to have a command button that will delete all data in a particular
table. Let's call this table AuditUpload. How does one code the command
button to delete the data only? Any help or tips will be appreciated. Thank
you.
 
try

CurrentDb.Execute "DELETE * FROM AuditUpload", dbFailOnError

hth
 
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

Error Message box 2
Copy form datasheet to table 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
DELETE FROM a table WHERE... 1
VBA - retrieve data on last create named range from previous inserted named range 0
Access Automatically Send a notification email once a record is added 0
How to use multiple command button to copy user form data to multiple worksheet 0
Help with using command button to delete a record from a table 3

Back
Top