Full Version: Fill in Dates - This Week - Past 1-2 Weeks - Week Ahead
UtterAccess Forums > Microsoft® Access > Access Forms
I have a grid on a form made up of separate textboxes
Oneed to select a starting date - then display the following dates
(see attached image)

Start Date 2/25/08 (i have this week filled in below)

2 weeks ago Mon Tues Wed Thur Fri Sat Sun

1 weeks ago Mon Tues Wed Thur Fri Sat Sun

This week Mon Tues Wed Thur Fri Sat Sun
2/25 2/26 2/27 2/28 2/29 2/30 etc

1 Wk Ahead Mon Tues Wed Thur Fri Sat Sun

How can i determine by the starting date where to put the other dates?
I need the date of the current week selected in the textbox under the appropriate day?
then calculate all the other dates thereafter

Any help is appreciated - AB
Edited by: ABinBoston on Mon Feb 25 16:31:13 EST 2008.
There are examples of calendar forms in the Access Code Archive forum that should help show you how to do this.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.