Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do you change the start of the workweek?
And the rest: Select Case strFormat Case "MMDDYY" intYear = lngdate Mod 100 intMonth = lngdate \ 10000 intDay = (lngdate \ 100) Mod 100 Case "MMDDYYYY" intYear = lngdate Mod 10000 intMonth = lngdate \...- hitman74
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
How do you change the start of the workweek?
This is from the basDateTime module I'm trying to edit: Option Compare Database Option Explicit ' From "VBA Developer's Handbook" ' by Ken Getz and Mike Gilbert ' Copyright 1997; Sybex, Inc. All rights reserved. Private Declare Function GetProfileString Lib "kernel32" Alias...- hitman74
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
How do you change the start of the workweek?
I have a Visiting db at my prison. Visiting days are Fri., Sat., Sun., Mon. We are closed Tues., Wed., and Thurs.. The database is set up to reset the visiting lists on Mon., but our Visiting week runs Fri-Mon, and we need to keep a running list of visits through those four days. Then we...- hitman74
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
