Usining info from Registry in report - Access 2003

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

Guest

Hi,

I have several reports that use the same information. I've stored that
constant information in the registry. One paragraph in my letter uses a
combination of text and the registry entries. I use 5 items in the registry.
In the past I merged Word and Access. Now I want to create a report in
Access.

I used the following command in Word to get the information from the
registry:
strLocationCity=GetSetting("OrgName","SemData","LocationCity")

I'm not sure how to do this in Access. Where does the coding go?

Thanks.

jbc
 
Perhaps the easiest way is to use the function as
the Control Source for a text box on the report.

Instead of a field name in the Control Source, use

=GetSetting("OrgName","SemData","LocationCity")

Note that the '=' is required here.

But you probably want to concatenate the value. You
can also do that as a Control Source value, using the
names of the table fields which contain your other data:

=[f1] & GetSetting("OrgName","SemData","LocationCity") & [f2]

Another idea to consider is simply putting the data
into a table, instead of using the registry.

(david)
 
Back
Top