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
|
|||
|
|||
Access 2003 Combo Box: Can I allow multiple values?
Hi,
I want to enable a user to select more than one item from a combo box. Is there a way to do this in Access 2003? Thanks in advance for any help you can offer. |
#2
|
|||
|
|||
Access 2003 Combo Box: Can I allow multiple values?
No. List boxes offer multi-select functionality.
Can we assume you aren't attempting to store multiple values in a single field? -- Duane Hookom Microsoft Access MVP "Ailish" wrote: Hi, I want to enable a user to select more than one item from a combo box. Is there a way to do this in Access 2003? Thanks in advance for any help you can offer. |
#3
|
|||
|
|||
Access 2003 Combo Box: Can I allow multiple values?
Can we assume you aren't attempting to store multiple values in a single field? Hi Duane, I probably am attempting that but I'm not sure - I'm new at this and it probably shows. I'm a nurse, working for a charity hospice. I'm trying to design a database table and form that can be updated daily with patient information for oncoming staff. The field is named Syringe Driver and I need people to be able to enter two or more drug names as there is usually a combination of drugs in one syringe. I assigned a combo box control referring to a table of drugs we commonly use. But it will only select one drug. I have tried using Shift and Ctrl. I have also tried using a List Box instead of Combo but none of them enable me to select more than one item. Is it not possible? I'm using Access 2003. A search brought up a tutorial that suggests it can be done with Access 2007 but I don't know if our organisation has that version. I'm on night shift right now so there is nobody to ask. Thanks |
#4
|
|||
|
|||
Access 2003 Combo Box: Can I allow multiple values?
Hi Ailish,
instead of storing the Drug in your table, store SyrDrivID as a Long Integer and set up these tables to define what goes into it: SyringeDrivers - SyrDrivID, autonumber, PK - SyringeDriver, text -- for a verbal description Drugs - DrugID, autonumber, PK - DrugName, text SyringeDrivDrugs - SyrDrivDrugID, autonumber - SyrDrivID, long integer -- FK to SyringeDrivers - DrugID, long integer, FK to Drugs - DrugAmt, number, double (dug amount in cc's or however you measure it) This way, you can have one or many drugs in a syringe and specify the amounts as well In the table you are talking about, you would store SyrDrivID as a Long Integer and display SyringeDriver to the user how to do this: make a combobox: Name -- SyrDrivID ControlSource -- SyrDrivID Rowsource -- SELECT SyrDrivID, SyringeDriver FROM SyringeDrivers ORDER BY SyringeDriver ColumnCount -- 2 ColumnWidths -- 0;2 ListWidth -- 2.2 (sum of column widths + 0.2" for scrollbar) Warm Regards, Crystal remote programming and training Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day * Ailish wrote: Can we assume you aren't attempting to store multiple values in a single field? Hi Duane, I probably am attempting that but I'm not sure - I'm new at this and it probably shows. I'm a nurse, working for a charity hospice. I'm trying to design a database table and form that can be updated daily with patient information for oncoming staff. The field is named Syringe Driver and I need people to be able to enter two or more drug names as there is usually a combination of drugs in one syringe. I assigned a combo box control referring to a table of drugs we commonly use. But it will only select one drug. I have tried using Shift and Ctrl. I have also tried using a List Box instead of Combo but none of them enable me to select more than one item. Is it not possible? I'm using Access 2003. A search brought up a tutorial that suggests it can be done with Access 2007 but I don't know if our organisation has that version. I'm on night shift right now so there is nobody to ask. Thanks |
#5
|
|||
|
|||
Access 2003 Combo Box: Can I allow multiple values?
"Ailish" wrote in message
... I have tried using Shift and Ctrl. I have also tried using a List Box instead of Combo but none of them enable me to select more than one item. Is it not possible? Look at the Multi Select property for the listbox control (it's on Other tab in Properties window). That property must be set to Simple (to allow use of Ctrl+LeftClick) or to Extended (to allow use of Ctrl+LeftClick and Shift+LeftClick). -- Ken Snell MS ACCESS MVP http://www.accessmvp.com/KDSnell/ |
Thread Tools | |
Display Modes | |
|
|