Delete data in field

  • Thread starter Thread starter Svein Ludvigsen
  • Start date Start date
S

Svein Ludvigsen

I want to delete all data in a field with a command button.
What code must i write?

Svein
 
CurrentDb.Execute "UPDATE YourTableNameHere SET YourFieldNameHere = Null",
dbFailOnError

This will set the content of the specified field in all records to Null,
without any further prompting, so be sure you *really* want to do that
before executing this code. As always when performing any kind of bulk
update to data, it would be wise to make a back-up first.
 
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

First day in month 3
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
Toggle button vs Command button 2
problem with command button (inserts specific text) 0
Delete Command Button Issue 2
How to subtract a number from a Mergefield? 0
Best tool to recover PST files in 2026 0
Reference a field dynamically 3

Back
Top