New to Access, simple question?

[Eric]

I'm trying to edit an Access report someone else wrote and I apparently
don't understand how Access works.
They have multiple tables with multiple reports. Each report is somehow
tied to one table.
I tried to add a field to one report and print data from a different table.
I used the "..." icon to define the control source which added as
"=

![field]".
When I run the report it prompts me for a value, the prompt has the table
name for a title, and the output only prints "#error".
What am I missing?

 

[Rick B]

Eric:

You already have a thread for this in another newsgroup with a very
experienced user helping you. Please stick to that thread.

 

[Eric]

After nearly 3 hours I got a response to that thread, about the time I tried
this group. I wrote right back to that response which did not answer my
question and haven't gotten a response. That was about 2 hours ago. It
seems like a beginner question so I thought this group might be more
appropriate. If you recognize this question from the other group maybe you
should try responding to it in that group. I'm not getting anywhere on this
seemingly simple task I was hoping to get done today. Thanks.

Eric:

You already have a thread for this in another newsgroup with a very
experienced user helping you. Please stick to that thread.



--
Rick B

I'm trying to edit an Access report someone else wrote and I apparently
don't understand how Access works.
They have multiple tables with multiple reports. Each report is somehow
tied to one table.
I tried to add a field to one report and print data from a different
table.
I used the "..." icon to define the control source which added as
"=

![field]".
When I run the report it prompts me for a value, the prompt has the table
name for a title, and the output only prints "#error".
What am I missing?

 

[gls858]

I'm trying to edit an Access report someone else wrote and I apparently
don't understand how Access works.
They have multiple tables with multiple reports. Each report is somehow
tied to one table.
I tried to add a field to one report and print data from a different table.
I used the "..." icon to define the control source which added as
"=

![field]".
When I run the report it prompts me for a value, the prompt has the table
name for a title, and the output only prints "#error".
What am I missing?

Not much info but reports are very often built from a query not
directly from the table. If this is the case the new table and field
must be added to the query before you can pull the info. Check the
record source for the report.

gls858

 

[Douglas J Steele]

Sorry, but since these newsgroups are free peer-to-peer support, expecting
faster turn-around than that is a little unrealistic.

Turn-around of a day is more the norm than turn-around of an hour.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

After nearly 3 hours I got a response to that thread, about the time I tried
this group. I wrote right back to that response which did not answer my
question and haven't gotten a response. That was about 2 hours ago. It
seems like a beginner question so I thought this group might be more
appropriate. If you recognize this question from the other group maybe you
should try responding to it in that group. I'm not getting anywhere on this
seemingly simple task I was hoping to get done today. Thanks.

Eric:

You already have a thread for this in another newsgroup with a very
experienced user helping you. Please stick to that thread.



--
Rick B

I'm trying to edit an Access report someone else wrote and I apparently
don't understand how Access works.
They have multiple tables with multiple reports. Each report is somehow
tied to one table.
I tried to add a field to one report and print data from a different
table.
I used the "..." icon to define the control source which added as
"=

![field]".
When I run the report it prompts me for a value, the prompt has the table
name for a title, and the output only prints "#error".
What am I missing?

 

[Eric]

I was checking properties windows and couldn't find the record source. I
was clicking the wrong little squares and just pulling up properties for
sections. I finally found the properties for the form. The record source
is referring to a single table. I recognized once I found this that Access
cannot pull up 2 unrelated tables even if one table just has a generic
record with variable information to be printed on the header. Since I would
have to make a query joining the 2 tables to pull in the other one, I
decided to write the value to every record of every table.

I'm trying to edit an Access report someone else wrote and I apparently
don't understand how Access works.
They have multiple tables with multiple reports. Each report is somehow
tied to one table.
I tried to add a field to one report and print data from a different
table.
I used the "..." icon to define the control source which added as
"=

![field]".
When I run the report it prompts me for a value, the prompt has the table
name for a title, and the output only prints "#error".
What am I missing?

Not much info but reports are very often built from a query not
directly from the table. If this is the case the new table and field
must be added to the query before you can pull the info. Check the
record source for the report.

gls858

 

[Eric]

I know. I was just hoping for faster turnaround on what seemed like a
simple thing (apparently it was, that I just needed to click the right
little square to find the properties box with the record source field) and
got a bit concerned when posts which showed up after mine got responses. I
guess these things are just kind of hit or miss. I did try the Help in
Access first and didn't see a clear answer there. I think they want to sell
more how to books. This stuff should be simple for an accounting systems
programmer, but maybe I need to start with Access for Dummies.

 

