Company name in Report

[Guest]

What is the best way to have my company details print in all reports. I
assume there is a better way than manually adding labels to each report,
however, if I enter the details in a New Table called say 'Company details'
how does that then relate to the other tables. I am using Access 2003 and XP.
Thanks for any help.

 

[Allen Browne]

Store the value in a table, and use DLookup in the text box to display the
name on the report.

For example, if you have a table named tblSys, with fields:
TheVariable (text, indicating what is stored, primary key)
TheValue (text)
you could create a record like this:
CompanyName XYZ Ltd

Then the text box on the report would have this Control Source:
=DLookup("TheValue", "tblSys", "TheVariable = 'CompanyName'")

For more help on DLookup(), see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

 

[Guest]

Thanks very much for your swift response.