Variable? to customise all reports with user's business name

[blackduck]

I want the user to be able to enter their own business name once when they get the database. Their name will then automatically appear on all of the reports without the user having to change each report.

I feel this is probably an obvious one but just cant get it.

Any ideas will be greatly appreciated.

 

[dhookom]

Create a one record table that contains the business information. Then add this table to the record source of the report.

Another method is to use a subreport based on the one business record.

Duane
Hook'D on Access
MS Access MVP

 

[blackduck]

Thank you!

I had the one record table set up, but was previously trying to add a textbox and it would ask for a parameter, and also had trouble adding it to my reports record source.

But the subform works beautifully!

Thank you very much.

 

[dhookom]

had trouble adding it to my reports record source" it doesn't get much easier than just adding the table to the record source. You don't have to join it to any other table as long as the business table has one and only one record.

Duane
Hook'D on Access
MS Access MVP

 

[SeeThru]

I uses a similar 'options' table, and then just use Dlookup to get the values - there are about 30 values that are used on database startup, report headers, etc.

Generally they are only called occasionally, so this works quite well.

SeeThru
Synergy Connections Ltd - Telemarketing Services

http://www.synergyconnections.co.uk