Search results

Thank you man. I don't even know when I changed it. I also double checked all the properties and couldn't see the issue. It was definitely my mistake and couldn't see it while it was in front of my eyes. Thank you for your help and I appreciate it.

The size of the form vertically looks good to me but you can check it yourself. My db is attached here.

There is no subform used here.

Yes there are some codes behind the controls. I modified them and it didn't help. I will try to upload the db.

I was able to add records via query. I also changed some properties of the controls in the form design view. It didn't solve the issue.

I am not sure how to add a record using a query that displays records.

When I am in Form View I can even navigate through the records and see one of the controls in the header changes. A small line in top left corner took my attention. I wouldn't see that line before this issue. I am not sure if that is related or not.

I can run the form's source query and it returns all the records in datasheet view (like a table). My issue is that I cant even see the controls in my form to add a record using the form.

I am not sure what they call it but my form is not one of those that shows the data instead I am using it as data entry. The related property was used (Data Entry: Yes/No) with both options and nothing changed. I have dozens of records in my bounded table.

I even removed that control from my form as you can see in the screenshot. I have screenshot of my property sheet. Do you see any anomaly?

Hello all, I have a simple form in Access 2016. Everything was working as it was supposed to until yesterday. When I changed the property of one of the controls (Unlocked to Locked) in my form and switched back to Form View all my controls were gone. I switched back to design view and everything...

Can you please explain what's going on with the formula you wrote in the last column? concurrent: CInt(DCount("1","t_projects","([compDate] Between " & Format([assignDate],"\#mm\/dd\/yyyy\#") & " and " & Format([compDate],"\#mm\/dd\/yyyy\#") & ") Or ([assignDate] Between " &...

Problem solved. Thank you very much. I appreciate all your helps.

Hi Arnelgp, Thanks for the help. Your query is excluding the projects that were started before assign date of each project, please see the attached image. Project #2 was started on 6/23/2020 and ended on 8/7/2020. In this time frame I worked on 12 more projects. I was expecting to see 13 as...

Not each day. I am counting the projects in my hand based on each serial number. For example it takes 23 days to finish the project with serial number 123456 (6th row in green bars) and within this 23 days I worked on 4 more projects (rows 2, 4, 5 and 7) that may or may not have been finished...

I used this last query and I got the result as shown in image "my Table-2". The numbers are different when you do calculation by hand. The first project was in my bin from 5/10/2021 to 5/22/2021. I that period I only had three projects to work on but the query is showing 4 counts. The second...

Hi Pat, You could be right too. I thought if I am creating a query then a column to show the answer is easier to work on because that's how the queries work (this is my understanding, let me know if I am wrong). Thank you for your help. I will wait for CJ_London while you are busy. I appreciate...

The first project started on 11/11/2020 and ended on 12/23/2020, right? Projects number 2,3,4,5,6,7 started and ended during this period, right? Items 8 and 9 also started on 12/15/2020. As long as the days of working (from begin to finish) on a project falls on a date range then that project...

Yes. Part of the problem is to count the number of the concurrent projects between assigning date and completion date. I was trying to keep my table and explanations as simple as I could. I thought if I needed to include the closing date then I can apply the method you teach me to closing date...

Hi Pat, Thanks for the reply. There is something missing in my query that I am not even aware of that. I try to explain my problem here again so that you can help me better. I am trying to count the number of the simultaneous assigned projects. For example if you look at the attached image from...