callback feature

[rotschreck]

Learning about VB in Access.<br>
<br>
Boss wants me to create a callback feature based on 30 days after dates in certain fields.<br>
<br>
I figure it would be made in VB, but I don't have any reference in the field. Where do I get info on this? What books would be worth my while? Websites?<br>
<br>
I have Office 97 Bible at this time.<br>
<br>
Any help would be appreciated. <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/siltharin>Maitredudonjon's</a><br>

 

[elizabeth]

Are you asking how to design a small app to do this or are you trying to enhance an existing form or report?

 

[rotschreck]

either or really. as long as the staff is reminded about certain dates. <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/siltharin>Rotschrck's

Eclectic Page</a><br>

 

[DougP]

If you want to know when 30 days are from a date<br>
use this<br>
'DateGiven is the date in your table or whatever that you are checking against<br>
CallBackDate = Format(DateSerial(Year(DateGiven), Month(DateGiven), Day(DateGiven) + 30), &quot;mm/dd/yy&quot<br>
If CallBackDate = Format(Now, &quot;mm/dd/yy&quot Then<br>
'Call back this ....<br>
End If<br>
<br>
This may help<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[elizabeth]

Check out the sample &quot;Contact Management&quot; Database that comes as a sample app. In Access 2000 you get there by choosing File, New, Databases (tab).