Date value needed for Access report

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

I have an Access 2003 report that needs to request a date value from
the user whenever it is opened. This date value does not have to be
saved in the database, but it does need to display in the report.

Any help would be greatly appreciated. Thanks.
 
What do you plan on doing with the date value? You can add a text box to
your report with a control source like:
=[Enter a date value]
 
Thanks Duane - I tried this and I keep getting #Error on the report.
There must be something simple I'm missing?

The only thing I need to do with the date value is display it on the
report (no calculations are done with this date value). Thanks for your
help.

Regards
Phil Horwood

Duane said:
What do you plan on doing with the date value? You can add a text box to
your report with a control source like:
=[Enter a date value]

--
Duane Hookom
MS Access MVP
--

Phil said:
I have an Access 2003 report that needs to request a date value from
the user whenever it is opened. This date value does not have to be
saved in the database, but it does need to display in the report.

Any help would be greatly appreciated. Thanks.
Click to expand...
Click to expand...
 
Does your report have a record source that returns any records?

--
Duane Hookom
MS Access MVP
--

Phil said:
Thanks Duane - I tried this and I keep getting #Error on the report.
There must be something simple I'm missing?

The only thing I need to do with the date value is display it on the
report (no calculations are done with this date value). Thanks for your
help.

Regards
Phil Horwood

Duane said:
What do you plan on doing with the date value? You can add a text box to
your report with a control source like:
=[Enter a date value]

--
Duane Hookom
MS Access MVP
--

Phil said:
I have an Access 2003 report that needs to request a date value from
the user whenever it is opened. This date value does not have to be
saved in the database, but it does need to display in the report.

Any help would be greatly appreciated. Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Yes, the report's Record Source is a query.

Duane said:
Does your report have a record source that returns any records?

--
Duane Hookom
MS Access MVP
--

Phil said:
Thanks Duane - I tried this and I keep getting #Error on the report.
There must be something simple I'm missing?

The only thing I need to do with the date value is display it on the
report (no calculations are done with this date value). Thanks for your
help.

Regards
Phil Horwood

Duane said:
What do you plan on doing with the date value? You can add a text box to
your report with a control source like:
=[Enter a date value]

--
Duane Hookom
MS Access MVP
--

I have an Access 2003 report that needs to request a date value from
the user whenever it is opened. This date value does not have to be
saved in the database, but it does need to display in the report.

Any help would be greatly appreciated. Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Did you make sure the Name of the text box is not also the name of a field
or parameter?

--
Duane Hookom
MS Access MVP
--

Phil said:
Yes, the report's Record Source is a query.

Duane said:
Does your report have a record source that returns any records?

--
Duane Hookom
MS Access MVP
--

Phil said:
Thanks Duane - I tried this and I keep getting #Error on the report.
There must be something simple I'm missing?

The only thing I need to do with the date value is display it on the
report (no calculations are done with this date value). Thanks for your
help.

Regards
Phil Horwood

Duane Hookom wrote:
What do you plan on doing with the date value? You can add a text box
to
your report with a control source like:
=[Enter a date value]

--
Duane Hookom
MS Access MVP
--

I have an Access 2003 report that needs to request a date value from
the user whenever it is opened. This date value does not have to be
saved in the database, but it does need to display in the report.

Any help would be greatly appreciated. Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top