Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    billgyrotech1 is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    May 2019
    Posts
    179

    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,442
    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
    179
    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
    16,716
    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
    179
    Thank you Mr. orange I will do that.

  6. #6
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    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
    179
    This is not cross posted

  8. #8
    Hpool2018 is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Apr 2019
    Posts
    10
    Hi,

    I am creating a base platform for access programs. This includes.

    Login form
    New Switchboard and manager
    Setting system
    Encryption
    Template forms

    If anyone is intrested in code forms or developing the idea, please get in touch

    Click image for larger version. 

Name:	Login.PNG 
Views:	54 
Size:	82.4 KB 
ID:	39532

    Click image for larger version. 

Name:	sb manager.jpg 
Views:	54 
Size:	106.0 KB 
ID:	39533

    Click image for larger version. 

Name:	settings.jpg 
Views:	54 
Size:	90.2 KB 
ID:	39534

    Click image for larger version. 

Name:	modules.PNG 
Views:	53 
Size:	8.1 KB 
ID:	39535

  9. #9
    Uncle Gizmo is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    26
    Hi Hpool,
    I have created my own switchboard management system based on the original Microsoft switchboard manager.

    https://www.niftyaccess.com/nifty-switchboard-builder/

    I would be interested in collaborating with you on future developments of both of our systems...

    Sent from my Pixel 3a using Tapatalk

  10. #10
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Hi Hpool
    Couldn't help but notice several of my code modules in your navigation pane screenshot.
    Hope you are finding them useful.

    Just to add that before you reinvent the wheel, there are many existing examples available online that cover much if not all the items you have listed.
    For example this password login in form with session info http://www.mendipdatasystems.co.uk/p...gin/4594469149
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  11. #11
    Hpool2018 is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Apr 2019
    Posts
    10
    Hi Colin,

    I am and I am trying to put a number of the most useful modules in one place.

    Which bits are the code you wrote? who name will it have?

    I am also trying to create a decent UI.

    Regards

  12. #12
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The highlighted modules are all from my applications - possibly from the control the Application Interface app available at http://www.mendipdatasystems.co.uk/c...ace/4594365418 and various forums.
    Some of the code was written by others who I've acknowledged.
    The rest of the code is mine or modified by me unless stated otherwise in the modules.
    My full name is in modResizeForm e.g in FixFormzSize if you want to state authorship
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  13. #13
    Hpool2018 is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Apr 2019
    Posts
    10
    Quote Originally Posted by isladogs View Post
    The highlighted modules are all from my applications - possibly from the control the Application Interface app available at http://www.mendipdatasystems.co.uk/c...ace/4594365418 and various forums.
    Some of the code was written by others who I've acknowledged.
    The rest of the code is mine or modified by me unless stated otherwise in the modules.
    My full name is in modResizeForm e.g in FixFormzSize if you want to state authorship

    Hi,

    Yes i found theses a few weeks ago, really great code, many thanks. I've added as is so all acknowledgments as still there.

    Would it be worth starting a GitHub and putting all the best bits of code in one place?

    Regards

  14. #14
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Hi
    You can already find all my example apps, code samples and extended articles in one place.
    Check out my website http://www.mendipdatasystems.co.uk/

    I have thought about starting a GitHub area as well but other things are higher priority for now.

    Anyway I'm glad you're finding the code useful.
    At some point I really should add my own name as the code author on each module where relevant...
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  15. #15
    Hpool2018 is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Apr 2019
    Posts
    10
    Quote Originally Posted by isladogs View Post
    Hi
    You can already find all my example apps, code samples and extended articles in one place.
    Check out my website http://www.mendipdatasystems.co.uk/ some great stuff there.

    I have thought about starting a GitHub area as well but other things are higher priority for now. Ok i can start one.

    Anyway I'm glad you're finding the code useful. Yes very
    At some point I really should add my own name as the code author on each module where relevant...
    Ive never put my name to anything


    I wrote a right menu constructor. need to find where it is.

    Was working on a context calculator, IE for dates if on a date.

Page 1 of 2 12 LastLast
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
  •  
Other Forums: Microsoft Office Forums