My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Undo or clear infomamtion
|
|
 Sep 29 2007, 04:29 PM
Post
#1
|
|
|
UtterAccess Guru Posts: 529 From: Montreal, QC  |
I have a small form that I use to create a report every month. Some of the information in those field carries on every month but other fields change each month. How can I have just certain field cleared of the information without deleating the entire record? Can a query update a field with an "Null" value. Or can this be done through VB? I just want the clear informatin in certain fields of a record and keep others.
Sandrao |
 |
 
|
|
Sep 29 2007, 04:45 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 20,227 From: Colorado |
Hi Sandaro,
"How can I have just certain field cleared of the information without deleating the entire record?" you could put a "Reset" button on your form... CODE me.controlname1 = null me.controlname2 = null 'etc "Can a query update a field with an "Null" value." yes UPDATE Tablename SET FieldName1 = Null, Fieldname2 = Null "Or can this be done through VB?" yes, but if you are in the code behind the form, it may be best to just set the controls to Null |
|
|
|
|
Oct 17 2007, 07:34 PM
Post
#3
|
|
|
New Member Posts: 18 From: Honolulu, Hawaii |
Hi Crystal--
Found your post searching UA, and you gave exactly the info I needed to create a search form "Reset" or "Clear" button on my project, thanks! --Steph |
|
|
|
|
Oct 18 2007, 01:44 AM
Post
#4
|
|
|
UtterAccess VIP Posts: 20,227 From: Colorado |
you're welcome, Steph (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif) happy to help
|
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 18th June 2013 - 05:58 PM |