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
|
|||
|
|||
MultiSelect list box or just Check boxes???
Hi I just cannot see which way is best to go MultiSect box or just have check
boxes?? I need to Check In & Out sets of items, I have tried the MultiSelect list box but that doesn't seem to store any where to state whether the items are check In or out? And because there are quite a few items to one set of patterns it would mean a lot of check boxes on the form? Can any body point me in the right direction please thanks Jo |
#2
|
|||
|
|||
MultiSelect list box or just Check boxes???
On Sun, 12 Jul 2009 11:51:30 -0700, jo wrote:
Hi I just cannot see which way is best to go MultiSect box or just have check boxes?? I need to Check In & Out sets of items, I have tried the MultiSelect list box but that doesn't seem to store any where to state whether the items are check In or out? And because there are quite a few items to one set of patterns it would mean a lot of check boxes on the form? Can any body point me in the right direction please thanks Jo STOP. You're evidently starting your design with a Form. That's like building a house by putting the frame together... before you've poured the foundations! Data is stored in tables, and ONLY in tables. Get your tables right first and *then* start looking at forms! You'll need at least three tables: Items; People (who is checking stuff out); and Checkouts, with a link to the table of people and a link to the table of items, probably with a couple of date/time fields indicating when the item was checked out and back in. Typically you would use a Form with a Subform (not a listbox OR checkboxes) to enter the data. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
MultiSelect list box or just Check boxes???
Hi John thanks for your help I think I shall go as you have advised I have
just blinded myself with wanting a Multiselect list box but it is not going to do what I need it to do so I shall go with the Check boxes. Although it would be good if the Check Boxes could be hidden until requested, such as if I have a Check box to check ALL items (keeping the other check boxes hidden) and another Check box to request individual items? Do you think this is possible?? Jo "John W. Vinson" wrote: On Sun, 12 Jul 2009 11:51:30 -0700, jo wrote: Hi I just cannot see which way is best to go MultiSect box or just have check boxes?? I need to Check In & Out sets of items, I have tried the MultiSelect list box but that doesn't seem to store any where to state whether the items are check In or out? And because there are quite a few items to one set of patterns it would mean a lot of check boxes on the form? Can any body point me in the right direction please thanks Jo STOP. You're evidently starting your design with a Form. That's like building a house by putting the frame together... before you've poured the foundations! Data is stored in tables, and ONLY in tables. Get your tables right first and *then* start looking at forms! You'll need at least three tables: Items; People (who is checking stuff out); and Checkouts, with a link to the table of people and a link to the table of items, probably with a couple of date/time fields indicating when the item was checked out and back in. Typically you would use a Form with a Subform (not a listbox OR checkboxes) to enter the data. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
MultiSelect list box or just Check boxes???
On Sun, 12 Jul 2009 22:25:01 -0700, jo wrote:
Jo... Please reread my message. You do NOT want a multiselect listbox. You *REALLY* do not want checkboxes on a form. Yes, yes, you can do either; it'd be about 30 lines of VBA for the listbox, and more for the checkboxes, and you'ld need to restructure your form and revise your VBA code whenever you have a new or change item in the list. USE A SUBFORM. It really does work. Hi John thanks for your help I think I shall go as you have advised I have just blinded myself with wanting a Multiselect list box but it is not going to do what I need it to do so I shall go with the Check boxes. Although it would be good if the Check Boxes could be hidden until requested, such as if I have a Check box to check ALL items (keeping the other check boxes hidden) and another Check box to request individual items? Do you think this is possible?? Jo "John W. Vinson" wrote: On Sun, 12 Jul 2009 11:51:30 -0700, jo wrote: Hi I just cannot see which way is best to go MultiSect box or just have check boxes?? I need to Check In & Out sets of items, I have tried the MultiSelect list box but that doesn't seem to store any where to state whether the items are check In or out? And because there are quite a few items to one set of patterns it would mean a lot of check boxes on the form? Can any body point me in the right direction please thanks Jo STOP. You're evidently starting your design with a Form. That's like building a house by putting the frame together... before you've poured the foundations! Data is stored in tables, and ONLY in tables. Get your tables right first and *then* start looking at forms! You'll need at least three tables: Items; People (who is checking stuff out); and Checkouts, with a link to the table of people and a link to the table of items, probably with a couple of date/time fields indicating when the item was checked out and back in. Typically you would use a Form with a Subform (not a listbox OR checkboxes) to enter the data. -- John W. Vinson [MVP] -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|