Creating Reminders

[Jason Ponzio]

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,

[liimra]

Solution/

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

[Jason Ponzio]

Thanks

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

[Jason Ponzio]

I must be a dummy

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

[Jason Ponzio]

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

[liimra]

Welcome

:)
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