|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 15th, 2006, 11:03 AM
posted to microsoft.public.access.forms
|
|||
|
|||
Update control
Form_SomeForm.SomeField.Value = 1
Sets the value of the active/current record, since i am using a tabular form i want to set the value of the field in all the records. Thanks 
|
|
#2
December 16th, 2006, 10:55 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Update control
Hi,
I am trying to do somthing like a "select all". For this i have created a button in which i have am using a macro Form_SomeForm.SomeField.Value = 1, SomeField is a CheckBox. But it sets only the active record and not all the records. Please help. "ITC" wrote in message ... Form_SomeForm.SomeField.Value = 1 Sets the value of the active/current record, since i am using a tabular form i want to set the value of the field in all the records. Thanks
|
|
#3
December 16th, 2006, 08:33 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Update control
ITC,
In order to update *all* the records with the same value use an Update Qurey, base on the relevant table and set the value of "somField" to Yes,True, or -1 (-1 is the value of True, 0 is the value of False) Regrds/JK ITC wrote: Hi, I am trying to do somthing like a "select all". For this i have created a button in which i have am using a macro Form_SomeForm.SomeField.Value = 1, SomeField is a CheckBox. But it sets only the active record and not all the records. Please help. "ITC" wrote in message ... Form_SomeForm.SomeField.Value = 1 Sets the value of the active/current record, since i am using a tabular form i want to set the value of the field in all the records. Thanks
|
|
#4
December 17th, 2006, 12:28 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Update control
Thanks, it works.
I had to do a me.refresh to ensure it refreshes the values immediately in the current view "Jacob" wrote in message ups.com... ITC, In order to update *all* the records with the same value use an Update Qurey, base on the relevant table and set the value of "somField" to Yes,True, or -1 (-1 is the value of True, 0 is the value of False) Regrds/JK ITC wrote: Hi, I am trying to do somthing like a "select all". For this i have created a button in which i have am using a macro Form_SomeForm.SomeField.Value = 1, SomeField is a CheckBox. But it sets only the active record and not all the records. Please help. "ITC" wrote in message ... Form_SomeForm.SomeField.Value = 1 Sets the value of the active/current record, since i am using a tabular form i want to set the value of the field in all the records. Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
