Learn how to a build a cloud-first strategyRegister Now


Collect data

Posted on 2014-08-26
Medium Priority
Last Modified: 2014-08-27
Experts, I have setup a form to collect data.  It seems to work well and the responses are logged in the DB.  

I have a field for Yes, no, maybe and the way the contact is to anwer is a little confusing because it asks the contact to "type the number that corresponds to the value you want" and there is a hyperlink to the bottom of the email that says "in the list below type the number that corresponds to the value you want". Ie 1 = yes, 2= no

How can I avoid this and just simply have yes or no or maybe as the choice for the contact I/o having to type the corresponding number?

Thank you
Question by:pdvsa
  • 3

Author Comment

ID: 40286806
here is the pic in outlook that shows what the contact receives. See circled areas


Author Comment

ID: 40286809
the field "Answer" is a combo box with row source of "Yes";"No";"Maybe".
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 40287564
If you're using the Data Collection feature of Access, then you can't do anything with that Outlook email that's generated. You're stuck with using it as-is, or using alternative methods to capture data.

Also, be aware the Data Collection feature was removed from 2013, with no plans for a replacement feature:


I tried to implement this for a couple of customers, and in each case we ended up using other methods - in a few we created Excel spreadsheets and attached them to the email, and in a few others we ended up creating web pages where users could enter the necessary data.  Both of those methods were far, far more reliable that Data Collection. IMO, it was a feature that was rolled out far too early, and had far too many gaps and inconsistencies.

Author Closing Comment

ID: 40287584
Thank you Scott.  I think I will reconsider.

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Suggested Courses

810 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