Placing Core Company Identification DAta in All Reports

[Jim Normile]

I wish to place Company Name and Address info in the top of every report
created in a particular database. Then, if the prototype is saleable to other
companies, I wish to quickly change the Company info in the Many reports to
the name and info of the new company.
So I am creating a table with one record, namely the basic name address and
contact key info for the company. Then I am creating a form on this one
record table which is a read-only form, displaying the one set of Company
information.

My next step is to create a report to handle a particular data set, and
either in the Report or the Page Header create links which will reference the
slots in the Compaqny Info Form/Table.

My attempts so far have failed. I am using the text-box control and trying
to write a link "=[Forms]![Companyinfo].[Coname]" in it but getting a name
error. IS my syntax wrong or is my approach wrong?? IF I get the Company name
right I will then either write separate Text bocxes for the other items or
concatenate them in the one.
Then later I can adjust the data in the core Company Info table to reflect
the next client and populate the headers of the forms.
A little guidance would be appreciated.

Thanks in advance

Jim Normile

 

[Duane Hookom]

Consider creating a subreport based on your table with one record. Use the
subreport in every report you need it. You might need to create one subreport
for Portrait reports and another for Landscape reports.

 

[Jim Normile]

Thank you Duane

Problem solved!!

Jim Normile

Consider creating a subreport based on your table with one record. Use the
subreport in every report you need it. You might need to create one subreport
for Portrait reports and another for Landscape reports.
--
Duane Hookom
Microsoft Access MVP

I wish to place Company Name and Address info in the top of every report
created in a particular database. Then, if the prototype is saleable to other
companies, I wish to quickly change the Company info in the Many reports to
the name and info of the new company.
So I am creating a table with one record, namely the basic name address and
contact key info for the company. Then I am creating a form on this one
record table which is a read-only form, displaying the one set of Company
information.

My next step is to create a report to handle a particular data set, and
either in the Report or the Page Header create links which will reference the
slots in the Compaqny Info Form/Table.

My attempts so far have failed. I am using the text-box control and trying
to write a link "=[Forms]![Companyinfo].[Coname]" in it but getting a name
error. IS my syntax wrong or is my approach wrong?? IF I get the Company name
right I will then either write separate Text bocxes for the other items or
concatenate them in the one.
Then later I can adjust the data in the core Company Info table to reflect
the next client and populate the headers of the forms.
A little guidance would be appreciated.

Thanks in advance

Jim Normile