If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Date Done and Date Due problems
NevilleT,
This morning, I figured out what you were saying about the events. When a new person arrives, you need to know which events are applicable to each person so you can start their clock. So, here's the information that might help. 40 employees, of which 10 are civilian, 30 are military. 20 events (for example). 5 applicable to just civilian, 5 to just military, and 10 to both. The 40 employees are divided among 4 Departments (A, B, C, D) . Most of the events are applicable to all Departments, but a few are applicable to just Department A. As I see it, there can be a TblEvent with EventIDpk, EventDesc, EventPeriodicity, CivorMilorBoth, ApplicableSection. I guess you can also create just a tblMilEvent, tblCivEvent, tblDeptAEvent, etc. So, when the new person arrives, you find out whether he/she is civilian or mil and what Department. Based on that, that gives them a predetermined list of Events. Then, for his/her report, all the DatesDue would be blank and red- colored because nothing has been done yet. As the events are done, their due dates would change based on EventPeriodicity. Hope this helps. I am still looking at what you sent. Thank you for everything! VR/ Lost |
#12
|
|||
|
|||
Date Done and Date Due problems
Hi
Getting there. Would suggest in the table events, two yes/no fields. One for military and one for civilian. Easier to pick events if you just filter on the one field. Show me all military events using the military checkbox = true. Show me civilian events using the civilian checkbox = true. When you add a new person, you can have some code that checks if they are military or civilian, sets up records for the first set of records with a date of maybe today, or in a week time, or a month. You can then go in and manually adjust the dates. If you have a completed checkbox on the tblEventWhen record, you can use the after update event to create a new record using the EventPeriodicity. You will need to first check if the new record already exists. One technique I use is to have a completed checkbox on a form that not only stores the fact it is completed, but changes the visible property of the date completed to true. In other words, when they tick the completed box, they see a date completed textbox to fill in. Bit of double recording but you need the date for reporting purposes, and it is useful to have a boolean field to check for completed records. The user thinks they are just displaying the date box to fill in, but they are actually recording information for you. You do need a back out option in case they untick the box. something like If Me.chkComplete = False then Me.txtDateComplete = "" Let me know how that goes. Neville Turbit www.projectperfect.com.au "Lostguy" wrote: NevilleT, This morning, I figured out what you were saying about the events. When a new person arrives, you need to know which events are applicable to each person so you can start their clock. So, here's the information that might help. 40 employees, of which 10 are civilian, 30 are military. 20 events (for example). 5 applicable to just civilian, 5 to just military, and 10 to both. The 40 employees are divided among 4 Departments (A, B, C, D) . Most of the events are applicable to all Departments, but a few are applicable to just Department A. As I see it, there can be a TblEvent with EventIDpk, EventDesc, EventPeriodicity, CivorMilorBoth, ApplicableSection. I guess you can also create just a tblMilEvent, tblCivEvent, tblDeptAEvent, etc. So, when the new person arrives, you find out whether he/she is civilian or mil and what Department. Based on that, that gives them a predetermined list of Events. Then, for his/her report, all the DatesDue would be blank and red- colored because nothing has been done yet. As the events are done, their due dates would change based on EventPeriodicity. Hope this helps. I am still looking at what you sent. Thank you for everything! VR/ Lost |
|
Thread Tools | |
Display Modes | |
|
|