Create a query. To get only those rows which are within, say, 3 days of
today, put the following as the criteria for the date field (assuming you're
doing this in the graphical query builder, this means put the following on
the Criteria line underneath the computed date Marsh gave you):
BETWEEN DateAdd("d", -3, Date()) AND Date()
If you've got a Yes/No Completed status flag in the table, put False as the
criteria under that field. (Make sure you put it on the same Criteria line
as the date criteria above. Criteria on the same line are ANDed together:
criteria on different lines are ORed together)
Save that query.
Create a form that shows the data, using the query you just created as its
RecordSource.
If you want that form to open up every time you open the database, select
Tools | Startup from the menu bar, and select the form you just created in
the "Display Form" section of the dialog.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
Jay said:
Thanks,...Douglas:
That sounds like what I need, can you provide a bit more details or an
example?
Thanks...
Douglas J. Steele said:
I'm not sure what you mean by "send this message".
It would be easy to create a query that returns all rows that are within
n
days of a particular date. That query can also be made to ignore those
records that have a flag on them indicating that they're complete.
You can create a form that uses the query above as its recordsource, and
you
can have that form automatically launch when you open the database.
Is that what you need?
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
Thank Guys:
That really worked fine! Now, I have another question for you. It's
this,
"Is there a way to do a search against that second date
(dte_InitContact =
control name or dte_InitContact) column of data and flag (looking at
system
date) and send a Pop-Up message about one to two days prior to the date
in
the record as a reminder (tickle date) of a action or task that needs
attention? And send this message untill that date/day has expired,
maybe
with
a check box or something on a form to verify that the task has been
completed
and cancel that Pop-Up for that date/rocord only and repeat the same
for
all
records? Kind of like one set Outlook to remind one appointments or
tasks
that need to be done?
Outlook which is database does it, so, Access should also allow for
that
function, correct? Maybe, I'm barking up the wrong tree all together on
this
one!
Thanks guys, in advance!!!!!
:
Jay wrote:
Hi guru's:
I need to calculate the half a year or a 6 months out mark based on
date
in
another control, the sample below is how I've gotten it working, kind
of! Is
there a better way to do this using the DateAdd function?
Me![dte_PossPurchaseDte] = Me!dte_InitContact + 182.5
Me![dte_PossPurchaseDte] = _
DateAdd("m", 6, Me!dte_InitContact)
