Easily add headers to report with linked Excel table

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

Guest

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
 
EllenM said:
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?
Click to expand...


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]
 
Thanks so much, Marsh. It works beautifully!!!

Marshall Barton said:
EllenM said:
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?
Click to expand...


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