Results 1 to 4 of 4
  1. #1
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155

    Password Protect Forms

    Hey



    I have several forms in a database. I want to password protect two of these. How can I do this? I have heard I can use VB in the two forms to prompt a password parameter like box and if entered correctly, it allows the user to continue, and if not, it does not let them. Is this possible?

    Thanks,

    Desperity Seeking Easier Security then Workgroups!

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    try:
    Code:
    private sub form_load()
    if inputbox("enter pw", "secured form") <> "password" then
       docmd.close
    end if
    end sub

  3. #3
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155
    Okay, it worked in one data base, but when I tried to put it in the one I wanted...I got an error...

  4. #4
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155
    Got it. Had two Form_Load in the VB.

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

Similar Threads

  1. Password Protect Buttons on Forms
    By Desstro in forum Forms
    Replies: 13
    Last Post: 08-24-2012, 05:04 PM
  2. P/W Protect & Open Database Using VBA
    By DrGlenn in forum Programming
    Replies: 1
    Last Post: 08-06-2010, 08:08 PM
  3. Replies: 0
    Last Post: 07-08-2010, 11:22 PM
  4. readonly password protect
    By mlgehle in forum Security
    Replies: 1
    Last Post: 03-13-2010, 08:59 PM
  5. Password Protect Forms
    By Robert M in forum Programming
    Replies: 3
    Last Post: 01-15-2010, 01:50 PM

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