Recent content by Peetee

Thanks for this Paul - this has worked, and was a much simpler solution.:) Incidentally, the code had to be attached to the Before Update event. Attaching the code to the After Update event made it run in a loop of update form (manually)>run code>update form (programatically)>run code>update...

I have a form (frmClient) which includes a locked textbox txtLastModifedBy which is bound to tblClient.LastModifiedBy. When other controls on the form are updated, the form's BeforeUpdate event triggers some code which includes the line DoCmd.RunSQL "UPDATE tblClient SET...

Thanks Joanne. I've been able to get password changes to work. :)

Linking login ID/pwd to user permissions Thanks for the toothbrush analogy, DCrake. :D Thanks also, Joanne for your code. I see how the code would allow the password field to be updated. What I'm not clear on is how to get the login and password field in the User table to update the...

Can anyone help with how I might be able to force users to change their passwords every 60 days or so? I can set up a table with userIDs and passwords, as well as a form which could set the "last updated" date and a further password expiry date. The question is, how can I link this...