Date displayed in Report

  • Thread starter Thread starter galin
  • Start date Start date
G

galin

Hi group,

I have a form that runs report based on Starting Date and
Ending Date. I want the Starting Date and Ending Date to
be displayed in the report so a user will know the days
he/she specified when executing the form. I was thinking
of inserting Start/End Date in the header. How do I do
that?
 
Hi group,

I have a form that runs report based on Starting Date and
Ending Date. I want the Starting Date and Ending Date to
be displayed in the report so a user will know the days
he/she specified when executing the form. I was thinking
of inserting Start/End Date in the header. How do I do
that?
Click to expand...

Add an unbound control to the report header.
Set it's control source to:
="For sales between " & [Starting Date] & " and " [Ending Date]

The text within the brackets must be identical to the bracketed text
in the query.
 
Hi Fred,

This is what I do

="For Dates between " & Form![Execute]![txtStart] & "and"
Form![Execute]![txtEnd]

and all I get is For Dates between

What am I doing wrong?
-----Original Message-----
Hi group,

I have a form that runs report based on Starting Date and
Ending Date. I want the Starting Date and Ending Date to
be displayed in the report so a user will know the days
he/she specified when executing the form. I was thinking
of inserting Start/End Date in the header. How do I do
that?
Click to expand...

Add an unbound control to the report header.
Set it's control source to:
="For sales between " & [Starting Date] & " and " [Ending Date]

The text within the brackets must be identical to the bracketed text
in the query.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Hi Fred,

This is what I do

="For Dates between " & Form![Execute]![txtStart] & "and"
Form![Execute]![txtEnd]

and all I get is For Dates between

What am I doing wrong?
-----Original Message-----
Hi group,

I have a form that runs report based on Starting Date and
Ending Date. I want the Starting Date and Ending Date to
be displayed in the report so a user will know the days
he/she specified when executing the form. I was thinking
of inserting Start/End Date in the header. How do I do
that?
Click to expand...

Add an unbound control to the report header.
Set it's control source to:
="For sales between " & [Starting Date] & " and " [Ending Date]

The text within the brackets must be identical to the bracketed text
in the query.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Click to expand...

1) Your syntax is not correct.
You are using Form! (singular)
Form!FormName!ControlName
it should be Forms! (plural)
Forms!FormName!ControlName

2) The form must be open when the report is run.

The customary way to run a report using a form for parameter entry is
to open the Form from the Report's Open event:
DoCmd.OpenForm "FormName", , , , , acDialog

Code the command button on the form to make the form not visible:
Me.Visible = False

Code the Report's Close event to close the form:
DoCmd.Close acForm, "FormName"

This way, when you open the report, the report opens the form for
parameter entry and then the form is hidden while the report displays.
When you close the report, it closes the form.
 
Thanks Fred, I got it. It wasn't the syntax error(brcause
I was typing that,otherwise I double-click on the
controls). I had omitted few things, but everything is in
order now.


-----Original Message-----
Hi Fred,

This is what I do

="For Dates between " & Form![Execute]![txtStart] & "and"
Form![Execute]![txtEnd]

and all I get is For Dates between

What am I doing wrong?
-----Original Message-----
On Thu, 27 May 2004 08:23:45 -0700, galin wrote:

Hi group,

I have a form that runs report based on Starting Date and
Ending Date. I want the Starting Date and Ending Date to
be displayed in the report so a user will know the days
he/she specified when executing the form. I was thinking
of inserting Start/End Date in the header. How do I do
that?

Add an unbound control to the report header.
Set it's control source to:
="For sales between " & [Starting Date] & " and "
Click to expand...
[Ending
Date]
The text within the brackets must be identical to the bracketed text
in the query.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Click to expand...

1) Your syntax is not correct.
You are using Form! (singular)
Form!FormName!ControlName
it should be Forms! (plural)
Forms!FormName!ControlName

2) The form must be open when the report is run.

The customary way to run a report using a form for parameter entry is
to open the Form from the Report's Open event:
DoCmd.OpenForm "FormName", , , , , acDialog

Code the command button on the form to make the form not visible:
Me.Visible = False

Code the Report's Close event to close the form:
DoCmd.Close acForm, "FormName"

This way, when you open the report, the report opens the form for
parameter entry and then the form is hidden while the report displays.
When you close the report, it closes the form.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top