Stretch617
07-15-2009, 11:13 AM
Big noob here. I am building a database to allow insolvency case workers to view upcoming actions relevant to their cases. An actions form (frmActions) will be displayed showing these actions if they are due to be actioned. (!)
I have the bare bones and am now not sure the best way to proceed.
This all revolves around a very specific set of rules such as:
On day 1 of the case appoinment a), b) and c) must be completed.
Within 7 days of appointment a), b) and c) must be completed.
Within 28 days...
On the anniversary...
Anniversary + 2 months...
Anniversary + 3 months...
I have set up a query that frmActions uses to display only those actions which are due within the next month. What I need to achieve is to include rules that prompt the user to tick a completed check box once the actions are completed, and to allow them to see these actions in order of the nearest due date.
I am not very familiar with the VB code or query criteria needed to achieve this. Any help will be gratefully received. Attached is the current version.
I have the bare bones and am now not sure the best way to proceed.
This all revolves around a very specific set of rules such as:
On day 1 of the case appoinment a), b) and c) must be completed.
Within 7 days of appointment a), b) and c) must be completed.
Within 28 days...
On the anniversary...
Anniversary + 2 months...
Anniversary + 3 months...
I have set up a query that frmActions uses to display only those actions which are due within the next month. What I need to achieve is to include rules that prompt the user to tick a completed check box once the actions are completed, and to allow them to see these actions in order of the nearest due date.
I am not very familiar with the VB code or query criteria needed to achieve this. Any help will be gratefully received. Attached is the current version.