Tricky one..."Select"
in [Forms]
|
Prev: Tricky one...”Select”
Next: change Caption menu Items
From: Arvin Meyer [MVP] on 3 May 2010 16:22 This may be helpful: http://www.mvps.org/access/modules/mdl0004.htm -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Peter" <Peter(a)discussions.microsoft.com> wrote in message news:7328FC7C-030B-4EF2-950C-D99C39E93D7C(a)microsoft.com... > Hi all, i wish to solve the following,, > From a continuous pop up form B...i want to select some records (unbound > check box) and populate > the selected records [Bananas] and [Kilogram] in the consternated textbox > [Fruit_Basket] in the open form A... > What code do i use in the onclick event of a command button? > Example. Of record 1-10 i want to select records 4.5.6 and seven, and > "transfer" the data to one single field in Form A... > > Grateful for all suggestions, Thanks! >
From: Linq Adams via AccessMonster.com on 3 May 2010 17:13 The link Arvin gave you may help you reach your goal, although doing this violates the concept of "atomic" data, i.e. one piece and only one piece of data per field, but you need to understand that "From a continuous pop up form B...i want to select some records (unbound check box) and populate" isn't possible. If the checkbox you want to use to designate selected records in Form B is UNBOUND, the when you tick one checkbox in one record, all checkboxes in all records will be ticked! That's the way unbound controls work in Continuous (and Datasheet) forms. If you only want the checkboxes in certain records to be ticked they'll have to be bound to the record n the underlying table. . -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1
From: Marshall Barton on 3 May 2010 18:31 Linq Adams via AccessMonster.com wrote: >"From a continuous pop up form B...i want to select some records (unbound >check box) and populate" > >isn't possible. If the checkbox you want to use to designate selected records >in Form B is UNBOUND, the when you tick one checkbox in one record, all >checkboxes in all records will be ticked! That's the way unbound controls >work in Continuous (and Datasheet) forms. If you only want the checkboxes in >certain records to be ticked they'll have to be bound to the record n the >underlying table. . Actually, it is possible by using an unbound check box and a little code. See Albert's Multi Select Example at http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html -- Marsh MVP [MS Access]
From: Peter on 3 May 2010 18:31 Arvin and Linq, I thank you both for showing mw the "path"..very usefull indeed..this is very interesting Thanks! "Linq Adams via AccessMonster.com" wrote: > The link Arvin gave you may help you reach your goal, although doing this > violates the concept of "atomic" data, i.e. one piece and only one piece of > data per field, but you need to understand that > > "From a continuous pop up form B...i want to select some records (unbound > check box) and populate" > > isn't possible. If the checkbox you want to use to designate selected records > in Form B is UNBOUND, the when you tick one checkbox in one record, all > checkboxes in all records will be ticked! That's the way unbound controls > work in Continuous (and Datasheet) forms. If you only want the checkboxes in > certain records to be ticked they'll have to be bound to the record n the > underlying table. . > > -- > There's ALWAYS more than one way to skin a cat! > > Answers/posts based on Access 2000/2003 > > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1 > > . >
From: Peter on 3 May 2010 18:47
Yes..now i understand... Form B is based on Table B, originally only with three fields. Field A is related to Field A in Form/Table A were table A is the ONE to Many ...all i need to do is to add a Yes/No field to Table B..by ticking/Yes i will then select the "Atomic" data,,,in this case [Bananas] and [kilograms]...by clikcing on the command button...Ok..will look into the Northwind sollution Many thanks! "Peter" wrote: > Arvin and Linq, I thank you both for showing mw the "path"..very usefull > indeed..this is very interesting > > Thanks! > > "Linq Adams via AccessMonster.com" wrote: > > > The link Arvin gave you may help you reach your goal, although doing this > > violates the concept of "atomic" data, i.e. one piece and only one piece of > > data per field, but you need to understand that > > > > "From a continuous pop up form B...i want to select some records (unbound > > check box) and populate" > > > > isn't possible. If the checkbox you want to use to designate selected records > > in Form B is UNBOUND, the when you tick one checkbox in one record, all > > checkboxes in all records will be ticked! That's the way unbound controls > > work in Continuous (and Datasheet) forms. If you only want the checkboxes in > > certain records to be ticked they'll have to be bound to the record n the > > underlying table. . > > > > -- > > There's ALWAYS more than one way to skin a cat! > > > > Answers/posts based on Access 2000/2003 > > > > Message posted via AccessMonster.com > > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1 > > > > . > > |