Roger's Access Library Homepage
Forum Home Forum Home > Roger's Access Library > Roger's Download Samples
  New Posts New Posts RSS Feed - DateStuff.mdb (intermediate)
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

DateStuff.mdb (intermediate)

 Post Reply Post Reply
Author
Message Reverse Sort Order
Roger Carlson View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 20 Feb 2008
Status: Offline
Points: 249
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roger Carlson Quote  Post ReplyReply Direct Link To This Post Topic: DateStuff.mdb (intermediate)
    Posted: 01 Aug 2008 at 5:26am

Please consider donating $1 per sample downloaded, find out why here.

DateStuff.mdb

This example illustrates how to do a variety of date calculations like: First day of Month, Last Day of Month, First Day of Next Month, First Day of Current Week, Last Day of Current Week, First Day of Current Work Week, Last Day of Current Work Week.

There are two forms:

"Dates in Control Source of Control Object" shows how to put these functions directly in the Control Source of a form control.

"Dates in Functions Called by Control Object" shows how to put these in a separate function and call it from the form control.
 
Download
Access 97 (67 KB):
DateStuff97.zip
Access 2000 ADO (108 KB): DateStuff2k.zip

Consider donating $1 per sample downloaded, find out why here.<
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down