New to MS Access simple question

  • Thread starter Thread starter Eric
  • Start date Start date
E

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?
 
Every report has only one Record Source property. This identifies the table
or tables that supply the information to display in the report. If you can't
add the table to your report's record source, you might be able to use a
domain aggregate function like DLookup().
 
I figured I would need to add the table to the report, but where is the
record source section? I didn't see it in the Properties windows.

Duane Hookom said:
Every report has only one Record Source property. This identifies the
table or tables that supply the information to display in the report. If
you can't add the table to your report's record source, you might be able
to use a domain aggregate function like DLookup().
--
Duane Hookom
MS Access MVP

Eric said:
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?
Click to expand...
Click to expand...
 
View the report properties and select All properties or Data properties.
--
Duane Hookom
MS Access MVP

Eric said:
I figured I would need to add the table to the report, but where is the
record source section? I didn't see it in the Properties windows.

Duane Hookom said:
Every report has only one Record Source property. This identifies the
table or tables that supply the information to display in the report. If
you can't add the table to your report's record source, you might be able
to use a domain aggregate function like DLookup().
--
Duane Hookom
MS Access MVP

Eric said:
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?
Click to expand...
Click to expand...
Click to expand...
 
I see. That is where I was getting confused. Every time I looked for a
Properties window, I was getting control properties or section properties.
I found the report properties now. It has a Record Source block which
selects one table or invokes query builder (so apparently every report only
uses one table, or one query which connects multiple tables). I didn't want
to create a query, since the value I'm pulling from the second table is
unrelated to the value in the first table (just one field from any record
always the same value), so I'll just add a field to the first table and
write the value there too...unless there's a better way? The standard value
is a message that needs to print sometimes on each report. It either prints
that message or blank. Can I do that without writing the value to the
tables? I'm writing data to the tables from another application through
ODBC, then running the reports from the OpenReport function in VB.

Duane Hookom said:
View the report properties and select All properties or Data properties.
--
Duane Hookom
MS Access MVP

Eric said:
I figured I would need to add the table to the report, but where is the
record source section? I didn't see it in the Properties windows.

Duane Hookom said:
Every report has only one Record Source property. This identifies the
table or tables that supply the information to display in the report. If
you can't add the table to your report's record source, you might be
able to use a domain aggregate function like DLookup().
--
Duane Hookom
MS Access MVP

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?
Click to expand...
Click to expand...
Click to expand...
 
I would use a subreport based on the unrelated table. Each subreport can
have its own record source.
--
Duane Hookom
MS Access MVP

Eric said:
I see. That is where I was getting confused. Every time I looked for a
Properties window, I was getting control properties or section properties.
I found the report properties now. It has a Record Source block which
selects one table or invokes query builder (so apparently every report only
uses one table, or one query which connects multiple tables). I didn't
want to create a query, since the value I'm pulling from the second table
is unrelated to the value in the first table (just one field from any
record always the same value), so I'll just add a field to the first table
and write the value there too...unless there's a better way? The standard
value is a message that needs to print sometimes on each report. It either
prints that message or blank. Can I do that without writing the value to
the tables? I'm writing data to the tables from another application
through ODBC, then running the reports from the OpenReport function in VB.

Duane Hookom said:
View the report properties and select All properties or Data properties.
--
Duane Hookom
MS Access MVP

Eric said:
I figured I would need to add the table to the report, but where is the
record source section? I didn't see it in the Properties windows.

"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
Every report has only one Record Source property. This identifies the
table or tables that supply the information to display in the report.
If you can't add the table to your report's record source, you might be
able to use a domain aggregate function like DLookup().
--
Duane Hookom
MS Access MVP

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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top