Site to find out how too....

[Bob]

--
After searching Google.groups.com and finding no answer, Bob Vance asked:

I want to have a window on my form so as what ever I type into it will
appear on my Invoice. I already have 6 other windows that do the same thing
to that Invoice.

Thanks in advance.........Bob Vance

 

[Duane Hookom]

What do you mean by "window"? Do you mean a text box? Is the information
going to be stored in your table or just printed on a report? If you don't
want to save what gets typed in, just create a text box with a control
source like:

=[Enter some text here]

 

[Bob]

Sorry, yes a text box but I want to save the info so each time it is printed
on my invoice , unless I change the text box message at a later date..Thanks
Bob

What do you mean by "window"? Do you mean a text box? Is the information
going to be stored in your table or just printed on a report? If you don't
want to save what gets typed in, just create a text box with a control
source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP

--
After searching Google.groups.com and finding no answer, Bob Vance asked:

I want to have a window on my form so as what ever I type into it will
appear on my Invoice. I already have 6 other windows that do the same
thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Duane Hookom]

Create a one record table and add your text into a field. Add this table to
your report's record source and add the field with the text to the grid so
you can display it in the report.

--
Duane Hookom
MS Access MVP

Sorry, yes a text box but I want to save the info so each time it is
printed on my invoice , unless I change the text box message at a later
date..Thanks Bob

What do you mean by "window"? Do you mean a text box? Is the information
going to be stored in your table or just printed on a report? If you
don't want to save what gets typed in, just create a text box with a
control source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP

--
After searching Google.groups.com and finding no answer, Bob Vance
asked:

I want to have a window on my form so as what ever I type into it will
appear on my Invoice. I already have 6 other windows that do the same
thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Bob]

Getting "Enter Parameter Value" error.....Thanks Bob

Create a one record table and add your text into a field. Add this table
to your report's record source and add the field with the text to the grid
so you can display it in the report.

--
Duane Hookom
MS Access MVP

Sorry, yes a text box but I want to save the info so each time it is
printed on my invoice , unless I change the text box message at a later
date..Thanks Bob

What do you mean by "window"? Do you mean a text box? Is the information
going to be stored in your table or just printed on a report? If you
don't want to save what gets typed in, just create a text box with a
control source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer, Bob Vance
asked:

I want to have a window on my form so as what ever I type into it will
appear on my Invoice. I already have 6 other windows that do the same
thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Bob]

I have this code but I am getting that error:
=tblCompanyInfo!BottomComment
Thanks Bob

Getting "Enter Parameter Value" error.....Thanks Bob

Create a one record table and add your text into a field. Add this table
to your report's record source and add the field with the text to the
grid so you can display it in the report.

--
Duane Hookom
MS Access MVP

Sorry, yes a text box but I want to save the info so each time it is
printed on my invoice , unless I change the text box message at a later
date..Thanks Bob
What do you mean by "window"? Do you mean a text box? Is the
information going to be stored in your table or just printed on a
report? If you don't want to save what gets typed in, just create a
text box with a control source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer, Bob Vance
asked:

I want to have a window on my form so as what ever I type into it will
appear on my Invoice. I already have 6 other windows that do the same
thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Duane Hookom]

Did you add the table to your report's record source?

--
Duane Hookom
MS Access MVP

I have this code but I am getting that error:
=tblCompanyInfo!BottomComment
Thanks Bob

Getting "Enter Parameter Value" error.....Thanks Bob

Create a one record table and add your text into a field. Add this table
to your report's record source and add the field with the text to the
grid so you can display it in the report.

--
Duane Hookom
MS Access MVP


Sorry, yes a text box but I want to save the info so each time it is
printed on my invoice , unless I change the text box message at a later
date..Thanks Bob
What do you mean by "window"? Do you mean a text box? Is the
information going to be stored in your table or just printed on a
report? If you don't want to save what gets typed in, just create a
text box with a control source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer, Bob Vance
asked:

I want to have a window on my form so as what ever I type into it
will appear on my Invoice. I already have 6 other windows that do the
same thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Bob]

Ok I added a new field called BottomComment to my CompanyInfo and it works
when I type some thing in to it, because when I F11 I can see what I typed
into the form. But On my report I can not find BottomComment?
Looks like I have to add it to my record source , where would I start
Thanks for your help

