How to do I clear a table after sending it

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Everybody,
I have a command button that let me submit a table when clicked. Now I
want the table to be cleared after that. Can somebody please tell me how to
do that?
Thank you for your help
 
well, i've no idea what you mean by "submit a table". but if you're asking
how to delete all the records from an Access table, use a Delete query.

hth
 
You don't need to write and store a query for this. Just do this:
CurrentDB.Execute("DELETE * FROM MyTableName;")
 
thanks for your help

Klatuu said:
You don't need to write and store a query for this. Just do this:
CurrentDB.Execute("DELETE * FROM MyTableName;")
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

Access Automatically Send a notification email once a record is added 0
VBA - retrieve data on last create named range from previous inserted named range 0
How to Populate Data from a table to another 0
clear a table after clicking the command button 4
RESUBMITTAL - Send New Record Only 5
access table connected to excel form 3
How to export table from outlook into ms access table? 0
Command button to save record and generate new form 2

Back
Top