Results 1 to 7 of 7

How to Create Login Form

  1. #1
    billgyrotech1 is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    May 2019
    Posts
    169

    How to Create Login Form

    Hello,



    How can a login form be created with password and security levels? I am not that experienced so please not too complicated.

    Thank you very much,
    Bill

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,339
    The way I typically do this is to have a 'login' form that passes a user ID to my 'main' form. The control holding the user ID is locked/disabled so the user can't change it while they're logged in. Then base all button/form accessibility based on the user ID. I typically do that part by having a 'security level' sorted from 1 to x and each control (button, field, etc) I want to show or suppress based on security level I have a routine to hide or show those controls.

  3. #3
    billgyrotech1 is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    May 2019
    Posts
    169
    I didn't create a user table or security table yet. I am sorry I never did a login form.

    I do however have a main Switchboard form setup though.

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    13,910
    Bill,
    Steve Bishop has several youtube videos on this.
    Try google with this criteria youtube ms access steve bishop login form

    Good luck.

  5. #5
    billgyrotech1 is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    May 2019
    Posts
    169
    Thank you Mr. orange I will do that.

  6. #6
    Ajax is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,082
    for the benefit of other responders, crossposted here

    https://www.access-programmers.co.uk...d.php?t=305569

  7. #7
    billgyrotech1 is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    May 2019
    Posts
    169
    This is not cross posted

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

Similar Threads

  1. Replies: 2
    Last Post: 04-17-2015, 10:59 AM
  2. Create a Login Form
    By pshakti in forum Forms
    Replies: 1
    Last Post: 07-23-2014, 03:15 AM
  3. create form login with pasword
    By thomanmpku in forum Security
    Replies: 2
    Last Post: 08-29-2013, 06:32 PM
  4. Replies: 4
    Last Post: 05-29-2012, 01:32 PM
  5. Replies: 1
    Last Post: 12-11-2011, 11:48 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
  •  
Tech Forums: Microsoft Office Forums