Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / May 2008

Tip: Looking for answers? Try searching our database.

Multiple selection from within a listbox

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ADixon - 28 May 2008 15:54 GMT
Hi all

I have a simple form based Access front end which is used to select some
existing info stored in tables, and also to gather user input. The info is
then sent to recipients via Outlook. I need to find a way of taking multiple
selections (also possibly single selections) from a listbox on a form and
placing it into the emails. As there is no way of knowing how many items
there are, how can i first take the info from the listbox, and second use
this info in Outlook?

Many thanks
mscertified - 28 May 2008 16:08 GMT
(1) Define your listbox as multi-select (look in Access Help)
(2) Read thru the selected item collection to get the selections (look in
Access Help)
(3) Use the Outlook object to compose and send the emails.
(4) Expect to get a security prompt whenever you try to send an email via
Outlook and Access.

-Dorian

> Hi all
>
[quoted text clipped - 7 lines]
>
> Many thanks
Klatuu - 28 May 2008 17:26 GMT
mscertified gave you the answer, but to find out how to loop through a list
box to determine which items are selected, see VBA Help for ItemsSelected
property.
Signature

Dave Hargis, Microsoft Access MVP

> Hi all
>
[quoted text clipped - 7 lines]
>
> Many thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.