Hello,
I'm trying to get the most out of an Access Database I created, but as I'm no expert at all programming, I got stuck on one of my forms.
I have 2 tables, the 1st called Team, where I have the following data: Id, Name, Surname, Title. The second table is called Hours, where I want to store informations about the hours every team member spends on every proyect, so the data are: PM (project manager), Date, Project, Hours.
To fill in the hours, I created a form Dedication with a subform Hours_per_Project. In the form I show the name of the user, in the subform I show the data of the table Hours. On opening the form, a query asks the identification of the user, showing only his data. As I not only wanted to filter on the name, but also on a certain date, I created a new field in the form to display the chosen date. To choose the date I created a new form, with a pop-up calendar, that opens on opening the parent form. Once chosen the date in the calendar, the calendar closes and shows the date in the created field in the parent form. Until here, everything works fine. However, I'm not able to filter on the date to show in the subform only the hours dedicated that day. But I'm not able to make it work: if I manage to filter on the date, the first filter (on the user) is lost. How can I make it work with 2 filters? My programming skills are limited, so I would appreciate it very much every help you can offer. Thanks.
I'm trying to get the most out of an Access Database I created, but as I'm no expert at all programming, I got stuck on one of my forms.
I have 2 tables, the 1st called Team, where I have the following data: Id, Name, Surname, Title. The second table is called Hours, where I want to store informations about the hours every team member spends on every proyect, so the data are: PM (project manager), Date, Project, Hours.
To fill in the hours, I created a form Dedication with a subform Hours_per_Project. In the form I show the name of the user, in the subform I show the data of the table Hours. On opening the form, a query asks the identification of the user, showing only his data. As I not only wanted to filter on the name, but also on a certain date, I created a new field in the form to display the chosen date. To choose the date I created a new form, with a pop-up calendar, that opens on opening the parent form. Once chosen the date in the calendar, the calendar closes and shows the date in the created field in the parent form. Until here, everything works fine. However, I'm not able to filter on the date to show in the subform only the hours dedicated that day. But I'm not able to make it work: if I manage to filter on the date, the first filter (on the user) is lost. How can I make it work with 2 filters? My programming skills are limited, so I would appreciate it very much every help you can offer. Thanks.