Clearing fields in a table

[biscuitboy]

Hi,

Currently I have a table in Access called Data Template with 36 fields. They are the following:

Admin, Monday1, Monday2, Monday3, Monday4, Monday5, Tuesday1, Tuesday2, Tuesday3, Tuesday4, Tuesday5, Wednesday1, Wednesday2, Wednesday3, Wednesday4, Wednesday5, Thursday1, Thursday2, Thursday3, Thursday4, Thursday5, Friday1, Friday2, Friday3, Friday4, Friday5, Saturday1, Saturday2, Saturday3, Saturday4, Saturday5, Sunday1, Sunday2, Sunday3, Sunday4, Sunday5

What I would like to do is for all of the coloumns to clear them self apart from the Admin field when a button is pressed. Is this possible?

Best Regards

Buscuitboy

 

[TonyJollans]

Hi biscuitboy,

You want to wipe out all your data at the push of a button? Unusual, but if that's what you want, I would suggest you set up two tables - one which just contains the Admin column and another linked via Admin id which contains the rest, along with a query which looks like the table you now have. You can then just clear the second table completely when you want. This may require some reworking of other code - depending on what you have that may or may not be a big issue. Post back.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.