How do I set up a tickler or alert mechanism in Access?

C

Cruzgirl45

I have a project the requires an alert for upcoming dates. Does Access have
any thing other than a query that will do a tickler?
 
T

Tony Toews [MVP]

Cruzgirl45 said:
I have a project the requires an alert for upcoming dates. Does Access have
any thing other than a query that will do a tickler?
Click to expand...

When a user opens the database I run the query first and see if it has
any records. If it does have records I then display a form based on
the query. I never give the user a query to look at as I feel a form
looks much nicer and gives the ability to add other things such as
View buttons to look at details, etc, etc.

And, of course, the user can open this form any time from the menu.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Tickler file on Outlook 2
Batch Add Records with certain criteria 0
Appending records based on a query and user data from a form 0
how to set up a tickler file? 2
"Tickler" File 4
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
need appointment tickler for several kinds of appts 0
Outlook 2007 Desktop Alert 0

Top