Changing Fields in Report

I had created a new form in design view. I clicked the textbox in the toolbar
then clicked a spot on in the details area in the form.

That gave me 2 boxes. 1 I assume was a label (where the Text0: is) and the
2nd was the actual textbox. Inside the textbox I typed "txtEndDate." And I
saved the form as "frmDate."

Everything worked as it was supposed to in regards to my query. However if I
veiw the form "frmDate" in Form View, I see "#Name?" in the textbox.


"Duane Hookom" wrote:

My posting had stated :
My solution should work assuming you have a form "frmDate"
with a text box "txtEndDate"
Can you just tell me if this is the case? I have said nothing about a label
on the form. Also, I'm not sure how a form in form view shows "text0:
#Name".


--
Duane Hookom
MS Access MVP

You stated:
Inside the textbox I typed "txtEndDate."
You just set the control source to txtEndDate rather than the name of the
text box. Open the properties dialog of the text box, clear the control
source property and place txtEndDate in the Name property.

--
Duane Hookom
MS Access MVP



"MNY Intern" wrote in message
...
I had created a new form in design view. I clicked the textbox in the
toolbar
then clicked a spot on in the details area in the form.

That gave me 2 boxes. 1 I assume was a label (where the Text0: is) and the
2nd was the actual textbox. Inside the textbox I typed "txtEndDate." And I
saved the form as "frmDate."

Everything worked as it was supposed to in regards to my query. However if
I
veiw the form "frmDate" in Form View, I see "#Name?" in the textbox.


"Duane Hookom" wrote:

My posting had stated :
My solution should work assuming you have a form "frmDate"
with a text box "txtEndDate"
Can you just tell me if this is the case? I have said nothing about a
label
on the form. Also, I'm not sure how a form in form view shows "text0:
#Name".


--
Duane Hookom
MS Access MVP

Ok, I cleared the control source completely and put "txtEndDate" in the Name
property, and the "#Name?" doesnt show up anymore in Form view, but it still
comes up in my report.

"Duane Hookom" wrote:

You stated:
Inside the textbox I typed "txtEndDate."
You just set the control source to txtEndDate rather than the name of the
text box. Open the properties dialog of the text box, clear the control
source property and place txtEndDate in the Name property.

--
Duane Hookom
MS Access MVP



"MNY Intern" wrote in message
...
I had created a new form in design view. I clicked the textbox in the
toolbar
then clicked a spot on in the details area in the form.

That gave me 2 boxes. 1 I assume was a label (where the Text0: is) and the
2nd was the actual textbox. Inside the textbox I typed "txtEndDate." And I
saved the form as "frmDate."

Everything worked as it was supposed to in regards to my query. However if
I
veiw the form "frmDate" in Form View, I see "#Name?" in the textbox.


"Duane Hookom" wrote:

My posting had stated :
My solution should work assuming you have a form "frmDate"
with a text box "txtEndDate"
Can you just tell me if this is the case? I have said nothing about a
label
on the form. Also, I'm not sure how a form in form view shows "text0:
#Name".


--
Duane Hookom
MS Access MVP

What's in your report that shows #Name? I need to understand the control
sources etc.

--
Duane Hookom
MS Access MVP

"MNY Intern" wrote in message
...
Ok, I cleared the control source completely and put "txtEndDate" in the
Name
property, and the "#Name?" doesnt show up anymore in Form view, but it
still
comes up in my report.

"Duane Hookom" wrote:

You stated:
Inside the textbox I typed "txtEndDate."
You just set the control source to txtEndDate rather than the name of the
text box. Open the properties dialog of the text box, clear the control
source property and place txtEndDate in the Name property.

--
Duane Hookom
MS Access MVP



"MNY Intern" wrote in message
...
I had created a new form in design view. I clicked the textbox in the
toolbar
then clicked a spot on in the details area in the form.