Did you add the table to your report's record source?

--
Duane Hookom
MS Access MVP

I have this code but I am getting that error:
=tblCompanyInfo!BottomComment
Thanks Bob

Getting "Enter Parameter Value" error.....Thanks Bob

Create a one record table and add your text into a field. Add this
table to your report's record source and add the field with the text to
the grid so you can display it in the report.

--
Duane Hookom
MS Access MVP


Sorry, yes a text box but I want to save the info so each time it is
printed on my invoice , unless I change the text box message at a
later date..Thanks Bob
What do you mean by "window"? Do you mean a text box? Is the
information going to be stored in your table or just printed on a
report? If you don't want to save what gets typed in, just create a
text box with a control source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer, Bob Vance
asked:

I want to have a window on my form so as what ever I type into it
will appear on my Invoice. I already have 6 other windows that do
the same thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Bob]

In Properties of Text box I can add things from rptInvoice/Report but my
tbBottomComment is not there I do find in down in tables/tblCompanyInfo but
it will not copy from there..Thanks Bob

Ok I added a new field called BottomComment to my CompanyInfo and it works
when I type some thing in to it, because when I F11 I can see what I typed
into the form. But On my report I can not find BottomComment?
Looks like I have to add it to my record source , where would I start
Thanks for your help

Did you add the table to your report's record source?

--
Duane Hookom
MS Access MVP

I have this code but I am getting that error:
=tblCompanyInfo!BottomComment
Thanks Bob
Getting "Enter Parameter Value" error.....Thanks Bob

Create a one record table and add your text into a field. Add this
table to your report's record source and add the field with the text
to the grid so you can display it in the report.

--
Duane Hookom
MS Access MVP


Sorry, yes a text box but I want to save the info so each time it is
printed on my invoice , unless I change the text box message at a
later date..Thanks Bob
What do you mean by "window"? Do you mean a text box? Is the
information going to be stored in your table or just printed on a
report? If you don't want to save what gets typed in, just create a
text box with a control source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer, Bob Vance
asked:

I want to have a window on my form so as what ever I type into it
will appear on my Invoice. I already have 6 other windows that do
the same thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Duane Hookom]

You recently stated "Looks like I have to add it to my record source ".. you
are correct. I have twice suggested that you add the table containing the
field to your report's record source.

If you are having trouble finding the record source, view the report
properties and find the Data tab.

--
Duane Hookom
MS Access MVP

In Properties of Text box I can add things from rptInvoice/Report but my
tbBottomComment is not there I do find in down in tables/tblCompanyInfo
but it will not copy from there..Thanks Bob

Ok I added a new field called BottomComment to my CompanyInfo and it
works when I type some thing in to it, because when I F11 I can see what
I typed into the form. But On my report I can not find BottomComment?
Looks like I have to add it to my record source , where would I start
Thanks for your help

Did you add the table to your report's record source?

--
Duane Hookom
MS Access MVP


I have this code but I am getting that error:
=tblCompanyInfo!BottomComment
Thanks Bob
Getting "Enter Parameter Value" error.....Thanks Bob

Create a one record table and add your text into a field. Add this
table to your report's record source and add the field with the text
to the grid so you can display it in the report.

--
Duane Hookom
MS Access MVP


Sorry, yes a text box but I want to save the info so each time it is
printed on my invoice , unless I change the text box message at a
later date..Thanks Bob
What do you mean by "window"? Do you mean a text box? Is the
information going to be stored in your table or just printed on a
report? If you don't want to save what gets typed in, just create a
text box with a control source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer, Bob Vance
asked:

I want to have a window on my form so as what ever I type into it
will appear on my Invoice. I already have 6 other windows that do
the same thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Bob]

BottomComment was the new field I added to CompanyInfo:
I cant find it in Report/Prop/control source /data/rptInvoice, but I do find
it under tables futher down as Tables/tblCompanyInfo/BottomComment
Thanks Bob

You recently stated "Looks like I have to add it to my record source "..
you are correct. I have twice suggested that you add the table containing
the field to your report's record source.

If you are having trouble finding the record source, view the report
properties and find the Data tab.

--
Duane Hookom
MS Access MVP

