password protect report?

[Weresmytriple]

hi all,

i was just wondering if it was possible to password protect a report. so for example when a user clicks on the button from a switchboard a password prompt would open up and if a user entered an incorrect password the report wouldnt open up. if it is possible how would i go about doing this?

thanks for any help

Michael

 

[CJ_London]

It depends on how secure you want it to be - normally you would set up a security system which provides user rights at the time of login - you will find plenty of examples here in the forum.

If this is a one off, you could just use an inputbox to request a password along the following lines:

if inputbox ("Please enter the password","ENTER PASSWORD")="password" then
    docmd.openreport.....
else
    msgbox "wrong password", vbOKonly
end if

 

[Weresmytriple]

that works great thanks. it didnt have to be that secure as the database is already password protected. it just needed a simple method to keep it slightly more secure.