[gls858]

I was checking properties windows and couldn't find the record source. I
was clicking the wrong little squares and just pulling up properties for
sections. I finally found the properties for the form. The record source
is referring to a single table. I recognized once I found this that Access
cannot pull up 2 unrelated tables even if one table just has a generic
record with variable information to be printed on the header. Since I would
have to make a query joining the 2 tables to pull in the other one, I
decided to write the value to every record of every table.

I'm trying to edit an Access report someone else wrote and I apparently
don't understand how Access works.
They have multiple tables with multiple reports. Each report is somehow
tied to one table.
I tried to add a field to one report and print data from a different
table.
I used the "..." icon to define the control source which added as
"=

![field]".
When I run the report it prompts me for a value, the prompt has the table
name for a title, and the output only prints "#error".
What am I missing?

Not much info but reports are very often built from a query not
directly from the table. If this is the case the new table and field
must be added to the query before you can pull the info. Check the
record source for the report.

gls858

I know that solves your problem but it goes against the rules of
normalization to store the same value in all the tables. The proper
method is to build the query.

gls858

 

[Eric]

I was checking properties windows and couldn't find the record source. I
was clicking the wrong little squares and just pulling up properties for
sections. I finally found the properties for the form. The record
source is referring to a single table. I recognized once I found this
that Access cannot pull up 2 unrelated tables even if one table just has
a generic record with variable information to be printed on the header.
Since I would have to make a query joining the 2 tables to pull in the
other one, I decided to write the value to every record of every table.

Eric wrote:
I'm trying to edit an Access report someone else wrote and I apparently
don't understand how Access works.
They have multiple tables with multiple reports. Each report is
somehow
tied to one table.
I tried to add a field to one report and print data from a different
table.
I used the "..." icon to define the control source which added as
"=

![field]".
When I run the report it prompts me for a value, the prompt has the
table
name for a title, and the output only prints "#error".
What am I missing?


Not much info but reports are very often built from a query not
directly from the table. If this is the case the new table and field
must be added to the query before you can pull the info. Check the
record source for the report.

gls858

I know that solves your problem but it goes against the rules of
normalization to store the same value in all the tables. The proper
method is to build the query.

gls858

I wouldn't recommend this method to anyone else, but it's normalized enough
for us. Each table is used for a single report. Each table is updated from
another application through ODBC. That application is assigning the value
in one place, and deletes all records from each table before writing, so
this should be the easiest solution for us.

The other option might be a subreport but I don't know how they work. Can I
use a subreport to print a value in the middle of my report heading?

 

[gls858]

I was checking properties windows and couldn't find the record source. I
was clicking the wrong little squares and just pulling up properties for
sections. I finally found the properties for the form. The record
source is referring to a single table. I recognized once I found this
that Access cannot pull up 2 unrelated tables even if one table just has
a generic record with variable information to be printed on the header.
Since I would have to make a query joining the 2 tables to pull in the
other one, I decided to write the value to every record of every table.

Eric wrote:
I'm trying to edit an Access report someone else wrote and I apparently
don't understand how Access works.
They have multiple tables with multiple reports. Each report is
somehow
tied to one table.
I tried to add a field to one report and print data from a different
table.
I used the "..." icon to define the control source which added as
"=

![field]".
When I run the report it prompts me for a value, the prompt has the
table
name for a title, and the output only prints "#error".
What am I missing?


Not much info but reports are very often built from a query not
directly from the table. If this is the case the new table and field
must be added to the query before you can pull the info. Check the
record source for the report.

gls858

I know that solves your problem but it goes against the rules of
normalization to store the same value in all the tables. The proper
method is to build the query.

gls858

I wouldn't recommend this method to anyone else, but it's normalized enough
for us. Each table is used for a single report. Each table is updated from
another application through ODBC. That application is assigning the value
in one place, and deletes all records from each table before writing, so
this should be the easiest solution for us.

The other option might be a subreport but I don't know how they work. Can I
use a subreport to print a value in the middle of my report heading?

I'm not experienced enough with subreports to give you an answer. I do know
that to create one all you need to do is create a report then drag and drop
it onto another report to create a subreport. It can be dropped into
the report header.

gls858