Dates on Forms

[Nigel]

I have inherited a database of IT faults. There is a table listing the
faults, type of fault and date, plus other fields. From this a parameter
query has been built using a between statement on the date field to get say,
November's faults. From this qry another qry has been built and using the
totals button, totals the faults by type. This in turn generates a chart on a
form, which is in turn put onto a main form. When the main form is run it
asks for the dates, as expected, but how can I get the dates printed on the
form?

Grateful for any help and guidance on this as I suspect it's been over
complicated.

Thanks

 

[Steve Schapel]

Nigel,

I dislike parameter queries at the best of times. And especially when
dates are prompted for. Instead, I prefer to put a couple of unbound
textboxes on a form which will be open while the other functionality is
being processed, where the required date range is entered. And then, in
the Criteria of the query, you can reference these textboxes, using
syntax such as:
Between [Forms]![NameOfForm]![DateFrom] And [Forms]![NameOfForm]![DateTo]

Similarly, you can then refer to these form controls, using similar
syntax, in the Control source of another textbox, on your output form or
report.

 

[Nigel]

Steve

Many thanks, I'll give it a go!

Nigel,

I dislike parameter queries at the best of times. And especially when
dates are prompted for. Instead, I prefer to put a couple of unbound
textboxes on a form which will be open while the other functionality is
being processed, where the required date range is entered. And then, in
the Criteria of the query, you can reference these textboxes, using
syntax such as:
Between [Forms]![NameOfForm]![DateFrom] And [Forms]![NameOfForm]![DateTo]

Similarly, you can then refer to these form controls, using similar
syntax, in the Control source of another textbox, on your output form or
report.

--
Steve Schapel, Microsoft Access MVP

I have inherited a database of IT faults. There is a table listing the
faults, type of fault and date, plus other fields. From this a parameter
query has been built using a between statement on the date field to get say,
November's faults. From this qry another qry has been built and using the
totals button, totals the faults by type. This in turn generates a chart on a
form, which is in turn put onto a main form. When the main form is run it
asks for the dates, as expected, but how can I get the dates printed on the
form?

Grateful for any help and guidance on this as I suspect it's been over
complicated.

Thanks