Search results

Ok I have figured out how to get it to log users out and input a time and date, but it is the wrong time and date. But I am having no luck with not having the LoginID being blank as you mentioned.

Well I have tried to use the code that you posted arnel and I just keep getting a syntax error: Syntax error (missing operator) in query expression 'UserID = And DateValue(LogInDateTime) = #11/25/2024# And IsDate(LogOutDateTime)'. I updated it to reflect my table field names but I still get...

autoexec macro? I have never used that, never even heard of that before. I guess its name is self explanatory but how to use it, I am not sure, and where do I find it exactly? Guess I will need to do some googling on this part, but thank you arnelgp I will see what I can find out.

NickCoe I was referring to the main access window X. Cheekybuddha I will try this suggestion to see if it works and update either way.

Hi, So I have a question, I have a database that when a user logs in, it records their time, date, and status if they are logged in or not. Then I have a button for logging out. But as I am sure everyone knows people like to click the X. If they do this they database keeps their status as...

Yes that seemed to fix my problem. Thank you for pointing that out for me cheekybuddha. And yes this is mostly for cosmetics.

Okay I have a login form and when the temporary password is set to "Password" for a new user, the new user logs in and then it should direct them to change their password upon first login. So on the login form I have this code set on the login button: Private Sub cmd_login_Click() Dim...

Hi again, I am having trouble with my change password form. What I want to happen is when a user logs in with their temporary password which once assigned will simply be Password then they are redirected to change their password upon that first login, which is working fine. The problem is...

Ok I figured out how to modify the code on the sample DB you uploaded Arnel. I think I have it working, but i will play around with it and make sure. Again thank you.

Well, I do realize what I am asking is a bit strange and confusing. Your demo works perfectly Arnel, however I have 5 fields on the form and I only need 1 specific field to need this requirement, the other 4 fields have other data that need input. But I just need to figure out how to modify...

Hi, I am sorry to keep beating a dead horse but I need a bit more help on validation. I have my form with an unbound field. I need the information to simply be a 0 or a 1 that the user enters. If anything else I need a message box to pop up and say, it needs to be 0 or 1. So I have tried...

Ok, I have a password change form. On that form it has a combo box and the password and confirm password fields. I want to stop using the combo box and change it to just a regular unbound field. So, I did this and now I am having errors when it tried to run. When I use the combo box I have...

Thank you for the information Minty. Being limited to exactly 6 characters is a problem. I just wanted a minimum of 6 characters but up to as many as they want. I think I found something not requiring VBA that works. Also thank you gasman, I build it and ended up using this...

Hi, I have a form which does a password change using 2 unbound fields. I want the fields to require a minimum of 6 characters but I do not know if that is done in the validation rule or using VBA. Stupid me I tried to do it in the table it updates to, but since the fields are unbound... well...

Using the same type of conditional formatting I found that using expression is with IsNull(txtfirstname.Value) in the field for it works exactly how I was wanting.

Ah thank you for the clarification. It seems to have solved my problem.

I am not familiar with using conditional formatting just to determine if anything is entered into the field let alone 5 fields. Are you talking about using VBA as conditional formatting or the point and click conditional formatting?

Hi, I am trying to change the background color of the unbound field on the form I have which I have successfully done using the following code: Private Sub txtFirstName_Exit(Cancel As Integer) If IsNull(txtFirstName) Then Me.txtFirstName.BackColor = vbRed Else...

Wow I had the correct code just not placing it in the correct location. Thank you arnelgp. It is working now how I wanted it to.

Oh yes it is, sorry I forgot to include that part. I have edited my post again to reflect it as such.