Results 1 to 4 of 4
  1. #1
    Robert M is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009
    Posts
    23

    Password Protect Forms


    I am using switchboard to allow my co-workers to access their data that I keep up to date for them. I am needing to password protect the two forms that I have to enter and edit data allowing them to use the forms to display and print their data. Is there a way to do this?

    I have placed a no addition, deletion or editing on the display and print Forms. But I am wanting to keep them out of the Enter and Edit Data Forms.

    Thank you for your help on this matter

    Robert M

  2. #2
    jgelpi is offline Novice
    Windows XP Access 2003
    Join Date
    May 2009
    Posts
    19
    This may be a round-about way of doing it, but couldn't you create a little "Password" form, and then on the "On Click" even for whichever button it is to enter the data modification form just say

    Code:
    if form_password.text1.value is not "password" then
         cancel event '(I can't remember the exact command)
    end if
    I'm not sure if that is what you're looking for or not. Hopefully it helps though!

  3. #3
    Robert M is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009
    Posts
    23
    That is a good idea that I will study on. Thanks for illuminating a dull mind jgelpi

    Robert M

  4. #4
    KLynch0803 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2009
    Posts
    37
    Quote Originally Posted by Robert M View Post
    That is a good idea that I will study on. Thanks for illuminating a dull mind jgelpi

    Robert M
    Why dont you create different form with different acces rights each?

    Example form1 would have (read only), form2 (read and edit), form3 (read, edit, delete).

    Then create you a password box so that based on username it would take them to the proper form based on the users access rights...

    Or you could change the value.visible = "true" for different buttons (ie: Edit, Delete) based on access rights.

    Hope this helps..
    Last edited by KLynch0803; 01-17-2010 at 10:39 AM.

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

Similar Threads

  1. readonly password protect
    By mlgehle in forum Security
    Replies: 1
    Last Post: 03-13-2010, 08:59 PM
  2. Password Prompt
    By thestappa in forum Security
    Replies: 1
    Last Post: 01-28-2010, 09:19 PM
  3. How to set a password to a form
    By heman85 in forum Security
    Replies: 0
    Last Post: 08-09-2008, 07:48 PM
  4. ***PASSWORD HELP***
    By hawkinsgal in forum Access
    Replies: 2
    Last Post: 11-23-2006, 09:10 AM
  5. Change from old password to new password
    By richy in forum Security
    Replies: 0
    Last Post: 11-17-2005, 05:05 AM

Tags for this 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
  •  
Other Forums: Microsoft Office Forums