Password a form

[Jen0dorf]

Hi



been trying to use VBA to password a form and found the code below.

typed it in manually and had errors, Then copied and pasted the code into the onload event in the vba window and got the same errors

"The expression may not result in the name of a macro, the name of a user defined function or event procedure"

There may have been an error in evaluating the function, event or macro

I searched the web and found the suggestion to use the compile option in the VBA window which I did and got the error below

"Invalid Outside procedure!"

Private Sub Form_Load()
Dim PassWord As String
PassWord = InputBox(“Enter Administrator Password”)
If PassWord = “admin1234” Then
‘ Open Form
DoCmd.OpenForm “frmAddRecord”
DoCmd.GoToRecord , , acNewRec
Else
MsgBox (“You’re not authorized for Administrator access.”)
End If
End Sub

I do realise it's probably not terribly secure but it's really only to stop accidental changes rather than a determined attack

Would as usual appreciate any pointers

Thanks

Ian

[ItsMe]

Try changing
MsgBox (“You’re not authorized for Administrator access.”)

to
MsgBox "You’re not authorized for Administrator access."

EDIT: Also, it seems you may have smart quotes pasted into your VBA Editor. Erase the double quotations and replace them by typing in another double quote.

[Jen0dorf]

Hi

thanks for the hints

regrettably it did not solve the issue

off to research

cheers

Ian

[ItsMe]

You might be asking Access to do something it cannot do while the form is still loading. Not sure what the form is about, but you might be able to run your code using an event other than the OnLoad event. Maybe On Current is suitable or use a command button or ...

[Jen0dorf]

HI

thanks, the research is continuing

Ian

[HiTechCoach]

Ian,

I recommend using he form's On Open event to ask for the password.

Here is a better way to handle what you want to do: https://support.microsoft.com/en-us/kb/209871

[HiTechCoach]

Ian,

If the form is only to be used by certain users then what I like to do is in the form's On Open event check the logged on user name, like the Windows User Name, to look up in a table to see if they have permission to use the form.

[Jen0dorf]

Hi

thanks thats what I need

cheers

Ian

[HiTechCoach]

Hi

thanks thats what I need

cheers

Ian

Ian,

You're welcome.

May you have great success with your project.

[Homegrownandy]

you could always split the database and issue a front end that just allows them to change what you want.

[HiTechCoach]

you could always split the database and issue a front end that just allows them to change what you want.

Great point.

I often use multiple front ends to separate out "admin" functions for "data entry" functions.