I have a table that contains a field called RDATE (reminder date).
Dates are optionally entered to remind a user of an upcoming event. I
have a reminder button that launches a popup form, and a list of all
the reminder fields that actually contain dates and a corresponding
explanation, pops up.
This is handled by a query.
I created a backlight to the button that will light when a reminder
date is coming up. How do I check the table on application startup,
to see if a reminder date is coming up. This is a single main table,
that is ordered by a different field. Any ideas for the best
approach ?
Thanks
Greg 5 1579
"Greg (co*****@gmail.com)" <co*****@gmail.comwrote in
news:80e3962a-c4ee-4b92-b45c- 30**********@k37g2000hsf.googlegroups.co
m:
I have a table that contains a field called RDATE (reminder date).
Dates are optionally entered to remind a user of an upcoming
event. I have a reminder button that launches a popup form, and a
list of all the reminder fields that actually contain dates and a
corresponding explanation, pops up.
This is handled by a query.
I created a backlight to the button that will light when a
reminder date is coming up. How do I check the table on
application startup, to see if a reminder date is coming up. This
is a single main table, that is ordered by a different field. Any
ideas for the best approach ?
Thanks
Greg
You'll need to make a query that selects datediff("d",date(),rdate)
with criteria between 0 and 7 for a week or another number of days,
and test that with a dcount(), if there are 0 records, then no
reminders for the period. I'd put the dlookup() in the form's On
Open or On Load event.
--
Bob Quintal
PA is y I've altered my email address.
** Posted from http://www.teranews.com **
Thanks Bob
Would it be easier or as effective to use .Find or .Seek ?
I was just researching this.
Thanks Greg
On Aug 25, 6:12*pm, Bob Quintal <rquin...@sPAmpatico.cawrote:
"Greg (code...@gmail.com)" <code...@gmail.comwrote in
news:80e3962a-c4ee-4b92-b45c-
306a54f18...@k37g2000hsf.googlegroups.co
m:
I have a table that contains a field called RDATE (reminder date).
Dates are optionally entered to remind a user of an upcoming
event. I have a reminder button that launches a popup form, and a
list of all the reminder fields that actually contain dates and a
corresponding explanation, pops up.
This is handled by a query.
I created a backlight to the button that will light when a
reminder date is coming up. *How do I check the table on
application startup, to see if a reminder date is coming up. *This
is a single main table, that is ordered by a different field. Any
ideas for the best approach ?
Thanks
Greg
You'll need to make a query that selects datediff("d",date(),rdate)
with criteria between 0 and 7 for a week or another number of days,
and test that with a dcount(), if there are 0 records, then no
reminders for the period. I'd put the dlookup() in the form's On
Open or On Load event.
--
Bob Quintal
PA is y I've altered my email address.
** Posted fromhttp://www.teranews.com**- Hide quoted text -
- Show quoted text -
"Greg (co*****@gmail.com)" <co*****@gmail.comwrote in
news:a372edf8-4a22-4a3c-9935-4e9f3c193d18
@f36g2000hsa.googlegroups.com:
Thanks Bob
Would it be easier or as effective to use .Find or .Seek ?
I was just researching this.
Thanks Greg
To use the .find or .seek methods, you need to open a recordset
(again a filtered query). using the dCount against a stored query
once per session isn't going to impose a penalty of more that a few
milliseconds per session. Not worth the extra coding involved in the
recordset setup, imnsho.
Q
>
On Aug 25, 6:12*pm, Bob Quintal <rquin...@sPAmpatico.cawrote:
>"Greg (code...@gmail.com)" <code...@gmail.comwrote in news:80e3962a-c4ee-4b92-b45c- 306a54f18...@k37g2000hsf.googlegroups.co m:
I have a table that contains a field called RDATE (reminder
date).
Dates are optionally entered to remind a user of an upcoming
event. I have a reminder button that launches a popup form, and
a
list of all the reminder fields that actually contain dates and
a
corresponding explanation, pops up.
This is handled by a query.
I created a backlight to the button that will light when a
reminder date is coming up. *How do I check the table on
application startup, to see if a reminder date is coming up.
*This
is a single main table, that is ordered by a different field.
Any
ideas for the best approach ?
Thanks
Greg
You'll need to make a query that selects datediff("d",date
(),rdate)
>with criteria between 0 and 7 for a week or another number of
days,
>and test that with a dcount(), if there are 0 records, then no reminders for the period. I'd put the dlookup() in the form's On Open or On Load event.
-- Bob Quintal
PA is y I've altered my email address. ** Posted fromhttp://www.teranews.com**- Hide quoted text -
- Show quoted text -
--
Bob Quintal
PA is y I've altered my email address.
** Posted from http://www.teranews.com **
Thanks for the good advice.
Greg
'This worked for me.
DLookup("[MyField]", "MyTable", "(Not IsNull(REMINDDATE)) And
(REMINDDATE <= Date())") This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Gleep |
last post by:
Hey Guys,
I've got a table called Outcomes. With 3 columns and 15 rows
1st col 2nd col 3rdcol
outcome date price
There are 15 rows...
|
by: Greg |
last post by:
I have a page that searches a database by a repairman's name and by a
date range. It pulls info by the repairman's name but pulls all info in
the database regardless of the date. Below is the code...
|
by: Simon Harris |
last post by:
Hi All,
Ok - I'll confess from the start, this is more about application logic that
ASP, being an ASP programmer, I guessed you people might be able to help! :)
I have built a room bookings...
|
by: SoftComplete Development |
last post by:
AlphaTIX is a powerful, fast, scalable and easy to use Full Text
Indexing and Retrieval library that will completely satisfy your
application's indexing and retrieval needs.
AlphaTIX indexing...
|
by: Pete |
last post by:
Is there any way to change the default search to "Any Part Of Field"
instead of whole field? The first thing I ever do when searching for
something in a field is change the default setting from...
| |
by: justobservant |
last post by:
When more than one keyword is typed into a search-query, most of the
search-results displayed indicate specified keywords scattered
throughout an entire website of content i.e., this is shown as...
|
by: Grey |
last post by:
I have following problem:
table includes times for startup and end of operation as datetime field
related to daily shift operations:
dateid date starttime endtime
458 2006-12-29 22:00 ...
|
by: Salad |
last post by:
I have a situation where some, not all, users get the message "Couldn't
find file "F:\AccessApps\AppName.mdw". This file is required for startup".
My app the users are attempting to access is...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |