Results 1 to 4 of 4
  1. #1
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286

    Creating a Login Screen on Form, How to check is Password matches Username

    Hello, im trying to create a simple login page. i have a table with two columns (username, and password). On my form, i have a combo box. the combobox shows a drop down of all the usernames i have from that table. Then, i have a textbox where users can enter a password. if the password does not match what is it in the table for the specified username, a msgbox will appear, otherwise open new form. how do i write this in vb? thanks

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,712
    If you're going to use a combo, you might as well include the password field in the row source (hidden) and test against that.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286
    how do i hide the password column on the drop down list? and can you help me write the vb code of how to test against it..? thanks

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,712
    Use the column widths property of the combo to hide it. The test would be:

    If Me.PasswordTextbox = Me.ComboName.Column(1) Then
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 4
    Last Post: 05-29-2012, 01:32 PM
  2. username&password
    By metokushika in forum Access
    Replies: 1
    Last Post: 11-16-2011, 03:13 AM
  3. Username/Password From Table
    By mj-egerton in forum Programming
    Replies: 0
    Last Post: 04-03-2011, 04:46 AM
  4. Recording UserName Login
    By Moonsitter53 in forum Access
    Replies: 1
    Last Post: 03-18-2011, 02:40 PM
  5. Change username and password form..
    By Mrcams in forum Access
    Replies: 9
    Last Post: 12-07-2010, 11:22 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 - Senior Forums