#Name? in paramter text box

  • Thread starter KHogwood-Thompson
  • Start date
K

KHogwood-Thompson

Hi,

I have a report based on a query that has a form as a parameter. When the
report opens it correctly requests the parameter, however the text box
displaying the parameter on the report displays as #Name?

The query has the fiollowing code for the TRANSDATE parameter:

Between [Forms]![Labour Analysis Parameter]![StartDate] And [Forms]![Labour
Analysis Parameter]![EndDate]

In the report header the code for the textbox is:

=[Forms]![Labour Analysis Parameter]![StartDate]
& second text box
=[Forms]![Labour Analysis Parameter]![EndDate]

Both display as #Name?

Is there something very basic that I am doing wrong, I suspect that there is.
 
J

John Spencer

If the references are exactly the same and are in the control source of the
textbox, then I would examine the names of the textbox controls on the
report. Try changing the names of the textbox controls to something
non-descript like txtMyStart and txtMyEnd.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
K

KHogwood-Thompson

I have tried what you have suggested and the #Name? is still appearing.
--
K Hogwood-Thompson


John Spencer said:
If the references are exactly the same and are in the control source of the
textbox, then I would examine the names of the textbox controls on the
report. Try changing the names of the textbox controls to something
non-descript like txtMyStart and txtMyEnd.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

KHogwood-Thompson said:
Hi,

I have a report based on a query that has a form as a parameter. When the
report opens it correctly requests the parameter, however the text box
displaying the parameter on the report displays as #Name?

The query has the fiollowing code for the TRANSDATE parameter:

Between [Forms]![Labour Analysis Parameter]![StartDate] And
[Forms]![Labour
Analysis Parameter]![EndDate]

In the report header the code for the textbox is:

=[Forms]![Labour Analysis Parameter]![StartDate]
& second text box
=[Forms]![Labour Analysis Parameter]![EndDate]

Both display as #Name?

Is there something very basic that I am doing wrong, I suspect that there
is.
 
D

Duane Hookom

Are you using code anywhere that closes the form?

--
Duane Hookom
Microsoft Access MVP


KHogwood-Thompson said:
I have tried what you have suggested and the #Name? is still appearing.
--
K Hogwood-Thompson


John Spencer said:
If the references are exactly the same and are in the control source of the
textbox, then I would examine the names of the textbox controls on the
report. Try changing the names of the textbox controls to something
non-descript like txtMyStart and txtMyEnd.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

KHogwood-Thompson said:
Hi,

I have a report based on a query that has a form as a parameter. When the
report opens it correctly requests the parameter, however the text box
displaying the parameter on the report displays as #Name?

The query has the fiollowing code for the TRANSDATE parameter:

Between [Forms]![Labour Analysis Parameter]![StartDate] And
[Forms]![Labour
Analysis Parameter]![EndDate]

In the report header the code for the textbox is:

=[Forms]![Labour Analysis Parameter]![StartDate]
& second text box
=[Forms]![Labour Analysis Parameter]![EndDate]

Both display as #Name?

Is there something very basic that I am doing wrong, I suspect that there
is.
 
K

KHogwood-Thompson

The form itself does not open when the report is opened

That is obviously the problem isn't it?

There is no code on the form.
--
K Hogwood-Thompson


Duane Hookom said:
Are you using code anywhere that closes the form?

--
Duane Hookom
Microsoft Access MVP


KHogwood-Thompson said:
I have tried what you have suggested and the #Name? is still appearing.
--
K Hogwood-Thompson


John Spencer said:
If the references are exactly the same and are in the control source of the
textbox, then I would examine the names of the textbox controls on the
report. Try changing the names of the textbox controls to something
non-descript like txtMyStart and txtMyEnd.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message Hi,

I have a report based on a query that has a form as a parameter. When the
report opens it correctly requests the parameter, however the text box
displaying the parameter on the report displays as #Name?

The query has the fiollowing code for the TRANSDATE parameter:

Between [Forms]![Labour Analysis Parameter]![StartDate] And
[Forms]![Labour
Analysis Parameter]![EndDate]

In the report header the code for the textbox is:

=[Forms]![Labour Analysis Parameter]![StartDate]
& second text box
=[Forms]![Labour Analysis Parameter]![EndDate]

Both display as #Name?

Is there something very basic that I am doing wrong, I suspect that there
is.
 
D

Duane Hookom

The form needs to be open.

--
Duane Hookom
Microsoft Access MVP


KHogwood-Thompson said:
The form itself does not open when the report is opened

That is obviously the problem isn't it?

There is no code on the form.
--
K Hogwood-Thompson


Duane Hookom said:
Are you using code anywhere that closes the form?

--
Duane Hookom
Microsoft Access MVP


KHogwood-Thompson said:
I have tried what you have suggested and the #Name? is still appearing.
--
K Hogwood-Thompson


:

If the references are exactly the same and are in the control source of the
textbox, then I would examine the names of the textbox controls on the
report. Try changing the names of the textbox controls to something
non-descript like txtMyStart and txtMyEnd.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message Hi,

I have a report based on a query that has a form as a parameter. When the
report opens it correctly requests the parameter, however the text box
displaying the parameter on the report displays as #Name?

The query has the fiollowing code for the TRANSDATE parameter:

Between [Forms]![Labour Analysis Parameter]![StartDate] And
[Forms]![Labour
Analysis Parameter]![EndDate]

In the report header the code for the textbox is:

=[Forms]![Labour Analysis Parameter]![StartDate]
& second text box
=[Forms]![Labour Analysis Parameter]![EndDate]

Both display as #Name?

Is there something very basic that I am doing wrong, I suspect that there
is.
 
I

ihan us

Hi....
I have the same problem, in the report I have a text box contains "=UCase(Format([TGLSN],"dd mmmm yyyy"))"

and I have rename the textbox name into txtTGLSN, when I generated the report It is still appear #name?

does anyone have a solution ?
Thanks.


Ihan
Hi,

I have a report based on a query that has a form as a parameter. When the
report opens it correctly requests the parameter, however the text box
displaying the parameter on the report displays as #Name?

The query has the fiollowing code for the TRANSDATE parameter:

Between [Forms]![Labour Analysis Parameter]![StartDate] And [Forms]![Labour
Analysis Parameter]![EndDate]

In the report header the code for the textbox is:

=[Forms]![Labour Analysis Parameter]![StartDate]
& second text box
=[Forms]![Labour Analysis Parameter]![EndDate]

Both display as #Name?

Is there something very basic that I am doing wrong, I suspect that there is.

--
K Hogwood-Thompson
On Monday, October 08, 2007 7:51 AM John Spencer wrote:
If the references are exactly the same and are in the control source of the
textbox, then I would examine the names of the textbox controls on the
report. Try changing the names of the textbox controls to something
non-descript like txtMyStart and txtMyEnd.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

message news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top