Assigning Diary Actions
Hello everyone
Just wondered if anyone had advice for the following....
I am working with a 'Diary System' as part of a Sales database. I would like the ability to 'assign' certain diary actions to other users.
Currently on logging in to the database the DiaryPage Form loads automatically (as a subform on the MainForm). This shows a particular user's diary actions for the current week (depending on who has logged in, this variable is set on load of the diarypage form).
What I would like to do is have the ability to 'pass' / 'assign' actions to other users (i.e. have the action appear in their diary rather than the person logged on).
To create a diary action (these are set via the SubFrm_Correspondence, which sits on the Frm_Company)... there is a command button which says 'Set Diary Action', once clicked this opens up the diary form where you create the action'. Once set this should (theoretically) then appear in the persons diary who is logged on at the time.
I would be extremely grateful if anyone has the time to help me with this as I have been looking at it for the best part of 4 hours - I'm sure it is probably quite simple but I think an outsiders perspective would be very useful (sometimes its hard to see the wood for the trees as they say).
I have attached my database - It's in Office 2010 (which I have only just migrated to yesterday and I have to say, I'm loving it in comparison to the 2003 version I was using previously)
Eventually I would also like to be able to 'cc' people into the actions to so that it appears in both the diary of the user who is logged on and the 'cc' choice of user too. But, one step at a time
Many Thanks in anticipation....
Hello everyone
Just wondered if anyone had advice for the following....
I am working with a 'Diary System' as part of a Sales database. I would like the ability to 'assign' certain diary actions to other users.
Currently on logging in to the database the DiaryPage Form loads automatically (as a subform on the MainForm). This shows a particular user's diary actions for the current week (depending on who has logged in, this variable is set on load of the diarypage form).
What I would like to do is have the ability to 'pass' / 'assign' actions to other users (i.e. have the action appear in their diary rather than the person logged on).
To create a diary action (these are set via the SubFrm_Correspondence, which sits on the Frm_Company)... there is a command button which says 'Set Diary Action', once clicked this opens up the diary form where you create the action'. Once set this should (theoretically) then appear in the persons diary who is logged on at the time.
I would be extremely grateful if anyone has the time to help me with this as I have been looking at it for the best part of 4 hours - I'm sure it is probably quite simple but I think an outsiders perspective would be very useful (sometimes its hard to see the wood for the trees as they say).
I have attached my database - It's in Office 2010 (which I have only just migrated to yesterday and I have to say, I'm loving it in comparison to the 2003 version I was using previously)
Eventually I would also like to be able to 'cc' people into the actions to so that it appears in both the diary of the user who is logged on and the 'cc' choice of user too. But, one step at a time

Many Thanks in anticipation....

Attachments
Last edited: