[AccessD] scheduling

Stuart McLachlan stuart at lexacorp.com.pg
Sat May 10 17:51:02 CDT 2003


On 10 May 2003 at 11:20, Susan Harkins wrote:

> I use Access to keep articles, etc. on schedule, keep up with
> invoicing, etc. and it works just fine. The one thing I don't really
> know how to handle is the following -- occasionally I want to note
> something that I may not need for months -- and I can do that -- just
> don't really know how to go about displaying it -- reminding myself to
> look -- know what I mean?
> 

A "tickler" table.  Something like 

fldFirstDate as DATE, fldFrequency as Long, fldReminder as MEMO

On startup, popup a continuous form with a recordsource of:

"Select * from tTickler where fldFirstDate <= Date() and (Date() - 
fldFirstDate) MOD fldFrequency = 0"

Then your messages will popup when you start your application on 
FldFirstday and every fldFrequency days afterwards until you delete 
the record.








-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.





More information about the AccessD mailing list