|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
October 8th, 2009, 12:58 AM
|
|||
|
|||
|
Password Protect Report OnOpen
Is it possible to have a password for a report?
I have a button which opens a report, however the information in the report is sensitive and therefore is only to be viewed by certain people. Ideally i would like something along these lines. When a user clicks on the report button, a question type box will appear requesting the password, if the password is correct then the report is displayed, else an error message saying incorrect password. If anybody has done something similar before or can offer advice it would be very much appreciated. Thanks
|
|
#2
October 8th, 2009, 01:48 PM
|
|||
|
|||
|
Only thing I could think of would be:
Code:
If InputBox("Enter password")= "password" Then
DoCmd.OpenReport "reportname"
Else
MsgBox "Invalid Entry"
End If
Although certainly not secure to anyone who knows how to get into the code editor and peruse code. Last edited by June7 : October 8th, 2009 at 06:22 PM.
|
|
#3
October 8th, 2009, 05:28 PM
|
|||
|
|||
|
Hi June7, this should do the trick as everybody outside of my team only has runtime version. Thanks for the tip, i'll give it a go. Much appreciated.
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Password Protect Report OnOpen |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
