Recent content by sameh.abdelkawy

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...