Hi,
Please can someone help me with the below problem?
I'm am trying to set up a Task Manager Database in access to allow me to track what tasks are assigned to a project and follow them through their life cycle. The new 'collect data via email' function in access 2007 is potentially really useful to me as it will allow me to send an update request to the person who owns the task, to tell me how far through it they are etc.
My problem arises where i have more than one task assigned to the same person. I do not want to send them an update request on all of the tasks that are assigned to them as they may not have all started yet for example.
I do not seem to be able to run a query to limit the criteria i want to email out. I can run the collect data wizard from a query but it provides me with a blank form to fill in and i need it to pull through the existing data and allow updates.
The option in the collect data wizard that asks if you just want to accept new records or allow updates to existing data disappears when you run this off of a query.
Is what i am trying to do going to be in any way shape or form possible? Sorry if this is all a bit vague, if it is I can try to give examples and be a bit more specific.
Many thanks to all responses.
Rod
Please can someone help me with the below problem?
I'm am trying to set up a Task Manager Database in access to allow me to track what tasks are assigned to a project and follow them through their life cycle. The new 'collect data via email' function in access 2007 is potentially really useful to me as it will allow me to send an update request to the person who owns the task, to tell me how far through it they are etc.
My problem arises where i have more than one task assigned to the same person. I do not want to send them an update request on all of the tasks that are assigned to them as they may not have all started yet for example.
I do not seem to be able to run a query to limit the criteria i want to email out. I can run the collect data wizard from a query but it provides me with a blank form to fill in and i need it to pull through the existing data and allow updates.
The option in the collect data wizard that asks if you just want to accept new records or allow updates to existing data disappears when you run this off of a query.
Is what i am trying to do going to be in any way shape or form possible? Sorry if this is all a bit vague, if it is I can try to give examples and be a bit more specific.
Many thanks to all responses.
Rod
