Microsoft access, trouble filtering out values to the right team, team 2 and 3 have the same states, but team 3 should get it if a value is met
in microsoft access i have a table that stores states for different teams, team 2 and team 3 should have the same states, so an example below.
disable certain dates in a calendar in a form
as you can see i have a table that contains holidays (T_holiday) and a table that contains employees and their busy days. And i have a form that lets the supervisor choose the date on which each employee gets a certain task. The choice is made using a calendar in the form. And i want the supervisor not to be able to choose the dates on which there is a holidays or on which the employee already is busy as by disabling these dates from the calendar in the form.
here is the attached files.
Creating a query with a Value from taken from a Form
I have created a query in a database “Q_AktenListeSachbearbeiter” which takes the value from a form “F_Sachbearbeiter_Input” as criteria.
Disable specific days in calendar [ms-access]
I found this calendar in this forum which I would like to take advantage of to enter personal travel dates.
so I ask for your help in such a way as to deactivate the selection (click) in a day in this calendar when at this day is a public holiday (table: T_holiday).
C:UsersHP Z5DownloadsPractice-File_Custom-Calendar-Control-MS-Access
How to utilize make table query’s results within design view in Microsoft Access
Having an issue designing a query in Microsoft Access. I have my query finalized except I need the results from a Make Table query. Previously I’ve seen the ability to add a make table query in the design view, but now I can’t drag the make table query into design view or search for it. I need the results of the make table query in this new final query.