In Properties of Text box I can add things from rptInvoice/Report but my
tbBottomComment is not there I do find in down in tables/tblCompanyInfo
but it will not copy from there..Thanks Bob

Ok I added a new field called BottomComment to my CompanyInfo and it
works when I type some thing in to it, because when I F11 I can see what
I typed into the form. But On my report I can not find BottomComment?
Looks like I have to add it to my record source , where would I start
Thanks for your help
Did you add the table to your report's record source?

--
Duane Hookom
MS Access MVP


I have this code but I am getting that error:
=tblCompanyInfo!BottomComment
Thanks Bob
Getting "Enter Parameter Value" error.....Thanks Bob

Create a one record table and add your text into a field. Add this
table to your report's record source and add the field with the text
to the grid so you can display it in the report.

--
Duane Hookom
MS Access MVP


Sorry, yes a text box but I want to save the info so each time it
is printed on my invoice , unless I change the text box message at
a later date..Thanks Bob
What do you mean by "window"? Do you mean a text box? Is the
information going to be stored in your table or just printed on a
report? If you don't want to save what gets typed in, just create
a text box with a control source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer, Bob
Vance asked:

I want to have a window on my form so as what ever I type into it
will appear on my Invoice. I already have 6 other windows that do
the same thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Duane Hookom]

You have to add tblCompanyInfo table to the query/record source of your
report. Right click in the background of the top pane of the query designer
and choose to add a table.

--
Duane Hookom
MS Access MVP

BottomComment was the new field I added to CompanyInfo:
I cant find it in Report/Prop/control source /data/rptInvoice, but I do
find it under tables futher down as Tables/tblCompanyInfo/BottomComment
Thanks Bob

You recently stated "Looks like I have to add it to my record source "..
you are correct. I have twice suggested that you add the table containing
the field to your report's record source.

If you are having trouble finding the record source, view the report
properties and find the Data tab.

--
Duane Hookom
MS Access MVP

In Properties of Text box I can add things from rptInvoice/Report but my
tbBottomComment is not there I do find in down in tables/tblCompanyInfo
but it will not copy from there..Thanks Bob

Ok I added a new field called BottomComment to my CompanyInfo and it
works when I type some thing in to it, because when I F11 I can see
what I typed into the form. But On my report I can not find
BottomComment?
Looks like I have to add it to my record source , where would I start
Thanks for your help
Did you add the table to your report's record source?

--
Duane Hookom
MS Access MVP


I have this code but I am getting that error:
=tblCompanyInfo!BottomComment
Thanks Bob
Getting "Enter Parameter Value" error.....Thanks Bob

Create a one record table and add your text into a field. Add this
table to your report's record source and add the field with the
text to the grid so you can display it in the report.

--
Duane Hookom
MS Access MVP


Sorry, yes a text box but I want to save the info so each time it
is printed on my invoice , unless I change the text box message at
a later date..Thanks Bob
What do you mean by "window"? Do you mean a text box? Is the
information going to be stored in your table or just printed on a
report? If you don't want to save what gets typed in, just create
a text box with a control source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer, Bob
Vance asked:

I want to have a window on my form so as what ever I type into
it will appear on my Invoice. I already have 6 other windows
that do the same thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Bob]

Thanks , where do I find query designer exactly...Bob

You have to add tblCompanyInfo table to the query/record source of your
report. Right click in the background of the top pane of the query
designer and choose to add a table.

--
Duane Hookom
MS Access MVP

BottomComment was the new field I added to CompanyInfo:
I cant find it in Report/Prop/control source /data/rptInvoice, but I do
find it under tables futher down as Tables/tblCompanyInfo/BottomComment
Thanks Bob

You recently stated "Looks like I have to add it to my record source "..
you are correct. I have twice suggested that you add the table
containing the field to your report's record source.

If you are having trouble finding the record source, view the report
properties and find the Data tab.

--
Duane Hookom
MS Access MVP


In Properties of Text box I can add things from rptInvoice/Report but
my tbBottomComment is not there I do find in down in
tables/tblCompanyInfo but it will not copy from there..Thanks Bob

Ok I added a new field called BottomComment to my CompanyInfo and it
works when I type some thing in to it, because when I F11 I can see
what I typed into the form. But On my report I can not find
BottomComment?
Looks like I have to add it to my record source , where would I start
Thanks for your help
Did you add the table to your report's record source?

