Prompt for entry after 3 months

O

owl37

Hi all,
I need to have a prompt come up in my database for a new entry.
I need it pop up after three months of the person's leave date.
Any ideas?

Thanks.
 
K

KARL DEWEY

In your macro named Autoexec have it open a query. Set a condition in the
second action line to check if any records were returned when the query was
opened. If no records close the query.
The query will have an add column like --
X:[Leave Date]+90
Set criteria as --
<=Date()
This uses 90 days after leave date or you can use 3 months like --
X:DateAdd("m",3,[Leave Date])
 
O

owl37

Hi Karl,
Thanks for your reply.
How would I write the condition?
Also, the propmt I need is to ask the user to enter data in another field
i.e. where are they now.
Does this change what I need to do at all.
Thanks for you help, much appreciated.



KARL DEWEY said:
In your macro named Autoexec have it open a query. Set a condition in the
second action line to check if any records were returned when the query was
opened. If no records close the query.
The query will have an add column like --
X:[Leave Date]+90
Set criteria as --
<=Date()
This uses 90 days after leave date or you can use 3 months like --
X:DateAdd("m",3,[Leave Date])

owl37 said:
Hi all,
I need to have a prompt come up in my database for a new entry.
I need it pop up after three months of the person's leave date.
Any ideas?

Thanks.
 
Top