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

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