password before printing reports

[pnasz]

is there way to print the report in access 2003 after entering password.



thanx in advance

[R_Badger]

You can, however it requires using a form, and a little vb.

First create your password textbox, on the data tab of the properties window, type password in the input mask. I shall refer to this as txt_pw.

I shall refer to the report you want as rpt_protect
Then create a command button on the same form, then right click-> build event-> code builder

The vb editor should open and you should get something like

Option Compare Database

Private Sub Command0_Click()

End Sub

Ignore the top line saying Option Compare Database
you want it to read something along the lines of:

Private Sub Command0_Click()
if [txt_pw]="Password" then
docmd.openreport "rpt_protect"
endif
End Sub

If you want to print preview it instead of directly printing, then use

Private Sub Command0_Click()
if [txt_pw]="Password" then
docmd.openreport "rpt_protect", acviewpreview
endif
End Sub