473,320 Members | 1,945 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Find or Search for a date on startup.

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
Aug 25 '08 #1
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 **
Aug 25 '08 #2
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 -
Aug 25 '08 #3
"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 **
Aug 26 '08 #4
Thanks for the good advice.

Greg
Aug 26 '08 #5
'This worked for me.

DLookup("[MyField]", "MyTable", "(Not IsNull(REMINDDATE)) And
(REMINDDATE <= Date())")
Aug 26 '08 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
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...
5
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...
9
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...
0
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...
11
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...
5
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...
8
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 ...
4
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...
0
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...
0
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
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...
0
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...
0
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...
1
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)...
0
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...
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.