I have two tables which I need a 60 and 30 day reminder before experation. I am not familiar with code or how to write macros. Any help would be appreciated.
God Bless,
Thanks,
Just create a query with the following filter (create query and in SQL view, paste the following while changing names) - SELECT TableName.[ExpirationDateFieldName]
-
FROM TableName
-
WHERE ((([ExpirationDateFieldName]-Date())=30));
-
Then you base a form or report (call it reminder) on this query and run it on loading the database.
That was for the 30 days reminder, for the sixty days you use the same except for the number which becomes 60.
Of course, you can choose the user interface you want. For example, you can open the 30-days reminder first, and upon closing you open the 60 and so on.
Regards,
Ali
5 5858 Just create a query with the following filter (create query and in SQL view, paste the following while changing names) - SELECT TableName.[ExpirationDateFieldName]
-
FROM TableName
-
WHERE ((([ExpirationDateFieldName]-Date())=30));
-
Then you base a form or report (call it reminder) on this query and run it on loading the database.
That was for the 30 days reminder, for the sixty days you use the same except for the number which becomes 60.
Of course, you can choose the user interface you want. For example, you can open the 30-days reminder first, and upon closing you open the 60 and so on.
Regards,
Ali
Thank you for the help. I will plug it in and see how it works. Now that you explain it, it seems that is a simple solution... let's see if my feeble brain and process it right...
Thanks again.
Jason
I have tried inserting the code you gave me. I keep getting errors. Here is what I have in my query.
SELECT [banner sales].[date expires]
FROM [banner sales]
WHERE ([banner sales].[date expired]-Date()=30);
with this code when I run the query I get "Enter Parameter Value" for banner sales.date expired. when I put in a date of 10/01/2010 to test it I get the following error.
"This expression is typed incorrectly, or it is too complex to be evaluated...
Thanks for any help,
Jason
OK, I think I figured out my stupid mistake... thanks for all your help. I am sure to have further questions later.
God Bless,
Jason
:)
Happy it worked. Please mark this post as solved so it becomes more helpful for others. The great contributors and I will be waiting your questions.
Thanks, God(G) Bless you too & Regards,
Ali
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Nel |
last post by:
Hi PHPers
I want to write a system that will create and e-mail invoices to my
customers for web services I provide.
Everything from hosting, to domain reg and annual maintenance fees.
For...
|
by: JP SIngh |
last post by:
Is there a way to automatically execute code in ASP?
I need to send reminders for one my applications and need some suggestions
how I can send reminder emails automatically.
Many thanks
|
by: Yair Cohen |
last post by:
HI all,
any1 know an idea of makeing a good reminder system. i mean, it will store
on the DB. and it will jump when it should and u can postphone or decline
it. is there any known method to do...
|
by: hecsan07 |
last post by:
I want to write an App to schedule tasks. I need some ideas on how to send
reminders to users about their tasks. I should work pretty much like an
scheduler. Any ideas how I can accomplish this?
...
|
by: Wolf |
last post by:
Hi
I am using the outlook add in for vs.net 2005 and outlook 2003.
I am creating contacts in outlook from our system
The clients want to see only the birthdate's and dont want to be bugged...
|
by: Janey |
last post by:
Hi there,
I'm setting up a database to track ethical applications related to
research and I want to it remind me whenever any of the projects are
due for annual review. How can I best go about...
|
by: Kosmos |
last post by:
Howdy...I'm still a newbie although I've been working with Access for a couple of months now, it's only been on Fridays (but I've been trying to give back by helping out when I can). Anyways this may...
|
by: Saher |
last post by:
Thanks, for the help!
hey guys, thanks 4 the help. By the way my access still wont work, but its alright, because i dont need to use it immediately, and im getting a laptop, so it shud be fine. I...
|
by: HariKutty |
last post by:
Hello every one,
I am working in Asp.Net 2005 web Application.I am storing my employees Details in the Database that includes there Birthday dates,Emailid.So my task is automatically mail should...
|
by: THEAF |
last post by:
hi,
I'm trying to create a reminder. i have 2 forms one for to set the reminder and one to view all the reminders. these reminders are recorded on access. i can save the reminder and the other form...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |