Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Doctor Doom
Starting Member
12 Posts |
 Posted - 2004-03-29 : 06:35:09
|
| Hi, brothers,I have another silly question about Access:I have a table with over 2000 records. It's possible that some records in the same field need to be deleted (not the records, but the data inside the cells)...So, I selected those 'cells' with the mouse. I tought it would be logical when I just click on the delete button to make those cells empty (just like in Excel). You can of course guess what happened:I couldn't empty the cells I selected.Is there a way in Access to delete a whole selection of cells?I found this a bit weird: when I select just one cell, I can delete the contents of it with the delete button. But I can't use the same procedure to a selection of multiple cells.Thanks in advance |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-03-29 : 09:04:34
|
| Do you know how to do an UPDATE query? That will allow you to instanly change the contents of existing tables, including writing NULL into columns in your tables, based on a condition.for example,UPDATE tbl SET Amount = Null WHERE User = 'Jeff' AND TransDate >= #1/1/2003#If you want this function in a UI for your users (i.e., you want to allow end users to clear out values easier than picking each one), then you will need to write it using forms and VBA ...- Jeff |
 |
|
|
Doctor Doom
Starting Member
12 Posts |
Posted - 2004-03-29 : 09:09:45
|
| Thanks, Jeff,I will try out your suggestion. |
|
|
|
|
|
|
How to delete cell contents in a fast way?