--
Duane Hookom
MS Access MVP


I have this code but I am getting that error:
=tblCompanyInfo!BottomComment
Thanks Bob
Getting "Enter Parameter Value" error.....Thanks Bob

Create a one record table and add your text into a field. Add this
table to your report's record source and add the field with the
text to the grid so you can display it in the report.

--
Duane Hookom
MS Access MVP


Sorry, yes a text box but I want to save the info so each time it
is printed on my invoice , unless I change the text box message
at a later date..Thanks Bob
What do you mean by "window"? Do you mean a text box? Is the
information going to be stored in your table or just printed on
a report? If you don't want to save what gets typed in, just
create a text box with a control source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer, Bob
Vance asked:

I want to have a window on my form so as what ever I type into
it will appear on my Invoice. I already have 6 other windows
that do the same thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Duane Hookom]

"Record Source" is a property of every report. Click the builder button
[...] to the right of this property to go to the designer.

--
Duane Hookom
MS Access MVP

Thanks , where do I find query designer exactly...Bob

You have to add tblCompanyInfo table to the query/record source of your
report. Right click in the background of the top pane of the query
designer and choose to add a table.

--
Duane Hookom
MS Access MVP

BottomComment was the new field I added to CompanyInfo:
I cant find it in Report/Prop/control source /data/rptInvoice, but I do
find it under tables futher down as Tables/tblCompanyInfo/BottomComment
Thanks Bob

You recently stated "Looks like I have to add it to my record source
".. you are correct. I have twice suggested that you add the table
containing the field to your report's record source.

If you are having trouble finding the record source, view the report
properties and find the Data tab.

--
Duane Hookom
MS Access MVP


In Properties of Text box I can add things from rptInvoice/Report but
my tbBottomComment is not there I do find in down in
tables/tblCompanyInfo but it will not copy from there..Thanks Bob

Ok I added a new field called BottomComment to my CompanyInfo and it
works when I type some thing in to it, because when I F11 I can see
what I typed into the form. But On my report I can not find
BottomComment?
Looks like I have to add it to my record source , where would I start
Thanks for your help
Did you add the table to your report's record source?

--
Duane Hookom
MS Access MVP


I have this code but I am getting that error:
=tblCompanyInfo!BottomComment
Thanks Bob
Getting "Enter Parameter Value" error.....Thanks Bob

Create a one record table and add your text into a field. Add
this table to your report's record source and add the field with
the text to the grid so you can display it in the report.

--
Duane Hookom
MS Access MVP


Sorry, yes a text box but I want to save the info so each time
it is printed on my invoice , unless I change the text box
message at a later date..Thanks Bob
What do you mean by "window"? Do you mean a text box? Is the
information going to be stored in your table or just printed on
a report? If you don't want to save what gets typed in, just
create a text box with a control source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer, Bob
Vance asked:

I want to have a window on my form so as what ever I type into
it will appear on my Invoice. I already have 6 other windows
that do the same thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Bob]

I have been doing that but my Field that I have in the table is not showing
in Rpt on in a table further down, when I select it that's when I get the
parameter Value error..Thanks Bob

"Record Source" is a property of every report. Click the builder button
[...] to the right of this property to go to the designer.

--
Duane Hookom
MS Access MVP

Thanks , where do I find query designer exactly...Bob

You have to add tblCompanyInfo table to the query/record source of your
report. Right click in the background of the top pane of the query
designer and choose to add a table.

--
Duane Hookom
MS Access MVP


BottomComment was the new field I added to CompanyInfo:
I cant find it in Report/Prop/control source /data/rptInvoice, but I do
find it under tables futher down as Tables/tblCompanyInfo/BottomComment
Thanks Bob

You recently stated "Looks like I have to add it to my record source
".. you are correct. I have twice suggested that you add the table
containing the field to your report's record source.

If you are having trouble finding the record source, view the report
properties and find the Data tab.

--
Duane Hookom
MS Access MVP


In Properties of Text box I can add things from rptInvoice/Report but
my tbBottomComment is not there I do find in down in
tables/tblCompanyInfo but it will not copy from there..Thanks Bob