That gave me 2 boxes. 1 I assume was a label (where the Text0: is) and
the
2nd was the actual textbox. Inside the textbox I typed "txtEndDate."
And I
saved the form as "frmDate."

Everything worked as it was supposed to in regards to my query. However
if
I
veiw the form "frmDate" in Form View, I see "#Name?" in the textbox.


"Duane Hookom" wrote:

My posting had stated :
My solution should work assuming you have a form "frmDate"
with a text box "txtEndDate"
Can you just tell me if this is the case? I have said nothing about a
label
on the form. Also, I'm not sure how a form in form view shows "text0:
#Name".


--
Duane Hookom
MS Access MVP

=DateAdd("ww",0,Forms!frmDate![txtEndDate])
=DateAdd("ww",-1,Forms!frmDate![txtEndDate])
=DateAdd("ww",-2,Forms!frmDate![txtEndDate])
=DateAdd("ww",-3,Forms!frmDate![txtEndDate])

Those are the control sources... they're named Wk0, Wk1, Wk2, and Wk3.
And when I run the report they come up as "#Name?"

"Duane Hookom" wrote:

What's in your report that shows #Name? I need to understand the control
sources etc.

--
Duane Hookom
MS Access MVP

"MNY Intern" wrote in message
...
Ok, I cleared the control source completely and put "txtEndDate" in the
Name
property, and the "#Name?" doesnt show up anymore in Form view, but it
still
comes up in my report.

"Duane Hookom" wrote:

You stated:
Inside the textbox I typed "txtEndDate."
You just set the control source to txtEndDate rather than the name of the
text box. Open the properties dialog of the text box, clear the control
source property and place txtEndDate in the Name property.

--
Duane Hookom
MS Access MVP



"MNY Intern" wrote in message
...
I had created a new form in design view. I clicked the textbox in the
toolbar
then clicked a spot on in the details area in the form.

That gave me 2 boxes. 1 I assume was a label (where the Text0: is) and
the
2nd was the actual textbox. Inside the textbox I typed "txtEndDate."
And I
saved the form as "frmDate."

Everything worked as it was supposed to in regards to my query. However
if
I
veiw the form "frmDate" in Form View, I see "#Name?" in the textbox.


"Duane Hookom" wrote:

My posting had stated :
My solution should work assuming you have a form "frmDate"
with a text box "txtEndDate"
Can you just tell me if this is the case? I have said nothing about a
label
on the form. Also, I'm not sure how a form in form view shows "text0:
#Name".


--
Duane Hookom
MS Access MVP

Is the form "frmDate" open with a date value entered into a text box named
"txtEndDate"?

Please try to tell us what you have looked at on your own to trouble-shoot
this so we don't have to play a game of 20 questions. It would really help
to know what your properties and environment are.
--
Duane Hookom
MS Access MVP

"MNY Intern" wrote in message
...
=DateAdd("ww",0,Forms!frmDate![txtEndDate])
=DateAdd("ww",-1,Forms!frmDate![txtEndDate])
=DateAdd("ww",-2,Forms!frmDate![txtEndDate])
=DateAdd("ww",-3,Forms!frmDate![txtEndDate])

Those are the control sources... they're named Wk0, Wk1, Wk2, and Wk3.
And when I run the report they come up as "#Name?"

"Duane Hookom" wrote:

What's in your report that shows #Name? I need to understand the control
sources etc.

--
Duane Hookom
MS Access MVP

"MNY Intern" wrote in message
...
Ok, I cleared the control source completely and put "txtEndDate" in the
Name
property, and the "#Name?" doesnt show up anymore in Form view, but it
still
comes up in my report.

"Duane Hookom" wrote:

You stated:
Inside the textbox I typed "txtEndDate."
You just set the control source to txtEndDate rather than the name of
the
text box. Open the properties dialog of the text box, clear the
control
source property and place txtEndDate in the Name property.

--
Duane Hookom
MS Access MVP



"MNY Intern" wrote in message
...
I had created a new form in design view. I clicked the textbox in the
toolbar
then clicked a spot on in the details area in the form.

That gave me 2 boxes. 1 I assume was a label (where the Text0: is)
and
the
2nd was the actual textbox. Inside the textbox I typed "txtEndDate."
And I
saved the form as "frmDate."

Everything worked as it was supposed to in regards to my query.
However
if
I
veiw the form "frmDate" in Form View, I see "#Name?" in the textbox.


"Duane Hookom" wrote:

My posting had stated :
My solution should work assuming you have a form "frmDate"
with a text box "txtEndDate"
Can you just tell me if this is the case? I have said nothing about
a
label
on the form. Also, I'm not sure how a form in form view shows
"text0:
#Name".


--
Duane Hookom
MS Access MVP

I did exactly what you had told me to. I created a form and named it frmDate.
I placed a textbox within that form and named it txtEndDate. If I put a date
in the box, I get #Name? in form view. If I put nothing in the box, I get
#Name? in form view.

If I just run my query with relative dates based on the frmDate form, I get
a parameter box that asks me for a txtEndDate. I give it one, I get 4 columns
of fines from each of the 4 weekending dates that coincide with the date I
put in. Which is exactly how I want that to run. When I run my report I get
the same parameter request, and after inputing what I want, I get the data I
want.

However, I cannot get the week ending dates to show up in the page header as
the column headings. I get the same #Name? as I would from my form in form
view.

Going back to my form. If I put =Date() in the textbox named txtEndDate, I
get today's date in form view, and when I run my report I get dates, but
they're from the middle of the week as today is the middle of the week, and
my data gets messed up. If I keep my form open when I run my report or query,
I don't get any returned values.

The "column headings" in my report are textboxes that have the =DateAdd
expression you suggested. They don't work because my form returns "#Name?"

I dont know what information you think I'm not providing you with. I'm only
trying to do exactly what you had suggested.
"Duane Hookom" wrote:

Is the form "frmDate" open with a date value entered into a text box named
"txtEndDate"?

Please try to tell us what you have looked at on your own to trouble-shoot
this so we don't have to play a game of 20 questions. It would really help
to know what your properties and environment are.
--
Duane Hookom
MS Access MVP

"MNY Intern" wrote in message
...
=DateAdd("ww",0,Forms!frmDate![txtEndDate])
=DateAdd("ww",-1,Forms!frmDate![txtEndDate])
=DateAdd("ww",-2,Forms!frmDate![txtEndDate])
=DateAdd("ww",-3,Forms!frmDate![txtEndDate])

Those are the control sources... they're named Wk0, Wk1, Wk2, and Wk3.
And when I run the report they come up as "#Name?"

"Duane Hookom" wrote:

What's in your report that shows #Name? I need to understand the control
sources etc.

--
Duane Hookom
MS Access MVP

"MNY Intern" wrote in message
...
Ok, I cleared the control source completely and put "txtEndDate" in the
Name
property, and the "#Name?" doesnt show up anymore in Form view, but it
still
comes up in my report.

"Duane Hookom" wrote:

You stated:
Inside the textbox I typed "txtEndDate."
You just set the control source to txtEndDate rather than the name of
the
text box. Open the properties dialog of the text box, clear the
control
source property and place txtEndDate in the Name property.

--
Duane Hookom
MS Access MVP



"MNY Intern" wrote in message
...
I had created a new form in design view. I clicked the textbox in the
toolbar
then clicked a spot on in the details area in the form.

That gave me 2 boxes. 1 I assume was a label (where the Text0: is)
and
the
2nd was the actual textbox. Inside the textbox I typed "txtEndDate."
And I
saved the form as "frmDate."

Everything worked as it was supposed to in regards to my query.
However
if
I
veiw the form "frmDate" in Form View, I see "#Name?" in the textbox.


"Duane Hookom" wrote:

My posting had stated :
My solution should work assuming you have a form "frmDate"
with a text box "txtEndDate"
Can you just tell me if this is the case? I have said nothing about
a
label
on the form. Also, I'm not sure how a form in form view shows
"text0:
#Name".


--
Duane Hookom
MS Access MVP

Back up to "I get #Name? in form view". What is the Control Source of the
text box txtEndDate on the form? The only way that it would show #Name? is
if you had something typed into the Control Source property. I have asked
you to clear that control source so there is nothing in the property.


--
Duane Hookom
MS Access MVP

"MNY Intern" wrote in message
...
I did exactly what you had told me to. I created a form and named it
frmDate.
I placed a textbox within that form and named it txtEndDate. If I put a
date
in the box, I get #Name? in form view. If I put nothing in the box, I get
#Name? in form view.

If I just run my query with relative dates based on the frmDate form, I
get
a parameter box that asks me for a txtEndDate. I give it one, I get 4
columns
of fines from each of the 4 weekending dates that coincide with the date I
put in. Which is exactly how I want that to run. When I run my report I
get
the same parameter request, and after inputing what I want, I get the data
I
want.

However, I cannot get the week ending dates to show up in the page header
as
the column headings. I get the same #Name? as I would from my form in form
view.

Going back to my form. If I put =Date() in the textbox named txtEndDate, I
get today's date in form view, and when I run my report I get dates, but
they're from the middle of the week as today is the middle of the week,
and
my data gets messed up. If I keep my form open when I run my report or
query,
I don't get any returned values.

The "column headings" in my report are textboxes that have the =DateAdd
expression you suggested. They don't work because my form returns "#Name?"

I dont know what information you think I'm not providing you with. I'm
only
trying to do exactly what you had suggested.
"Duane Hookom" wrote:

Is the form "frmDate" open with a date value entered into a text box
named
"txtEndDate"?

Please try to tell us what you have looked at on your own to
trouble-shoot
this so we don't have to play a game of 20 questions. It would really
help
to know what your properties and environment are.
--
Duane Hookom
MS Access MVP

"MNY Intern" wrote in message
...
=DateAdd("ww",0,Forms!frmDate![txtEndDate])
=DateAdd("ww",-1,Forms!frmDate![txtEndDate])
=DateAdd("ww",-2,Forms!frmDate![txtEndDate])
=DateAdd("ww",-3,Forms!frmDate![txtEndDate])

Those are the control sources... they're named Wk0, Wk1, Wk2, and Wk3.
And when I run the report they come up as "#Name?"

"Duane Hookom" wrote:

What's in your report that shows #Name? I need to understand the
control
sources etc.

--
Duane Hookom
MS Access MVP

"MNY Intern" wrote in message
...
Ok, I cleared the control source completely and put "txtEndDate" in
the
Name
property, and the "#Name?" doesnt show up anymore in Form view, but
it
still
comes up in my report.

"Duane Hookom" wrote:

You stated:
Inside the textbox I typed "txtEndDate."
You just set the control source to txtEndDate rather than the name
of
the
text box. Open the properties dialog of the text box, clear the
control
source property and place txtEndDate in the Name property.

--
Duane Hookom
MS Access MVP



"MNY Intern" wrote in message
...
I had created a new form in design view. I clicked the textbox in
the
toolbar
then clicked a spot on in the details area in the form.

That gave me 2 boxes. 1 I assume was a label (where the Text0:
is)
and
the
2nd was the actual textbox. Inside the textbox I typed
"txtEndDate."
And I
saved the form as "frmDate."

Everything worked as it was supposed to in regards to my query.
However
if
I
veiw the form "frmDate" in Form View, I see "#Name?" in the
textbox.


"Duane Hookom" wrote:

My posting had stated :
My solution should work assuming you have a form "frmDate"
with a text box "txtEndDate"
Can you just tell me if this is the case? I have said nothing
about
a
label
on the form. Also, I'm not sure how a form in form view shows
"text0:
#Name".


--
Duane Hookom
MS Access MVP