Search results

Ok so this is a rather simple question. Im somewhat new to VB but Im creating a button to check if something is in the table with a Dlookup but I dont know what the command is for save. My code looks like this If =Dlookup("Emp_ID","tblEmployeeDaily","Emp_ID=" & Emp_ID AND "DailyDate=" &...

The sample looks like it works but then when I use the user with less access (i.e.) read only access he can still modify the files so I'm not sure if it actually works. The other thing is do you know the code to put in an alert box cause that doesn't work on that code either.

Ok so I am kinda new to Access I have managed to create a database and have a form that updates the password into a table after they click a button in the password field. Now what i want it to do is to create a Msg box on my other forms prompting a user for a password then checking it against...

You are absolutely amazing! Thanks

Hey, So i tried to use an update query applied it to an onclick button and what not. This was the final code that i put in CurrentDb.Execute "UPDATE tblEmployeeInformation SET " & _ " Emp_Password = Forms!formEmployeeInformation!Emp_password WHERE " & _ "[Emp_ID] = " & Emp_ID The table i...

So I'm creating my own user-level security thing and I have some basic code experience but not much. Anyway what I have right now is a if statement to check the password put into the Access form against the password in the table. What i need help with now is saving that particular password...