limit display of data on continuous form by date

  • Thread starter Thread starter Anne
  • Start date Start date
A

Anne

I am drawing a complete blank. I want to be able to limit the display of data
on a continuous form which is used for data entry by date.

I want to be able to display data by start date and end date, or start date
and no end date, just like one would for a report.
 
I am drawing a complete blank. I want to be able to limit the display of data
on a continuous form which is used for data entry by date.

I want to be able to display data by start date and end date, or start date
and no end date, just like one would for a report.
Click to expand...

Base the form on a Query with appropriate date criteria, e.g.

BETWEEN [forms].[yourformname].[txtStartDate] AND
[forms].[yourformname].[txtEndDate]

Be sure the textboxes are unbound (nothing in their Control Source).
 
Thank you. I got this to work.

What I also need is to be able to have a start date and no end date and to
be able to clear the dates and show all.

John W. Vinson said:
I am drawing a complete blank. I want to be able to limit the display of data
on a continuous form which is used for data entry by date.

I want to be able to display data by start date and end date, or start date
and no end date, just like one would for a report.
Click to expand...

Base the form on a Query with appropriate date criteria, e.g.

BETWEEN [forms].[yourformname].[txtStartDate] AND
[forms].[yourformname].[txtEndDate]

Be sure the textboxes are unbound (nothing in their Control Source).
Click to expand...
 
Thank you. I got this to work.

What I also need is to be able to have a start date and no end date and to
be able to clear the dates and show all.
Click to expand...

I should have posted the "long form": a criterion of
= NZ([forms].[yourformname].[txtStartDate], #1/1/100#) AND < DateAdd("d", 1, NZ( [forms].[yourformname].[txtEndDate], #12/30/9999#))
Click to expand...

will cover all eventualities, including returning records where there is a
time portion.
 
That was exactly what I needed. Thank you

John W. Vinson said:
Thank you. I got this to work.

What I also need is to be able to have a start date and no end date and to
be able to clear the dates and show all.
Click to expand...

I should have posted the "long form": a criterion of
= NZ([forms].[yourformname].[txtStartDate], #1/1/100#) AND < DateAdd("d", 1, NZ( [forms].[yourformname].[txtEndDate], #12/30/9999#))
Click to expand...

will cover all eventualities, including returning records where there is a
time portion.
Click to expand...
 
Back
Top