Results 1 to 2 of 2
  1. #1
    MatrixRage is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010

    User friendly complex names

    I am attempting to design my first database, and have bought a couple books on Access, which were helpful for most of the database design

    The first (in probably a string) of problems I'm coming up with in the design is that the information must be inputted by our field workers (of which we have about 40). We do work at well sites which are typically named complex names such as "Phillips Nitro 08-16#3-18H"

    In addition, we may work on the site for a couple days to a week, and return in a few months to a year down the road. Such a complex names are a problem as they might input the names a few different ways.

    We take readings of the sites hourly, and would need all of our readings to output to a report giving the well, location, employee id, unit id, etc etc....we also have multiple (30 or so) units working, which would each be generating hourly readings, so data inputted into a certain timeframe would not be readings for just the one site.

    What I'm wondering, is if you guys have any suggestions on a system/design that would make getting accurate reports generated from the field.

    If we had a smaller number of employee's and units, I would assign the well site a code, and have the operators input the code, but we operate 24/7/365 and no one (or 3) person could hope to keep up with that. Is there a way to use a form with an Auto-complete so when they start to type it, they can choose the name from a drop-down list of already entered well names or something similar?

  2. #2
    MatrixRage is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Or maybe have a button on the field for "new well site" or "existing reported site" so that if they are starting a new job, they hit the first button, but if they are continuing the hourly report, it brings up the existing well (based off of the "existing well" and "employee I.D" (if there is a way for a ticket to be open based of that value) could even put a close out well site button to complete the logging and generate the report?

    With no access experience that might not be possible, but its just what seems logical to me. Suggestions greatly appreciated.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 06-30-2010, 10:57 PM
  2. need help, expression is too complex?
    By ice673 in forum Queries
    Replies: 5
    Last Post: 02-15-2010, 09:03 PM
  3. Creating User friendly Search Forms
    By BernardKane in forum Forms
    Replies: 7
    Last Post: 01-29-2010, 11:28 AM
  4. Help!!! user friendly forms/date entry
    By megank in forum Access
    Replies: 3
    Last Post: 03-31-2009, 09:47 AM
  5. Setting up User names and passwords
    By knightjp in forum Security
    Replies: 2
    Last Post: 02-05-2009, 10:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums