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
|
|||
|
|||
List Box Query
Hello
I have a table which contains peoples names and the building they are based in plus their email address, is there anyway of having a list box on my form so then the user can select mutiple buildings to send an email to. I already have the code to send the email but I would like to know if it is possible to run a query based on the selection i make in the list box, Thanks Jamie -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200512/1 |
#2
|
|||
|
|||
List Box Query
See the article 'Use Multi-Select List Boxes as Query Parameters' at the
following URL ... http://www.mvps.org/access/forms/frm0007.htm -- Brendan Reynolds "Jamie Harbour via AccessMonster.com" u16161@uwe wrote in message news:587a9cada6db4@uwe... Hello I have a table which contains peoples names and the building they are based in plus their email address, is there anyway of having a list box on my form so then the user can select mutiple buildings to send an email to. I already have the code to send the email but I would like to know if it is possible to run a query based on the selection i make in the list box, Thanks Jamie -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200512/1 |
#3
|
|||
|
|||
List Box Query
Yes it is. Look in VBA Help for the ItemsSelected collection.
"Jamie Harbour via AccessMonster.com" wrote: Hello I have a table which contains peoples names and the building they are based in plus their email address, is there anyway of having a list box on my form so then the user can select mutiple buildings to send an email to. I already have the code to send the email but I would like to know if it is possible to run a query based on the selection i make in the list box, Thanks Jamie -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200512/1 |
#4
|
|||
|
|||
List Box Query
Ok, i have that code copied into the Click event of my button, i also have
alist box on my form. But there are no instructions as to the variables i need to change? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200512/1 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filtering a Query with List Box | SCHNYDES | General Discussion | 4 | October 13th, 2005 06:26 AM |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
Error when running Query, but not Report | Blaze | Running & Setting Up Queries | 29 | September 9th, 2005 05:40 AM |
adding 2 fields including null entries | Jesse | Running & Setting Up Queries | 26 | January 18th, 2005 05:31 PM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |