Date-Timer

  • Thread starter Thread starter Sander
  • Start date Start date
S

Sander

Hi,

I have a table in which you could enter a few dates. For
example:
Request (datefield)
Answer (datefield)
Offerte (datefield)
Option (datefield)

From all these datefield I want to get a message.
For Example
Request - 29-11-2003 (timer set to 5 days)
When I open the database 5 days later on 04-12-2003 I want
to get a message which says e.g.: "Did you look after the
request for customer ......".

Does anyone know how the program this in some kind of way.

Help would be very appreciated.
Thanks in advance,

Sander.
 
It sounds like you want to have a form load on the startup. this form would
have a record source showing all records where Request <=Date() Or Answer
<=Date(), and so on.

hope that is what you were looking for
 
Sort of, but it is a database with customers, these
customers have events so the database should check if
there are actions to be taken. One of these actions is
that invoices or offerte's should be sent to the customer.
Me the user should be informed so thats why there must be
a timer to remind me. for the taken actions.
If a Event finish at 30-11-2003 I have to get a message
that says sent invoice for customer ..... and so on.

Could you help?

Sander.
 
Possibilities

On a form load event, call all user IDS (and names if your want;
whatever) ), relevant control values (eg. checkboxes) and event dates in a
recordset, and evaluate each date against "date()" and the status of a
control (like a checkbox). . If more than a set period has expired, do
something (eg. write to a temporary table linked to a report, generate
report...., hey even load a subreport from a temp table)

In fact, if you are uncomfortable using the recordset route, you can
probably do the same purely through a query. for each customer record
comparing the imputed date + (for example) 5 against "date() "(you may
need the datediff() function [ don't think so]) and the status of a control
source ( eg checkbox.value = -1 )and connecting your query to a report or a
form or subform . Same thing: use a form load as rthe triggering event for
the query and report.

Hope this is helpful

John S
Aylmer, PQ

PS. With the query, you'll probably have to fiddle with it in the SQLquery
view so that the ands and ors are paired together properly..
 
PHieu, I am not yet a senior in this. Isn't there a easier
way to do this. Because i don't understand a word of it.
At least i understand a bit. But it's not clear to me know
were to start or with what. Sorry.
Would you like to explain it to me ones more.

Sander.
-----Original Message-----
Possibilities

On a form load event, call all user IDS (and names if your want;
whatever) ), relevant control values (eg. checkboxes) and event dates in a
recordset, and evaluate each date against "date()" and the status of a
control (like a checkbox). . If more than a set period has expired, do
something (eg. write to a temporary table linked to a report, generate
report...., hey even load a subreport from a temp table)

In fact, if you are uncomfortable using the recordset route, you can
probably do the same purely through a query. for each customer record
comparing the imputed date + (for example) 5 against "date() "(you may
need the datediff() function [ don't think so]) and the status of a control
source ( eg checkbox.value = -1 )and connecting your query to a report or a
form or subform . Same thing: use a form load as rthe triggering event for
the query and report.

Hope this is helpful

John S
Aylmer, PQ

PS. With the query, you'll probably have to fiddle with it in the SQLquery
view so that the ands and ors are paired together properly..

Sort of, but it is a database with customers, these
customers have events so the database should check if
there are actions to be taken. One of these actions is
that invoices or offerte's should be sent to the customer.
Me the user should be informed so thats why there must be
a timer to remind me. for the taken actions.
If a Event finish at 30-11-2003 I have to get a message
that says sent invoice for customer ..... and so on.

Could you help?

Sander.
Click to expand...


.
Click to expand...
 
Back
Top