Results 1 to 7 of 7
  1. #1
    drarthur is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    4

    creating a sign in sheet

    I am trying to check in 100 people that are coming from a school. I have all their information in access such as first and last name, name of school and student ID. My goal is to have up on the computer screen a blank cell titled STUDENT ID. When the student come is they type in their ID and hit enter. Then the next screen shows their full name and school. At the end of the day i want to be able to see how many kids of the 100 showed up.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if you already have a table of all persons and their ids (tPerson table?)
    then you need a form with a textbox, txtID, for the user to enter their id.
    a subform would be on the form to display their full name and school. The subform is linked to the txtID in the master form.

    now once the name appears, do you want it to add this person to the tCheckIn table?
    or ask 'CheckIn' and user clicks OK to add it? (in case they entered the wrong number?)

  3. #3
    drarthur is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    4
    I would like to have 3 or 4 text boxes that they can fill out. If they don't know their ID then they can put in there first and last name. Once any of these are entered then i would like all the fields to populate that are connected to that student, school, home address etc. If that is the person then they hit enter, that information goes to a table with a time stamp and the from becomes blank for the next person to enter their info

  4. #4
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    With such a design students can easily see other students personal data - not good. Each student should be given a unique login ID and password to login, which (imo) if they forget their password they have to notify the admin in person.

  5. #5
    drarthur is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    4
    so you can't just have a blank form that when the student enters their Student ID the rest of that student's info comes up? They click enter and then the form goes blank again???

  6. #6
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    then you may as well just let them enter their name and NOT do a lookup.
    what if they type their name not quite how it is in the table, ie. table= James Taylor, but they login as Jim.

    I would just allow data entry. The person can enter FirstN, LastN, and school.
    and accept with no lookup.

    then aftermath ,you can run queries to match those that are correct,
    and manually match those that didnt quite match.
    then figure what to do with those that dont match any.

  7. #7
    drarthur is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    4
    That sounds better. Just trying to make it so they only see what they are entering. First Name, Last Name, ID# and then a drop down with the 5 schools so they can choose their school. Would this be done in Forms or Tables?

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

Similar Threads

  1. Replies: 2
    Last Post: 07-16-2015, 12:26 PM
  2. Replies: 1
    Last Post: 04-01-2014, 04:18 AM
  3. Sign Out and Sign In Student Database
    By jamiers in forum Forms
    Replies: 6
    Last Post: 08-29-2012, 02:03 PM
  4. Replies: 6
    Last Post: 10-17-2011, 11:16 PM
  5. Replies: 1
    Last Post: 03-02-2011, 03:08 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