Collect data

Posted on 2014-08-26
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

    Author Comment

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


    Author Comment

    the field "Answer" is a combo box with row source of "Yes";"No";"Maybe".
    LVL 84

    Accepted Solution

    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

    Thank you Scott.  I think I will reconsider.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now