Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Anaheim, California, USA
    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
    Thanked 28 Times in 28 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