Storing and Retrieving Common Info

[DocD]

I want to be able to store common info in a table and then use that in reports.

EG I want the user to be able to enter their personal info eg their company name, company address. I then want this info to appear on their reports and forms. This way the same application can be given to different companies, they can add their detail to the ?table and then this common info will customise their access db so that it appears on their reports etc...

I guess I need a table, but this table will only ever contain one row. The fields would be used in reports and forms.

I tired this way but I can't get it to work in the reports or forms.

Any ideas?

 

[bradcccs]

I perform the same tasks you have mentioned, but utilise a "Subreport" in each report header, rather than having to include the Info table in the record source of the report proper.

This also enables you to alter all report headers by only altering the subreport (change style of letter head etc).

HTH

Brad.

 

[DocD]

Thanks Brad, I was wondering if this was the way to do it.

 

[Rich]

You could also use DLookup on the table

 

[neileg]

You could use a one record table. Set public variables to read the fields in the table and use these variables in your reports.