Help with possible macro

M

Mike Busch

OK this may be reaching, but I have a database that I record the date that I
have reported a problem to whom ever. I would like apon startup a dialog box
for that record showing that I have not entered a responce to this problem 30
days after I have recorded the problem. Is this possible. It's OK to dream!!!
 
D

Douglas J. Steele

Create a query that determines all the open problems that are over 30 days
old. To determine if they're over 30 days old, you're looking for CreateDt
<= DateAdd("d", -30, Date())

Base a form on that query.

Set that form to be the Startup form (Tools | Startup)
 
M

Mike Busch

This would work, is there any way to have this come up only when the Solution
date is Null. Thanks. This way if I report a problem, and in 30 days I havn't
heard back, I would like to know. when I get a answer I would fill in the
Solution Date right away.
 
Top