Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2016-10-27
3
Medium Priority
?
82 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 53

Accepted Solution

by:
Ryan Chong earned 2000 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 53

Expert Comment

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
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: …

688 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