I have some code on a form that requires a password to turn on some other boxes and things.
I've seen some other code for importing data that says to look up a field in the executive table for the file path. I'm wondering if I can tell my code to look up a table field for the password?
The code I saw is:
The password works fine, but the user can't change it without opening the code. I'd like to give her access to update it from time to time (without making major changes to anything
Code:
If InputBox("Please enter password to continue", "Password Input") <> "aaa" Then
MsgBox "Wrong password entered. Operation aborted", vbCritical
Else
do this that and something elseI've seen some other code for importing data that says to look up a field in the executive table for the file path. I'm wondering if I can tell my code to look up a table field for the password?
The code I saw is:
Code:
Function GetProjectTrackingxls() As String
'gets the ProjectTracking Spreadsheet path from tblExecutive
GetProjectTrackingxls = IIf(IsNull(DLookup("[TrackingXlsPath]", "tblExecutive")), "", DLookup("[TrackingXlsPath]", "tblExecutive"))
End FunctionThe password works fine, but the user can't change it without opening the code. I'd like to give her access to update it from time to time (without making major changes to anything
