Search results

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

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.

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.

Hi every one, Thank you all for your posts and help, but none of the solutions helped me in solving my problem. In the attached file you will find the exact example which I mean by increment and reset every new month. When opening "Table1 Query", you will find 1,2,3,4 and 1,2,3 depending on...

Hi there, I need to create a query to solve this problem: When entering a new product in the month it has a new serial number starting from 1. This number increments with every new product till the end of the month. A new product in the new month will get a new serial beginning from 1 again. I...

Hello everyone, I have office 2010 and 2019 I have a problem in query, and I would like to show it in the Form. I have one table which has 4 fields: 1- Shipment Name 2- Date Shipment (Entrance), it could be repeated. 3- Date Shipment (Registration), it could be repeated. 4- Shipment Code...