Solved

Create Custom Field in a Message linked to a Microsoft Access Table

Posted on 2016-10-27
3
55 Views
Last Modified: 2016-11-20
I have a Microsoft Access Database with 2 tables

Builders.........PrimaryKey......BName
Jobs...............PrimaryKey......JName...........ForeignKey.......BKeyName

I would like to create a custom Outlook Message Form that has 3 Custom Fields:

Builder.........drop down from the access table above
Job................drop down from the access table above
Lot#.............Simple Text Box Not linked to anything

All of the fields are optional

If any of the fields have data in them, I would like the subject line to begin with Builder:XXXXXXXX Job:YYYYYY Lot#:ZZZZZZZ.......followed by anything the user wants to type.

What I am really looking for is a starting point on how to create the drop down list or combo box and am hoping. I am fairly comfortable with VBA in MSAccess.
0
Comment
Question by:rrudolph
  • 2
3 Comments
 
LVL 51

Accepted Solution

by:
Ryan Chong earned 500 total points
ID: 41863418
What I am really looking for is a starting point on how to create the drop down list or combo box and am hoping. I am fairly comfortable with VBA in MSAccess.
when you drop a combo box into your Access form, there should be a Wizard pops up to help you link that to a data source. Don't you see it?
SnapShot.pngyou can also edit the properties below manually when necessary.
SnapShot1.png
0
 

Author Comment

by:rrudolph
ID: 41863711
I may not have been clear on this, but I am working in Outlook, not Access. The data is in Access. I am trying to create a custom message form in Outlook
0
 
LVL 51

Expert Comment

by:Ryan Chong
ID: 41866351
when you want this custom outlook form to be activated?
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question