Ok I added a new field called BottomComment to my CompanyInfo and it
works when I type some thing in to it, because when I F11 I can see
what I typed into the form. But On my report I can not find
BottomComment?
Looks like I have to add it to my record source , where would I
start
Thanks for your help
Did you add the table to your report's record source?

--
Duane Hookom
MS Access MVP


I have this code but I am getting that error:
=tblCompanyInfo!BottomComment
Thanks Bob
Getting "Enter Parameter Value" error.....Thanks Bob

Create a one record table and add your text into a field. Add
this table to your report's record source and add the field with
the text to the grid so you can display it in the report.

--
Duane Hookom
MS Access MVP


Sorry, yes a text box but I want to save the info so each time
it is printed on my invoice , unless I change the text box
message at a later date..Thanks Bob
message What do you mean by "window"? Do you mean a text box? Is the
information going to be stored in your table or just printed
on a report? If you don't want to save what gets typed in,
just create a text box with a control source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer, Bob
Vance asked:

I want to have a window on my form so as what ever I type
into it will appear on my Invoice. I already have 6 other
windows that do the same thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Duane Hookom]

Did you add the field to your grid? What is the SQL view of your query and
which field are you looking for?

--
Duane Hookom
MS Access MVP

I have been doing that but my Field that I have in the table is not showing
in Rpt on in a table further down, when I select it that's when I get the
parameter Value error..Thanks Bob

"Record Source" is a property of every report. Click the builder button
[...] to the right of this property to go to the designer.

--
Duane Hookom
MS Access MVP

Thanks , where do I find query designer exactly...Bob

You have to add tblCompanyInfo table to the query/record source of your
report. Right click in the background of the top pane of the query
designer and choose to add a table.

--
Duane Hookom
MS Access MVP


BottomComment was the new field I added to CompanyInfo:
I cant find it in Report/Prop/control source /data/rptInvoice, but I
do find it under tables futher down as
Tables/tblCompanyInfo/BottomComment
Thanks Bob

You recently stated "Looks like I have to add it to my record source
".. you are correct. I have twice suggested that you add the table
containing the field to your report's record source.

If you are having trouble finding the record source, view the report
properties and find the Data tab.

--
Duane Hookom
MS Access MVP


In Properties of Text box I can add things from rptInvoice/Report
but my tbBottomComment is not there I do find in down in
tables/tblCompanyInfo but it will not copy from there..Thanks Bob

Ok I added a new field called BottomComment to my CompanyInfo and
it works when I type some thing in to it, because when I F11 I can
see what I typed into the form. But On my report I can not find
BottomComment?
Looks like I have to add it to my record source , where would I
start
Thanks for your help
Did you add the table to your report's record source?

--
Duane Hookom
MS Access MVP


I have this code but I am getting that error:
=tblCompanyInfo!BottomComment
Thanks Bob
Getting "Enter Parameter Value" error.....Thanks Bob

Create a one record table and add your text into a field. Add
this table to your report's record source and add the field
with the text to the grid so you can display it in the report.

--
Duane Hookom
MS Access MVP


Sorry, yes a text box but I want to save the info so each time
it is printed on my invoice , unless I change the text box
message at a later date..Thanks Bob
message What do you mean by "window"? Do you mean a text box? Is the
information going to be stored in your table or just printed
on a report? If you don't want to save what gets typed in,
just create a text box with a control source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer, Bob
Vance asked:

I want to have a window on my form so as what ever I type
into it will appear on my Invoice. I already have 6 other
windows that do the same thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Bob]

This is what my coder said about it:
You did everything correct. Just need to add this new field in the select
sql statement that brings data for the report. It is written in the Open
event of Repot(Invoice)
Thanks Bob....What did I actually do wrong?

Did you add the field to your grid? What is the SQL view of your query and
which field are you looking for?

--
Duane Hookom
MS Access MVP

I have been doing that but my Field that I have in the table is not
showing in Rpt on in a table further down, when I select it that's when I
get the parameter Value error..Thanks Bob

"Record Source" is a property of every report. Click the builder button
[...] to the right of this property to go to the designer.

--
Duane Hookom
MS Access MVP


Thanks , where do I find query designer exactly...Bob

You have to add tblCompanyInfo table to the query/record source of
your report. Right click in the background of the top pane of the
query designer and choose to add a table.

