Diary/Schedular

  • Thread starter Thread starter NHiorns
  • Start date Start date
N

NHiorns

I have a customer database, which is used as a means of
tracking phone and mail (both e-mail and traditional post)
dialog.

This is done using various tick boxes, date and memo
fields. My next step is to make it a bit
more 'interactive', as one of the date fields records the
next contact date. As we have upto 10,000 records it is
differcult to keep tract of these dates.

I would like a seperate form which only shows todays
contact information, ideally would also like to show the
next couple of days as well.

I can create the form showing customer details, but need
help with the code to tie the main operational form up
with 'schedule' form.
 
Create a query based on your table, and in the criteria of
the "Next Contact Date" field type in "Now() OR Now()+1 OR
Now()+2" for today, tomorrow and the next days data.
Base your new form on this query.

Hope this helps.

Paul
 
Back
Top