Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005

    Unanswered: Password protecting a report

    I have set up an input box for a password that opens a report using the following code:

    Private Sub Report_Open(Cancel As Integer)

    Dim PW As String

    PW = InputBox("Please enter the password")
    MsgBox "The password you entered is not correct"
    Cancel = True
    Exit Sub
    End If

    End Sub

    I'd like this to be disguised using the password input mask but don't know how to do this. Any help would be greatly appreciated.

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Pull the value from a form instead. You can set your input masks at the form level.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    Another technique could be to make use of the workgroup security file.
    Access workgroup secure?
    -okay so bear with me on this one:-
    if you create a workgroup file, add the network logons of your users with sutitable privileges / user group memberships, leave admin as a user but with zero privileges. The reason allows anyine to logon without requirng a password - effectively what matters is how they have logged on to the network

    query the grop permissions to find of the network user is a member of the specified group in the reports on open event. Youhave the userrid as how they announced / authenicated themselves to the network, but you control permissions according to the workgroup permissions.

  4. #4
    Join Date
    Sep 2005
    Thanks I've sorted this now

Posting Permissions

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