--
Duane Hookom
MS Access MVP


BottomComment was the new field I added to CompanyInfo:
I cant find it in Report/Prop/control source /data/rptInvoice, but I
do find it under tables futher down as
Tables/tblCompanyInfo/BottomComment
Thanks Bob

You recently stated "Looks like I have to add it to my record source
".. you are correct. I have twice suggested that you add the table
containing the field to your report's record source.

If you are having trouble finding the record source, view the report
properties and find the Data tab.

--
Duane Hookom
MS Access MVP


In Properties of Text box I can add things from rptInvoice/Report
but my tbBottomComment is not there I do find in down in
tables/tblCompanyInfo but it will not copy from there..Thanks Bob

Ok I added a new field called BottomComment to my CompanyInfo and
it works when I type some thing in to it, because when I F11 I can
see what I typed into the form. But On my report I can not find
BottomComment?
Looks like I have to add it to my record source , where would I
start
Thanks for your help
Did you add the table to your report's record source?

--
Duane Hookom
MS Access MVP


I have this code but I am getting that error:
=tblCompanyInfo!BottomComment
Thanks Bob
Getting "Enter Parameter Value" error.....Thanks Bob

message Create a one record table and add your text into a field. Add
this table to your report's record source and add the field
with the text to the grid so you can display it in the report.

--
Duane Hookom
MS Access MVP


Sorry, yes a text box but I want to save the info so each
time it is printed on my invoice , unless I change the text
box message at a later date..Thanks Bob
message What do you mean by "window"? Do you mean a text box? Is the
information going to be stored in your table or just printed
on a report? If you don't want to save what gets typed in,
just create a text box with a control source like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer,
Bob Vance asked:

I want to have a window on my form so as what ever I type
into it will appear on my Invoice. I already have 6 other
windows that do the same thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Duane Hookom]

Who/what is your "coder"?
I repeat, "What is the SQL view of your query and which field are you
looking for?"

--
Duane Hookom
MS Access MVP

This is what my coder said about it:
You did everything correct. Just need to add this new field in the select
sql statement that brings data for the report. It is written in the Open
event of Repot(Invoice)
Thanks Bob....What did I actually do wrong?

Did you add the field to your grid? What is the SQL view of your query
and which field are you looking for?

--
Duane Hookom
MS Access MVP

I have been doing that but my Field that I have in the table is not
showing in Rpt on in a table further down, when I select it that's when I
get the parameter Value error..Thanks Bob

"Record Source" is a property of every report. Click the builder button
[...] to the right of this property to go to the designer.

--
Duane Hookom
MS Access MVP


Thanks , where do I find query designer exactly...Bob

You have to add tblCompanyInfo table to the query/record source of
your report. Right click in the background of the top pane of the
query designer and choose to add a table.

--
Duane Hookom
MS Access MVP


BottomComment was the new field I added to CompanyInfo:
I cant find it in Report/Prop/control source /data/rptInvoice, but I
do find it under tables futher down as
Tables/tblCompanyInfo/BottomComment
Thanks Bob

You recently stated "Looks like I have to add it to my record
source ".. you are correct. I have twice suggested that you add the
table containing the field to your report's record source.

If you are having trouble finding the record source, view the
report properties and find the Data tab.

--
Duane Hookom
MS Access MVP


In Properties of Text box I can add things from rptInvoice/Report
but my tbBottomComment is not there I do find in down in
tables/tblCompanyInfo but it will not copy from there..Thanks Bob

Ok I added a new field called BottomComment to my CompanyInfo and
it works when I type some thing in to it, because when I F11 I
can see what I typed into the form. But On my report I can not
find BottomComment?
Looks like I have to add it to my record source , where would I
start
Thanks for your help
Did you add the table to your report's record source?

--
Duane Hookom
MS Access MVP


I have this code but I am getting that error:
=tblCompanyInfo!BottomComment
Thanks Bob
Getting "Enter Parameter Value" error.....Thanks Bob

message Create a one record table and add your text into a field. Add
this table to your report's record source and add the field
with the text to the grid so you can display it in the
report.

--
Duane Hookom
MS Access MVP


