Results 1 to 2 of 2
  1. #1
    specialk is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    4

    Issue with Access Data Collection Replies

    I was able to successfully send and email from access to collect data when I did a test with an employee. When a got a reply, I right click on the email from Outlook and selected the option "Export Data to Access". For the most part the database was updated with the new data. One of the fields in the table is a look up field of employee initials. When I did a parameter query for the initials of the employee that I did the test with, I get zero results, but when I go to the table the information is still there. To be sure it's not a issue with the query design, I did a test of 2 other employees and I got results.



    Does someone know why this is happening?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,770
    Be aware, CollectData is removed from Access 2013.

    I NEVER set lookups in tables http://access.mvps.org/access/lookupfields.htm

    Would have to examine data and query. Follow instructions at bottom of my post if you need further help.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 11-16-2012, 10:15 AM
  2. Replies: 1
    Last Post: 08-15-2012, 12:24 AM
  3. Collecting EMail Attachments using Data Collection Replies
    By Blindswerve in forum Database Design
    Replies: 1
    Last Post: 05-16-2012, 04:56 PM
  4. Data collection
    By ROB in forum Access
    Replies: 2
    Last Post: 11-06-2010, 04:18 PM
  5. Replies: 2
    Last Post: 09-23-2010, 02:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums