event or reminder????

[angeliksam]

Hi all,
I have a table of clients who need to be visited on a certain time
basis. I
entered the date of the first visit and also the date when the next
visit
needs to be performed. However I'd like to have a pop-up window or
report generated eveytime that the next visit date becomes current.
Any help will be greatly appreciated...BTW, My access skills are
medium-low
level and I don not have access to M. Outlook.

 

[Steve Schapel]

Angeliksam,

One thing you are going to need to decide there is *when* you want this
check to be performed... When you click a button? Every day at
10:00am? Every time the database is opened?

I would make a Query that returns any clients where the next visit is
due. The SQL view of such a query might look something like this...
SELECT ClientName
FROM Clients
WHERE NextVisitDate Between Date() And Date()+7

Let's say you name that query VisitsDue. And let's say you also make a
form that is based on this query, and the form is also named VisitsDue.

Ok, then let's suppose there is a form that is always opened when the
database is started. On the Open event of this form, you could put code
something along these lines...
If DCount("*","VisitsDue") > 0 Then
If MsgBox("See clients due?", vbYesNo) = vbYes Then
DoCmd.OpenForm "VisitsDue"
End If
End If