Easily add headers to report with linked Excel table

[EllenM]

Hello,
I have a report that runs off a linked table. The report generates a leave
record for our timekeepers.

It works so well. All the timekeepers need to do is save each updated time
card Excel file they get from the users. Then they can generate each user's
leave report by pressing the "open report" switchboard button.

Is there a way for the timekeepers to easily key in the header information
(name, agency, etc.)? Presently it is added with labels, which takes some
Access training. For instance, can labels be filled in with a form?

Thanks in advance for your help,
Ellen

 

[Marshall Barton]

Hello,
I have a report that runs off a linked table. The report generates a leave
record for our timekeepers.

It works so well. All the timekeepers need to do is save each updated time
card Excel file they get from the users. Then they can generate each user's
leave report by pressing the "open report" switchboard button.

Is there a way for the timekeepers to easily key in the header information
(name, agency, etc.)? Presently it is added with labels, which takes some
Access training. For instance, can labels be filled in with a form?

An easy way to get a value from a form to a report is for
the report to use a text box with an expression like:
=Forms![name of form].[name of form text box]

 

[EllenM]

Thanks so much, Marsh. It works beautifully!!!

Hello,
I have a report that runs off a linked table. The report generates a leave
record for our timekeepers.

It works so well. All the timekeepers need to do is save each updated time
card Excel file they get from the users. Then they can generate each user's
leave report by pressing the "open report" switchboard button.

Is there a way for the timekeepers to easily key in the header information
(name, agency, etc.)? Presently it is added with labels, which takes some
Access training. For instance, can labels be filled in with a form?

An easy way to get a value from a form to a report is for
the report to use a text box with an expression like:
=Forms![name of form].[name of form text box]