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 (pre Access 2007)
I want to achieve (in Access 2003) what the built-in function in Access 2007
does by allowing users to select multiple items in a combo box or list box. See http://office.microsoft.com/en-ca/ac...311171033.aspx. An example -client table (Client ID, Company Name) -issues table (IssueID, ClientID, Issue Description, Staff Affected) I want users to be able to select multiple 'Staff Affected' in the issues table. I don't want to create a third table for staff affected because I want to keep my data entry form fairly simple. The Access 2007 solution would be perfect but the problem is... if I convert to Access 2007, I lose all my user-level security :-(. The final result is that I want to run a query to see how many issues affect Mary, how many issues affect Joe, etc. Any ideas? |
#2
|
|||
|
|||
MultiSelect List Box (pre Access 2007)
Pn my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ListboxSubform.mdb" which illustrates how to do something like (although not exactly like) this. You can download it for free he http://www.rogersaccesslibrary.com/forum/topic329.html -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "ShelleyS" wrote in message ... I want to achieve (in Access 2003) what the built-in function in Access 2007 does by allowing users to select multiple items in a combo box or list box. See http://office.microsoft.com/en-ca/ac...311171033.aspx. An example -client table (Client ID, Company Name) -issues table (IssueID, ClientID, Issue Description, Staff Affected) I want users to be able to select multiple 'Staff Affected' in the issues table. I don't want to create a third table for staff affected because I want to keep my data entry form fairly simple. The Access 2007 solution would be perfect but the problem is... if I convert to Access 2007, I lose all my user-level security :-(. The final result is that I want to run a query to see how many issues affect Mary, how many issues affect Joe, etc. Any ideas? |
#3
|
|||
|
|||
MultiSelect List Box (pre Access 2007)
I see where you're going with that and it is a nice solution. Where it falls
down for me is that my records appear in a continuous form and when I tried that with your sample the information doesn't appear correctly (only the currently selected records choices show for all records). "Roger Carlson" wrote: Pn my website (www.rogersaccesslibrary.com), is a small Access database sample called "ListboxSubform.mdb" which illustrates how to do something like (although not exactly like) this. You can download it for free he http://www.rogersaccesslibrary.com/forum/topic329.html -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "ShelleyS" wrote in message ... I want to achieve (in Access 2003) what the built-in function in Access 2007 does by allowing users to select multiple items in a combo box or list box. See http://office.microsoft.com/en-ca/ac...311171033.aspx. An example -client table (Client ID, Company Name) -issues table (IssueID, ClientID, Issue Description, Staff Affected) I want users to be able to select multiple 'Staff Affected' in the issues table. I don't want to create a third table for staff affected because I want to keep my data entry form fairly simple. The Access 2007 solution would be perfect but the problem is... if I convert to Access 2007, I lose all my user-level security :-(. The final result is that I want to run a query to see how many issues affect Mary, how many issues affect Joe, etc. Any ideas? . |
#4
|
|||
|
|||
MultiSelect List Box (pre Access 2007)
Ah. You're right. This solution won't work in a continuous form.
Sorry. -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "ShelleyS" wrote in message ... I see where you're going with that and it is a nice solution. Where it falls down for me is that my records appear in a continuous form and when I tried that with your sample the information doesn't appear correctly (only the currently selected records choices show for all records). "Roger Carlson" wrote: Pn my website (www.rogersaccesslibrary.com), is a small Access database sample called "ListboxSubform.mdb" which illustrates how to do something like (although not exactly like) this. You can download it for free he http://www.rogersaccesslibrary.com/forum/topic329.html -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "ShelleyS" wrote in message ... I want to achieve (in Access 2003) what the built-in function in Access 2007 does by allowing users to select multiple items in a combo box or list box. See http://office.microsoft.com/en-ca/ac...311171033.aspx. An example -client table (Client ID, Company Name) -issues table (IssueID, ClientID, Issue Description, Staff Affected) I want users to be able to select multiple 'Staff Affected' in the issues table. I don't want to create a third table for staff affected because I want to keep my data entry form fairly simple. The Access 2007 solution would be perfect but the problem is... if I convert to Access 2007, I lose all my user-level security :-(. The final result is that I want to run a query to see how many issues affect Mary, how many issues affect Joe, etc. Any ideas? . |
Thread Tools | |
Display Modes | |
|
|