473,327 Members | 2,090 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Select Multiple Email address from Listbox or Combo box in MS Access

I have a Project in MS Access in which i have made a 4 Table. The table name is as follow Planning, Quality,Production and Manufacturing, each table contain email address.
Now in Form i have made a Combo box which show the name of the Table(Planning, Quality,Production and Manufacturing).So now i want a another Combo box or any other box which show the Email address of particular sector. For example when i select the Planning in 1st combo box, the second box should show me all the email address of planning sector. And i can select one or more email address from that second box.

Can anyone has Idea how to do this? as i am new and dont have much knowledge of MS Access.
Thanks in Advance.
Oct 25 '18 #1
1 1733
twinnyfo
3,653 Expert Mod 2GB
jugalsonar007,

Welcome to Bytes!

You say you don't have much knowledge in MS Access, so we may have to walk through this one slowly.

You can easily do what you want to do in VBA.

In the After Update event of the first Combo Box, you would use the value of that Combo Box to generate a list of e-mail addresses from the selected table, and then assign that list to the Recotrd Source of either a second Combo Box or a List Box.

That is the concept.

Depending on how much or how little you understand about VBA programming will determine how much greater detail I provide as this thread goes on.

Standing by to assist further.

Hope this hepps!
Oct 25 '18 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: dave | last post by:
Hi I'm sending mail using below code. It works fine. How can I send email to more than one address. I wanna add one more address in .to feld or in .cc Set cdoMessage =...
0
by: Bob | last post by:
Hi Everybody I have an MS Access Database that accesses the MS Outlook Inbox. I want to be able to see the full email address that the communication has come from while within Ms Access. ...
3
by: ted | last post by:
Hi, I can't figure out how to set multiple items in a ListBox to selected when the listbox is in a User Control. When the ListBox is set in directly into a form I can use the following:...
4
by: LD | last post by:
Is there a way in Access to store more than one value in a field that has been selected from a combo box? For example, if a combo box had three values that you can select, "One", "Two", and...
3
by: Bernard Lebel | last post by:
Hello, Is there an option or a way to allow the selection of multiple entries in the Listbox widget? I could not find any, and would like to allow the end user to select multiple entries. ...
2
by: hemashiki | last post by:
hi i want to select multiple choices in listbox using ctrl key can any one suggest....plz
2
by: jujutsumaster | last post by:
I have a table containing "AgentName" and "AgentEmailAddresss". I need to loop through the table and get each "AgentEmailAddress" in turn and use it as a query filter for "MyQuery" then use it to...
2
by: billa856 | last post by:
Hi, My Project is in MS Access. In that I have one form in which I have some textboxes,comboboxes and listboxes. Now when I select value from 1st combobox(CustomerID) then it wil generate list for...
0
by: Janu Satish | last post by:
im doing a appilcation for my dad's library.. in which when he selects a borrower's name the dates on which the books borrowed should by selected in the calendar on which date they have taken the...
12
by: benny1983 | last post by:
Hi All, I have some VBA code attached to a button which populates a report to be reviewed by one of my team. I somehow need to make sure these requests are alternated between the two team members...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.