Results 1 to 13 of 13
  1. #1
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124

    How to create a Sign out button in access


    I created log on dialog
    How to create a Sign out button, click to Sign out will log off logged account

    Thanks

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,921
    What do you want? Close the app? Just return to the Login form? Set a date/time field in table to show when user finished?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124
    Just return to the Login form

    Logoff the account loging ...

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,921
    Just close the current form and open the Login form as would any other form.

    DoCmd.Close acForm, Me.Name, acSaveNo
    DoCmd.OpenForm "Login"
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124
    It's OK, but still to keep user's password before

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,921
    I don't understand your last post. Is the issue resolved?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124
    I'm using your code but when I log off, in username & password box still remember account's username & password before

    Please advices

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,921
    Is the Login form unbound? Do you close the Login form after user completes login?

    I would have to analyse code to determine what is happening. Direct examination of form would be helpful. Post login form code or provide project. Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124
    Please see my attached file: http://www.mediafire.com/?82dsms9mapfh5s9

    I created a Sign Out button

    when I logging by admin account (username/password: admin/admin) and click sign out

    It will back to Login form, but it still remember admin's username and password

    I want to clear it when back to Login form

    Sorry because my English not very well ..

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,921
    The textboxes are still populated because you don't close the Login form, you just make it not visible. Options:

    1. Close the login form after login, reopen during sign out

    2. Set the textboxes to Null after login
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  11. #11
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124
    How I can do this by code?

    Could you give me code?

  12. #12
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,921
    If code behind the Login form, simply:

    Me.cboEmployee = Null
    Me.txtPassword = Null
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  13. #13
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124
    it's fine

    Many thanks

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

Similar Threads

  1. Replies: 4
    Last Post: 04-14-2012, 07:22 PM
  2. Showing % Sign in Access
    By jo8701 in forum Access
    Replies: 4
    Last Post: 02-08-2012, 10:47 AM
  3. Replies: 35
    Last Post: 09-19-2011, 10:13 AM
  4. Replies: 22
    Last Post: 01-25-2011, 11:19 AM
  5. The ampersand sign (&) and Access reports
    By tigers in forum Reports
    Replies: 2
    Last Post: 09-28-2009, 08:23 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