Using a Common Report & Form Title (Access 2000)

Topic

New Reply

Is there any way to store the name and address of a school so that I can use it on Access forms and reports. I don’t just want to type it in on each form/report because I have several schools using my database. When I have to update it, I end up having to make sure all the forms and reports have the right school’s name on them. Each school has its own database. When I do changes, I just copy the appropriate forms/reports into each school’s database.

Reply | Quote

Replies

I often use a table for this purpose. The table (say tblSettings) has two fields: SettingName and SettingValue (both text fields). For example (name and director only, you would add address fields etc.)

SettingName	SettingValue
School	Lincoln Memorial High School
Director	Ms Amanda Williams

You can use DLookup to get values from this table, for example a text box to display the school with Control Source:

=DLookup("SettingValue", "tblSettings", "SettingName='School'")

For each school, you enter the appropriate values in the table, and all forms and reports will automatically display the correct name, address etc.

Reply | Quote

Works great! Thanks again, Hans!

Reply | Quote

Works great! Thanks again, Hans!

Reply | Quote

I often use a table for this purpose. The table (say tblSettings) has two fields: SettingName and SettingValue (both text fields). For example (name and director only, you would add address fields etc.)

SettingName	SettingValue
School	Lincoln Memorial High School
Director	Ms Amanda Williams

You can use DLookup to get values from this table, for example a text box to display the school with Control Source:

=DLookup("SettingValue", "tblSettings", "SettingName='School'")

For each school, you enter the appropriate values in the table, and all forms and reports will automatically display the correct name, address etc.

Reply | Quote