Results 1 to 15 of 109

Thread: How to create user login form (MS Access 2000 - 2003)

Threaded View

  1. 12-18-2008, 05:46 PM #11
    Allan Murphy
    Allan Murphy is offline Registered User
    Join Date
    Oct 2006
    Location
    Maitland NSW Australia
    Posts
    275
    In the module mod_display_menu

    Select Case valid_user

    Case 2
    ' open and hide the utility form frm_utility
    ' this form will be used to store the user id for as required e.g recording the user id of an user adding records etc.
    DoCmd.OpenForm "frm_utility", , , , , acHidden

    This code opens a form frm_utility and hides it. When the menu screen opens the Login screen closes.

    To store the user id you need to do the following

    me!user_id =forms!frm_utility!user_id

    change me!user_id to your variable name etc.

    Message #44 has the latest version with the frm_utility
    Last edited by Allan Murphy; 12-18-2008 at 05:50 PM.
    Allan
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules