Hi I'm new to this forum and relatively new to Access
I am building a database which tracks tasks assigned to employees. I want to have one of my forms displaying a view which shows at a glance which tasks are assigned to whom at what times of the day, with a click opening a task for editing. My current attempt is to create a crosstab query with the employees as the column headings (a ‘dynamic crosstab’ query) and a table of time values for the hours of the day providing the row headings, with the task as the value. I then created a form based on the query with Datasheet view as the default view (apparently necessary to set properties/event handlers to query values. I got the idea from the Northwind sample database) However, the form fields do not update to reflect changes to the employee list and therefore the onClick handlers are not applied to newly added employees. What to do, besides for programmatically setting the event handlers (a messy job which I at present have not succeeded in doing)? Or is there a different way I should be going about doing this?
Thanx in advance.
I am building a database which tracks tasks assigned to employees. I want to have one of my forms displaying a view which shows at a glance which tasks are assigned to whom at what times of the day, with a click opening a task for editing. My current attempt is to create a crosstab query with the employees as the column headings (a ‘dynamic crosstab’ query) and a table of time values for the hours of the day providing the row headings, with the task as the value. I then created a form based on the query with Datasheet view as the default view (apparently necessary to set properties/event handlers to query values. I got the idea from the Northwind sample database) However, the form fields do not update to reflect changes to the employee list and therefore the onClick handlers are not applied to newly added employees. What to do, besides for programmatically setting the event handlers (a messy job which I at present have not succeeded in doing)? Or is there a different way I should be going about doing this?
Thanx in advance.