VBA programming for forms - OnCurrent

  • Thread starter Thread starter f
  • Start date Start date
F

f

Hi,

I have a query which gathers the following data:
calculates the number of days someone has held a
position, based on the start date and today's date. The
fields are employee_id, startdate, enddate,
lastcontactdate (last date the employee was contacted at
their job).

The output is to a form. My question is, that now I need
the form to do the following upon opening:

List those who have been in a position at 7 days, 14
days, 30 days, 60 days and 90 days. If they have not
been contacted at least one day before they reach each of
these milestones (7 days, 14 days, 30 dats, 60 days, 90
days.

Any ideas appreciated.

-f
 
This doesn't really answer my question.
-----Original Message-----
You may want to look at the Pivot Table Chart, I do something near to your
need using the Pivot Table. Of course you would have to get the data
extracted correctly in a query and the Pivot table chart lays it out quite
nicely

Good Luck

CL





.
Click to expand...
 
It sounds like you are trying to say: If it is a day
prior to a milestone day for someone, I need to know so I
can contact them.

If this is in fact what you are looking for, create a
query with the following fields:
» employee_id
» Days_at_Position: date() - startdate

You will then be setting criteria to only show the
employee if [Days_at_Position] = 6,13,29,59 or 89

You can also include LastContactDate if you need to view
that as well.

You can then create a listbox control on the form with
this query as a rowsource.

Hopes this helps :~)
 
Thanks. Thism is exactly what i need to do.

f-
-----Original Message-----
It sounds like you are trying to say: If it is a day
prior to a milestone day for someone, I need to know so
Click to expand...
I
can contact them.

If this is in fact what you are looking for, create a
query with the following fields:
» employee_id
» Days_at_Position: date() - startdate

You will then be setting criteria to only show the
employee if [Days_at_Position] = 6,13,29,59 or 89

You can also include LastContactDate if you need to view
that as well.

You can then create a listbox control on the form with
this query as a rowsource.

Hopes this helps :~)
-----Original Message-----
Hi,

I have a query which gathers the following data:
calculates the number of days someone has held a
position, based on the start date and today's date. The
fields are employee_id, startdate, enddate,
lastcontactdate (last date the employee was contacted at
their job).

The output is to a form. My question is, that now I need
the form to do the following upon opening:

List those who have been in a position at 7 days, 14
days, 30 days, 60 days and 90 days. If they have not
been contacted at least one day before they reach each of
these milestones (7 days, 14 days, 30 dats, 60 days, 90
days.

Any ideas appreciated.

-f


.
Click to expand...
.
Click to expand...
 
Back
Top