Sorry, yes a text box but I want to save the info so each
time it is printed on my invoice , unless I change the text
box message at a later date..Thanks Bob
message What do you mean by "window"? Do you mean a text box? Is
the information going to be stored in your table or just
printed on a report? If you don't want to save what gets
typed in, just create a text box with a control source
like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer,
Bob Vance asked:

I want to have a window on my form so as what ever I type
into it will appear on my Invoice. I already have 6 other
windows that do the same thing to that Invoice.

Thanks in advance.........Bob Vance

 

[Bob]

I had a coder from RAC developed a Statement/Invoice programme and I was
trying to enhance it, so I emailed him my attempt and he told me what I did
wrong, but it went over my head, thought you may be able to tell me what I
did wrong in lay language..Thanks Bob

Who/what is your "coder"?
I repeat, "What is the SQL view of your query and which field are you
looking for?"

--
Duane Hookom
MS Access MVP

This is what my coder said about it:
You did everything correct. Just need to add this new field in the select
sql statement that brings data for the report. It is written in the Open
event of Repot(Invoice)
Thanks Bob....What did I actually do wrong?

Did you add the field to your grid? What is the SQL view of your query
and which field are you looking for?

--
Duane Hookom
MS Access MVP


I have been doing that but my Field that I have in the table is not
showing in Rpt on in a table further down, when I select it that's when
I get the parameter Value error..Thanks Bob

"Record Source" is a property of every report. Click the builder
button [...] to the right of this property to go to the designer.

--
Duane Hookom
MS Access MVP


Thanks , where do I find query designer exactly...Bob

You have to add tblCompanyInfo table to the query/record source of
your report. Right click in the background of the top pane of the
query designer and choose to add a table.

--
Duane Hookom
MS Access MVP


BottomComment was the new field I added to CompanyInfo:
I cant find it in Report/Prop/control source /data/rptInvoice, but
I do find it under tables futher down as
Tables/tblCompanyInfo/BottomComment
Thanks Bob

You recently stated "Looks like I have to add it to my record
source ".. you are correct. I have twice suggested that you add
the table containing the field to your report's record source.

If you are having trouble finding the record source, view the
report properties and find the Data tab.

--
Duane Hookom
MS Access MVP


In Properties of Text box I can add things from rptInvoice/Report
but my tbBottomComment is not there I do find in down in
tables/tblCompanyInfo but it will not copy from there..Thanks Bob

Ok I added a new field called BottomComment to my CompanyInfo
and it works when I type some thing in to it, because when I F11
I can see what I typed into the form. But On my report I can not
find BottomComment?
Looks like I have to add it to my record source , where would I
start
Thanks for your help
Did you add the table to your report's record source?

--
Duane Hookom
MS Access MVP


I have this code but I am getting that error:
=tblCompanyInfo!BottomComment
Thanks Bob
Getting "Enter Parameter Value" error.....Thanks Bob

message Create a one record table and add your text into a field.
Add this table to your report's record source and add the
field with the text to the grid so you can display it in the
report.

--
Duane Hookom
MS Access MVP


Sorry, yes a text box but I want to save the info so each
time it is printed on my invoice , unless I change the text
box message at a later date..Thanks Bob
message What do you mean by "window"? Do you mean a text box? Is
the information going to be stored in your table or just
printed on a report? If you don't want to save what gets
typed in, just create a text box with a control source
like:

=[Enter some text here]

--
Duane Hookom
MS Access MVP




--
After searching Google.groups.com and finding no answer,
Bob Vance asked:

I want to have a window on my form so as what ever I type
into it will appear on my Invoice. I already have 6 other
windows that do the same thing to that Invoice.

Thanks in advance.........Bob Vance

 

[John Vinson]

I had a coder from RAC developed a Statement/Invoice programme and I was
trying to enhance it, so I emailed him my attempt and he told me what I did
wrong, but it went over my head, thought you may be able to tell me what I
did wrong in lay language..Thanks Bob

He probably can. But Bob, you need to help. Duane is a brilliant guy,
but he's not telepathic and he cannot tell what you did wrong with
your query - because *he cannot see your query*.

Please open the query in design view. On the Menu, select "View" and
choose the "SQL" option. You will see a screen full of SQL code.

Copy and paste that code to a message here. It is the query, and Duane
or I or most of the other volunteers here can read it easily, and from
it hopefully determine the answer to your question.

John W. Vinson[MVP]