Print Page | Close Window

DateStuff.mdb (intermediate)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=356
Printed Date: 28 Mar 2024 at 8:42am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: DateStuff.mdb (intermediate)
Posted By: Roger Carlson
Subject: DateStuff.mdb (intermediate)
Date Posted: 01 Aug 2008 at 5:26am

Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - 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):
http://www.rogersaccesslibrary.com/forum/uploads/5/DateStuff97.zip - DateStuff97.zip
Access 2000 ADO (108 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/DateStuff2k.zip - DateStuff2k.zip



-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net