List table name in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I list the table name in a report footer? I understand text boxes and
footers, but is there a clever way to get the table name into the control
source?
 
in the textbox's ControlSource property, try

=[Reports]![ReportName].[RecordSource]

substitute the correct report name, of course.

hth
 
It didn't work. Some more background may be needed. I am linking to an Excel
Worksheet with multiple tables. Each table is a copy of the other with the
addition of monthy data updates. (No need to explain good RDB design basics,
this is a temporary data solution during an ERP conversion for a group with
no Access expertise. Building data entry forms is not worth it, etc.) I want
to list the table name on the reports so that the users know that they are
linked to the latest data.
Thanks
tina said:
in the textbox's ControlSource property, try

=[Reports]![ReportName].[RecordSource]

substitute the correct report name, of course.

hth


Steve-in-austin said:
How can I list the table name in a report footer? I understand text boxes and
footers, but is there a clever way to get the table name into the control
source?
Click to expand...
Click to expand...
 
well, "it didn't work" doesn't give me much to go on. does the report have a
table listed in the RecordSource property? if so, what did the calculated
textbox control show - #Error? or something else?


Steve-in-austin said:
It didn't work. Some more background may be needed. I am linking to an Excel
Worksheet with multiple tables. Each table is a copy of the other with the
addition of monthy data updates. (No need to explain good RDB design basics,
this is a temporary data solution during an ERP conversion for a group with
no Access expertise. Building data entry forms is not worth it, etc.) I want
to list the table name on the reports so that the users know that they are
linked to the latest data.
Thanks
tina said:
in the textbox's ControlSource property, try

=[Reports]![ReportName].[RecordSource]

substitute the correct report name, of course.

hth


How can I list the table name in a report footer? I understand text
Click to expand...
boxes
and
footers, but is there a clever way to get the table name into the control
source?
Click to expand...
Click to expand...
Click to expand...
 
You may be able to get by with a text box with a control source of:
=[RecordSource]

--
Duane Hookom
MS Access MVP
--

tina said:
well, "it didn't work" doesn't give me much to go on. does the report have
a
table listed in the RecordSource property? if so, what did the calculated
textbox control show - #Error? or something else?


message
It didn't work. Some more background may be needed. I am linking to an Excel
Worksheet with multiple tables. Each table is a copy of the other with
the
addition of monthy data updates. (No need to explain good RDB design basics,
this is a temporary data solution during an ERP conversion for a group with
no Access expertise. Building data entry forms is not worth it, etc.) I want
to list the table name on the reports so that the users know that they
are
linked to the latest data.
Thanks
tina said:
in the textbox's ControlSource property, try

=[Reports]![ReportName].[RecordSource]

substitute the correct report name, of course.

hth


How can I list the table name in a report footer? I understand text boxes
and
footers, but is there a clever way to get the table name into the control
source?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top