Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Multiple Locations (2000/SR1)

    I have a database that we are going to use at several locations. Each location will have their own set of data. In order to "Customize" it for each location, I wanted to be able to allow each user to enter information, such as the name of their division, address, etc. and then have that information print at the tops of forms and reports. What would be the best way to do that? I'm not sure what to search for, and the ones that I have tried so far, haven't worked. I'm sure it's been done before, I don't want to re-invent the wheel. Thanks for any help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple Locations (2000/SR1)

    Create a small table tblSettings that contains the localized settings:

    <table border=1><td align=center>Item</td><td align=center>Value</td><td>Division</td><td>Widgets</td><td>Address1</td><td>Sprocket Building</td><td>Address2</td><td>1929 Spruce Ave</td><td>City</td><td>Culvert City</td></table>
    Use DLookup to retrieve these values, for example to get the division:

    <code>=DLookup("Value", "tblSettings", "Item='Division'")</code>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •