Search results

Hello, That's what I need. Thank you so much!!

Thanks for the quick reply but sorry I couldn't apply it. I need more details in example. Your answer will be greatly appreciated.

Hi everyone! I have long records entered in one year and I need to change the background color of records entered every month based on date entered. I need just 2 colors alternatively between months no more. I need to do that on subform in the Form. Thanks for any help.

Hi, Your important notes inspired me to check the query. The problem was in line makes the form not updated automatically. It was a complicated process but I successfully did it. Thank you so much.

Everything is correct.

Sure, I did that.

Hi, I created 2 tables 1,2. When creating a form related to table 1, and adding data to it, the table 1 is updated automatically. Also, when adding data directly in table 1, the form also updated without any problem. When creating a form including the 2 tables, the tables updated automatically...

The logged-in form closed after every successful login.

I just need to track and count the initial entry.

Hi, I have 4 users (User1, User2, User3, User4) logging in to my Access DB. Every user has a username and password in Login Form. They are entering data records in the main table. I need to count total records entered by each user. Is it feasible and how to do it? Thanks for any suggestions.

Excellent solution. It worked smoothly. Thanks a lot!

Yes. You are right. This also worked with me. Thanks.

I'll take care next time. Sorry for that.

Excellent point. Even before it, I can login with someone else's account and password. How can I make it done perfectly?

Yes. You are right. I changed the Password code to be the same as the UserName and it worked. Thank you so much for your time and Suggestions. Have a nice weekend and Merry Christmas. rs.FindFirst "Password='" & Me.txtPassword & "'" If rs.NoMatch = True Then Me.lblWrongPass.Visible = True...

Hello, Thank you all for your suggestions and help. At last I succeeded to solve this problem by repeating code of UserName but in Password and let the rest as it is rs.FindFirst "Password='" & Me.txtPassword & "'" If rs.NoMatch = True Then Me.lblWrongPass.Visible = True...

Hi, Merry Christmas! Here is the code: Option Compare Database Option Explicit Private Sub btnLogin_Click() Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("tbl_Login", dbOpenSnapshot, dbReadOnly) rs.FindFirst "UserName='" & Me.txtUserName & "'" If rs.NoMatch = True Then...

Hello Hartman, Merry Christmas 🎄 This problem is already solved. Many thanks for your help!

Hi, When opening "frm_Login" and entering Username and Password, the code is working perfectly fine. The problem is when entering "Username" without typing the "Password". It's also opening "My_DB" form. I need to check it as in Username. How? The DB file is attached. Thanks for any help.

Yes he did an excellent work on it. Thank you all so much for your help. Merry Christmas and a happy new year to you all.