Search results

I figured I have to use an UPDATE statement to replace the current password with the new password. An UPDATE statement though won't solve my first issue.

Can I look up and verify data on a “second” form based on a selected record from first (still open) form. I’m trying to allow users to select a User Name from a combo box list and then open a “Change Password” form when they select “Change Password” for that selected user name. My problem is...

Thank you...problem solved... Thanks GolfProRM. Problem solved.

Thanks GolfProRM...you got it! Thank you. I tried figuring out the single quote syntax but couldn't get it... The following DLookup also fails...is the use of single quote the problem here too? If IsNull(DLookup("[UserID]", "tblUsers", "[UserID] = '" & Me.txtUser & "'" And "[UserPWD] = '" &...

That won't work..... I'm not sure where your going with this suggestion...CLng won't work in this case, txtUser is not numeric, it's text. When executed your statement returns a type mismatch error.

This forum has saved me so many times. Thanks to all the experts. I hope to get good enough to contribute and pay back (or pay forward as it were)...anyway... I know I should look at and perhaps use the "on-board" security in MS Access..but I'm building an application that needs a sign on...

I'm using the following code (found here, and it works great!) to search for an open a file. It lists every file in a directory which is exactly what I want. I've tried without success to build on this code to open the file list and then after a file is selected copy that file to a new...