Use of a parameter / property or something else to distinguish - Microsoft Community

question ms access 2010. have ms access database have developed use in 1 location each form, report , word document produced has name of location ie 'north region' either in form heading, report title or in reference in word document output vba within db. have deploy more instances of same database use in other locations need make each form, report etc reflect name of own location eg 'west region', south region' etc.

i don't want have different version of database each location somehow parameterise location there minimal effort needed deploy update each location. thought of adding new 'location' table but, understanding, not available existing forms & reports based on existing tables or queries.

any ideas welcome i'm sure there must simple way it.

i'd inclined use location table, suggested, single (required) record containing location.  in various contexts within database there several techniques use location want it:

1. queries results don't need editable (like reports' recordsource queries) modify the query include table, without joining existing tables in query, , include location field in selected fields.  way, field value available records returned query.  however, such query not editable.

2. forms or other locations want display location , need rest of data editable, either use dlookup expression location, or (potentially) create custom function or public property , return location.  custom function or property procedure has advantage set uses static variable capture location first time procedure called after database opened, , returns value of static variable thereafter, without having table lookup.

3. use custom function or public property, described above, in queries need editable, invoking calculated field.  calculated field won't editable, rest of query fields be.

Office / Access / Other/unknown / Office 2010