Solved

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

Posted on 2016-10-27
3
63 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 52

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 52

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

Suggested Solutions

Title # Comments Views Activity
How to update GAL in O365? 4 33
Records being deleted when Condition Not Met 30 28
Outlook mail to Access 8 29
Can't find draft emails 4 12
When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
Changing a few Outlook Options can help keep you organized!
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

751 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