Results 1 to 2 of 2
  1. #1
    bjelinski is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010

    Login form plus filter

    Dear all,

    i want t o make a simple form for the database , where people will be able to add the required data! At the opening there will be login screen that is connected to the passwords, and after the user chooses his name and types the password it should open the other form for imputing the required data! The problem is I want that the form (table) that opens after login is filtered for the name chosen (the names in the password table and in the data section are the same) , but I am not able to make this. I was thinking to make the query and apply the formula, but it doesn’t work (it asks me to type in the name) .

    so the process should be, they choose the name from the list, they type the password and if it is the right one, then the form opens, but filtered for their name (so only their data).

    in the attachment you can find the dummy file.

    thanks in advance for any help,


  2. #2
    bjelinski is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    and yes I forgot to say the login passwords for the dummy data! passwords are 1st name with small letter! so if it is Dirk Name , than the password is dirk


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

Similar Threads

  1. Replies: 2
    Last Post: 11-25-2013, 10:56 AM
  2. Login Form
    By Kookai in forum Access
    Replies: 3
    Last Post: 10-18-2010, 04:23 PM
  3. Login form register
    By isnpms in forum Security
    Replies: 1
    Last Post: 08-01-2010, 10:30 PM
  4. Access login form help
    By Tempuser in forum Forms
    Replies: 8
    Last Post: 09-10-2009, 06:55 AM
  5. Replies: 1
    Last Post: 01-04-2008, 11:40 AM

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