PC Review


Reply
Thread Tools Rate Thread

90 day customer reminders

 
 
=?Utf-8?B?Sm8=?=
Guest
Posts: n/a
 
      29th May 2004
I am attepting to set up a new database. I would like to know how to set up a reminder that 90 days ago I was out on a service call to a certain customers home, and its time to get in contact with them again
How do I do that

 
Reply With Quote
 
 
 
 
=?Utf-8?B?bG9zbWFj?=
Guest
Posts: n/a
 
      29th May 2004
In autoexec macro or Form_Load procedure you need to test today and some date, for ex

dim dToday as Date, dSomeDate as Dat

dSomeDate = CDate("05/05/2004"
dToday = Dat

If CLng(dToday) - CLng(dSomeDate) >90 the
'..
' here - place your reminde
'..
End I


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
customer Name against Unique customer number count Nelson Microsoft Excel Worksheet Functions 3 13th Jul 2009 09:55 PM
Enter customer #, auto fill customer info? =?Utf-8?B?VGVnYW4=?= Microsoft Access Getting Started 1 15th Feb 2007 10:18 PM
CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET =?Utf-8?B?YnJ1bm9k?= Microsoft Excel Misc 1 7th Jul 2006 07:01 PM
How To Make A Customer List With Extra Entries Per Customer Minitman Microsoft Excel Programming 5 31st Oct 2005 07:43 PM
Distribution list emailed to a customer appears empty to the customer c02homer@hotmail.com Microsoft Outlook 1 19th May 2005 11:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:39 PM.