troubleshooting Question

MS Access Database- Survey Issue

Avatar of Kinlene
KinleneFlag for United States of America asked on
Microsoft AccessMicrosoft Applications
4 Comments1 Solution370 ViewsLast Modified:
To whom it may concern:

I am working on a MS ACCESS database in which users take a simple "Yes" and "No" survey (See Attachment).  The survey use's Social Security Numbers as the primary key.  I realize this isn't normal, however, my military "customer" requires the SSN for this application, so I have no way around it.  I must use the full SSN.  The database application functions perfectly except for when a user has a "Zero" in the beginning of their SSN.  I have set the data type to text and the input mask is set to be a SSN.  I have provided the original database (See Attachment) where the SSN was originally a field named "PerticipantID".  This eventually became the SSN in the final application.  I migrated this survey application into my finished application with little trouble.  It wasn't until users started using the new survey, that I identified the issue, so I checked the provided original (See Attachment) and that too is having the same issue.  I had originally thought I missed something, but when I saw the original survey had the same issue, I realized is must be something else.  Note:  Anyone else with any other SSN or Participant ID other than one that starts with a "Zero" works just the way I wanted it to.  Any assistance you could provide after review of this survey will be greatly appriciated.

Edward J Kinlen
Survey-Database.accdb
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros