Search results

boblarson, thanx worked like a charm............ Couple of questions though for my education why the below did not work. 1. So in the lookup statment why the the UserID equal to the Me.txtUser and not to Me!UserID 2. In the frmUserLogonNew I understood why you changed the If and elseif but I...

Thanks boblarson for taking the time.....I will look at it after work

boblarson, I have attached the database, had to delete unnecessary items to make it smaller. I have for testing purposes two users Username - admin; password - admin Username - user; password - user

Bob, The UserID is that the field in the table that is the considered the Primary Key......Or is it the USERID, I have a field called USERID The Dlookup makes sense but i get USERID us not referenced but its there weird

It is on frmUserLogonNew which is not opened yet when frmUserLogon is open. So when I use the above which I tried I get "Database cant find the form frmUserLogonNew referred in the macro expression or VBA..... I believe this is coz the form is not open yet. What can I do to get around it

The reason I used the brackets is if I dont I get a Compile error (Variable not defined) How do I define the variable "VariableWithTheirDate" which is in tblSecurity and the textfield is located on "frmUserLogonNew". I use in Datediff ("d", VariableWithTheirDate, Date) in "frmUserLogon"...

Ok what am I doing wrong...This what I have I created an Update Query qrysecuritydate below is the SQL. Also added in tblSecurity a date/time field called VariableWithTheirDate UPDATE tblSecurity INNER JOIN tblSecurityAccess ON tblSecurity.AccessID = tblSecurityAccess.AccessID SET...

I tried the table, the problem with that it will add the Date() to a new record not to the existing record.......I need a command to transfer Date() to tblSecurity

Ok I tried what I said I wanted to do but for some reason the Defaultvalue= Date() on the textbox is not being saved in tblSecurity. What am I missing?

thats exactly what my thought process was going for I just didnt know how to implement it...I was aware of the darediff, I just didnt know how to capture the "date" they login to change their password. So you are saying use the Dlookup function. If it is not to much to ask how will that be...

Thanks but what i was looking for how to enforce the user to change the password in X number of days

Ok I have a database....And I have a Login (Username+Password) built in, a table with users, a form that open up of opening the database that asks for user name and password.....So thats all good My question I would like to force the users to change their passwords every lets say 90 days or 60...

Marianne, what did you use for disabling the min/max for access 2007. I was trying to find the number to replace &HF060& Thanks

Perfect thats exactly what I wanted... Thank you so much.....

will the Dcount go through all the records in ActionPlan. Let me try this

Below is the do loop i tried but for some reason it doesnt loop across the records.. Am I using the wrong command. Private Sub cmdSearch_Click() Dim rs As DAO.Recordset Dim db As Database Dim varX As Variant Set db = CurrentDb Set rs = db.OpenRecordset("ActionPlan", dbOpenDynaset) If...

Below is what i have so far..........I just need to loop it across the table what i have below only will work for the first record Private Sub cmdSearch_Click() Dim varX As Variant If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then MsgBox "Please enter a value!"...

U r right the form is closed at that point........How do I use the DCount if i may ask? U mean like below If Me.txtSearch = DCount(Forms!frmActionPlan!Seq_Number) Then DoCmd.OpenForm "frmActionPlan", , , "Seq_Number = '" & Me.txtSearch & "'" Else MsgBox "Match Not Found For: "...

What command I can use so that if txtSearch in frmSearch not equal to Seq_Number in frmActionPlan then frmActionPlan will not open up....Below is what i tried but doesnt work. If Me.txtSearch = Forms!frmActionPlan!Seq_Number Then DoCmd.OpenForm "frmActionPlan", , , "Seq_Number =...

SpentGeezer, Let me make sure I am understanding this correctly. So in the form "Data" tab Filter = Seq_Number (I already have this) Then copy the code u have and put it in the "Click" event of the second form that i will be using to search the first form. I will try it it and c what happens