please help (1 Viewer)

[burton]

i need help to do a password comfimation screen. Where they enter a password they click on a button this then takes them to another screen. this is supposed to confirm their password. but it actually changes the password. could somebody help me with this.

 

[Hayley Baxter]

Put this code on click of a cmdbutton

Private Sub CmdbuttonName_Click()

Dim strPasswd

strPasswd = InputBox("Enter Password", "Restricted Form")

If strPasswd = "no entry" Then

DoCmd.OpenForm "FrmName", acNormal

Else

Beep

MsgBox "Only members of the Admin Group can access this section of the application"

Exit Sub

End If

End Sub

[Edit] Apologies on re reading your question I now realise you have user passwords rather than a single password to access the next screen so the above won't work.

 

[Hayley Baxter]

Hi Burton

Pat Hartman posted a sample on this forum that might help you. I downloaded it for my reference but I can't seem to attach it to the forum (too big) which is odd because Pat managed to attach it and nothings changed. I've tried compacting and zipping the file.

Email me and I'll send it to you Hayley.Baxter@bskyb.com

Hay