open a form at today's date or next date if no match for today

[Rod Isaacs, St George Hospital]

G'day all you Access wallopers,

can anyone tell me how I can open a form (that displays non-contiguous
records containing a date field) at either the first record containing
today's date, or the nearest date after today's date if there is no record
containing today's date. It has me stumped, but that isn't saying much.

The application is an clinic appointment scheduler for a Disability Clinic
in Sydney, Australia, and we want to jump to today's clinics when the form
is opened, or the next day that clinics are available if there are none
today. There may be more than one record for each day (for different
clinics).

I hope this is clear ... ish.

Thanks in advance,

Rod.

 

[Mike Painter]

G'day all you Access wallopers,

can anyone tell me how I can open a form (that displays non-contiguous
records containing a date field) at either the first record containing
today's date, or the nearest date after today's date if there is no record
containing today's date. It has me stumped, but that isn't saying much.

The application is an clinic appointment scheduler for a Disability Clinic
in Sydney, Australia, and we want to jump to today's clinics when the form
is opened, or the next day that clinics are available if there are none
today. There may be more than one record for each day (for different
clinics).

One way would be to base the form on a query that just showed dates greater
than or equal to Date().
If going back is an occasional thing then you could put a button to select a
previous date or range of dates and change the record source.

You could also use the opening of the form to find that "first" record and
move to it.
This is probably a better way.
If you use it place the same routine in a button marked "Today" so they can
get back to the start if needed.