Results 1 to 12 of 12
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Password for Report (2000)

    Here I am again. I have a table that has Rep First Name, Rep Last Name , Password. This works fine in a parameter query so each Rep can only see there report. The problem is how do I let the manager have a password that lets him see all the Reps.

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password for Report (2000)

    Linda

    If the managers machine is secure, and he only views *All* reports from *his* machine, take all the passwords
    out of his query.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password for Report (2000)

    The database is on a share drive. I need a way to let the manager run a report that includes everyone.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Password for Report (2000)

    You might give the manager a customized front end database, with tables linked to the back end. Or create a password form, from which you open the report with a different filter, or no filter, depending on the username/password entered.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password for Report (2000)

    This is just a simple Tracking Form. The manager wants to be able to run his individual report as well as see what everyone else is doing without giving others the capability of running the report for everyone. I thought this would be easy. Not quite sure what you mean by create a password form? You mean a form with a command button that opens the report? Wouldn't I be running into the same problem?

  6. #6
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Password for Report (2000)

    If your parameter query is feeding data to a query to filter the user name, why not add an If Then statement keyed to specific password. For example, your manager's password could be ISeeEverything. Then in the query do in If then statement such as,

    If Password = ISeeEverhthing, then Like ("***") else [password]. So if ISeeEverything is entered, then he gets everything as selected by the ***.

    Option 2 - You could also add a second column for a master password and input his password there and check against the master as well to see what reports he could use.

    Just my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>
    Regards,

    Gary
    (It's been a while!)

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Password for Report (2000)

    You could also implement Access User Security, and set permissions so only he can run the report that shows everyone. That's the most secure way of doing what you describe.
    Wendell

  8. #8
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password for Report (2000)

    I tried what you said in the query but it doesn't work. Maybe the syntax is wrong. Can you show me how to write it the way Access accepts it? I put:

    IIf([password]="Jello",Like ("***"),[Password]). I put this in the criteria for the field Password.

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Password for Report (2000)

    Unfortunately, you can't use Like inside a function. I don't know if the following will work, but it'll take only a minute to try:<pre>Like IIf([Password]="Jello","*",[Password])</pre>

    This is meant to go into the Criteria line for the Password field.

    Note: this won't be secure if you haven't applied user-level security. Everyone can open the query in design view and see the password.

  10. #10
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password for Report (2000)

    As usual your solution works every time. I just needed something that appears to be secure. There are only 4 people who will be using the database and that much security is enough to keep them honest. Thanks a bunch.

  11. #11
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Password for Report (2000)

    Linda,

    Glad you have a solution.
    Regards,

    Gary
    (It's been a while!)

  12. #12
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Password for Report (2000)

    Thanks Hans for keeping me straight. I was about to post a similar solution to yours but you are just too fast... Too many rules with access. I just cant remember them all, but putting the Like first worked just fine.
    <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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