Select all
in [Forms]
|
From: Peter on 14 Mar 2010 16:41 Hi all, In a continuous form I want to select all records displayed and assign a specific control a value from an unbound combo box. I can not get the "select all to function..." What would be the best way around this? Thanks!
From: Gina Whipp on 14 Mar 2010 23:36 Peter, Perhaps you mean *Select All Record*? 8Selct All* is only going to select the current record. However, I can't see how you are using this so if the answer was not what you wanted you could explain what you are trying to do and supply any code you are using... -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Peter" <Peter(a)discussions.microsoft.com> wrote in message news:EDF99379-9692-4B98-B777-4F24F0D3FD04(a)microsoft.com... Hi all, In a continuous form I want to select all records displayed and assign a specific control a value from an unbound combo box. I can not get the "select all to function..." What would be the best way around this? Thanks!
From: Peter on 17 Mar 2010 11:41 Hi Gina, sorry for my late reaction.. I want to edit the value in a specific control for each record that is displayed in this form..the value is stored in a unbound combobox... i dont know how to start.. 10 records..i want to select all 10 records and assign the control "fruits" with the value "bananas".."bananas" is selected from the unbounded combox "Gina Whipp" wrote: > Peter, > > Perhaps you mean *Select All Record*? 8Selct All* is only going to select > the current record. However, I can't see how you are using this so if the > answer was not what you wanted you could explain what you are trying to do > and supply any code you are using... > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Peter" <Peter(a)discussions.microsoft.com> wrote in message > news:EDF99379-9692-4B98-B777-4F24F0D3FD04(a)microsoft.com... > Hi all, > > In a continuous form I want to select all records displayed and assign a > specific control a value from an unbound combo box. > > I can not get the "select all to function..." > > What would be the best way around this? > > Thanks! >
From: Gina Whipp on 17 Mar 2010 16:26 Peter, No problem... we here all day and all night! Kinda sad really... oops, I digress... <smile> So you have this form and on the form you have a combo box and you want to select this combo box on 10 records and change the value... ahhh, nope, you can't do that. You'll have to either run an update query or *touch* each record and change the value. Did I understand you correctly? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Peter" <Peter(a)discussions.microsoft.com> wrote in message news:BAE907ED-90B4-401C-9E62-7BF85BB36EDB(a)microsoft.com... Hi Gina, sorry for my late reaction.. I want to edit the value in a specific control for each record that is displayed in this form..the value is stored in a unbound combobox... i dont know how to start.. 10 records..i want to select all 10 records and assign the control "fruits" with the value "bananas".."bananas" is selected from the unbounded combox "Gina Whipp" wrote: > Peter, > > Perhaps you mean *Select All Record*? 8Selct All* is only going to select > the current record. However, I can't see how you are using this so if the > answer was not what you wanted you could explain what you are trying to do > and supply any code you are using... > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Peter" <Peter(a)discussions.microsoft.com> wrote in message > news:EDF99379-9692-4B98-B777-4F24F0D3FD04(a)microsoft.com... > Hi all, > > In a continuous form I want to select all records displayed and assign a > specific control a value from an unbound combo box. > > I can not get the "select all to function..." > > What would be the best way around this? > > Thanks! >
From: Peter on 19 Mar 2010 07:58 Hi Gina...ok..i understand ..well..perhaps better to assign the value per record instead..you are right! Thanks! "Gina Whipp" wrote: > Peter, > > No problem... we here all day and all night! Kinda sad really... oops, I > digress... <smile> > > So you have this form and on the form you have a combo box and you want to > select this combo box on 10 records and change the value... ahhh, nope, you > can't do that. You'll have to either run an update query or *touch* each > record and change the value. > > Did I understand you correctly? > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Peter" <Peter(a)discussions.microsoft.com> wrote in message > news:BAE907ED-90B4-401C-9E62-7BF85BB36EDB(a)microsoft.com... > Hi Gina, sorry for my late reaction.. > I want to edit the value in a specific control for each record that is > displayed in this form..the value is stored in a unbound combobox... i dont > know how to start.. > > 10 records..i want to select all 10 records and assign the control "fruits" > with the value "bananas".."bananas" is selected from the unbounded combox > > "Gina Whipp" wrote: > > > Peter, > > > > Perhaps you mean *Select All Record*? 8Selct All* is only going to select > > the current record. However, I can't see how you are using this so if the > > answer was not what you wanted you could explain what you are trying to do > > and supply any code you are using... > > > > -- > > Gina Whipp > > 2010 Microsoft MVP (Access) > > > > "I feel I have been denied critical, need to know, information!" - Tremors > > II > > > > http://www.regina-whipp.com/index_files/TipList.htm > > > > "Peter" <Peter(a)discussions.microsoft.com> wrote in message > > news:EDF99379-9692-4B98-B777-4F24F0D3FD04(a)microsoft.com... > > Hi all, > > > > In a continuous form I want to select all records displayed and assign a > > specific control a value from an unbound combo box. > > > > I can not get the "select all to function..." > > > > What would be the best way around this? > > > > Thanks! > > > . >
|
Next
|
Last
Pages: 1 2 Prev: Change Required Field Property in Table Next: preventing duplicates but not totally blocking |