Access Form-Date?

[RedDucati748]

I've created a form with two text boxes. One is for start date, the other is for the end date. The Text boxes are attached respectively to fields that currently hold start and end dates for the each week from now until 2004. As the cursor arrow at the bottom of the form is pushed it goes onto the next record and the next sequential week. As the year goes on I would like to avoid tabbing through the record cursor to the current week. My question is as follows: Can code be added to Access forms to allow the record to be pulled as the form is opened based off of the current date. I know it's possible in VB6, as I’ve used it in a time reporting database for work. If further information is needed please post questions and I’ll reply ASAP.
Thank you-

 

[jgoodman00]

Will it always be opened on an exact date specified in the database, or do you want it to open to the 'nearest' week?? James Goodman

http://www.james-goodman.co.uk

 

[RedDucati748]

I would like this forms date span closets to the current date to be present when the form is opened.
Thank you-

 

[jgoodman00]

I have just tested this, & you can do what I think you are trying to achieve by creating a query, which will act as the recordsource for the form...

SQL:
SELECT Sheet1.StartDate, Sheet1.EndDate, Sheet1.ID
FROM Sheet1
WHERE (((Sheet1.StartDate)<Date()) AND ((Sheet1.EndDate)>Date()));


I tried this & with a form with its recordsource set to the above SQL statement, only opened the record where the current date lies between [StartDate] & [EndDate]...

James Goodman

http://www.james-goodman.co.uk