Password Expiration

[Guest]

I created a custom login form but don't know how to create a code that will
require users to change their assigned password on first login.

Please help

Thanks

 

[Tony Toews [MVP]]

I created a custom login form but don't know how to create a code that will
require users to change their assigned password on first login.

Create a yes/no field in the table. If it is null/false then require
user to change the password. Once changed set to true.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

I really appreciate your quick response.

I used the following code in my main form on load event. The message box
pops up but the change password form does not. And I know the particular user
has not changed its password.

Is it some the following code that's the problem "advisorname = '" &
strtxtAdvisor & "' AND ChangePassword = False" or what.

Private Sub Form_Load()

Dim strtxtAdvisor As String

strtxtAdvisor = Me.txtAdvisorname

If (Not IsNothing(DLookup("advisorname", "tbladvisors", "advisorname = '" &
strtxtAdvisor & "' AND ChangePassword = False"))) Then
If vbYes = MsgBox("Please change your password", vbQuestion + vbYesNo,
gstrAppTitle) Then
' Open the Advisor password form
cmdPasswords_Click

Thanks