Removing contents of a table but not the table

J

Joy

I have a form for change/ update requests. When the user fills in the form,
the data goes into a table. I don't wish for the table to grow as it takes up
weight.
I would like the table's contents to be removed either when users exit from
the application or close the form.

What is the best approach?

Thanks Joy
 
R

Rick Brandt

Joy said:
I have a form for change/ update requests. When the user fills in the
form, the data goes into a table. I don't wish for the table to grow
as it takes up weight.
I would like the table's contents to be removed either when users
exit from the application or close the form.

What is the best approach?

Thanks Joy
Click to expand...

Run a delete query against the table either when you close the app or when
you open it.
 
T

Tom Lake

Joy said:
I have a form for change/ update requests. When the user fills in the form,
the data goes into a table. I don't wish for the table to grow as it takes up
weight.
I would like the table's contents to be removed either when users exit from
the application or close the form.

What is the best approach?
Click to expand...

If you don't need to save the data then why not just create a Word form to fill in?

Tom Lake
 

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

Adding data to MS Access from csv file 0
Macro for Table of Contents 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Embed the same Excel multiple times 0
Excel does not accept text format! 0
Lost my Table of Contents , Appendices and Page numbers ? 2
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Insert Index into a Table 1

Top