Results 1 to 2 of 2
  1. #1
    jlmnjem is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Jul 2006

    Need help with database to display vehicle information

    I have set up a database that I want to function as a dataplate decoder for three model years for a specific make of automobile. The dataplate contains the Vehicle Identification Number (VIN) and a number of codes that define how the car was equipped.

    The first 5 characters of the VIN denotes the model year (1st), the manufacturing plant (2nd), the body style (3rd & 4th), and the engine (5th). The remaining six digits denote the sequential production number. Several of these codes are the same from one year to another.

    I have set up a table for each code (a total of ten). Each table that has duplicate information (all but three) has the model year, the code, and the description that the code denotes. Two of the remaining tables contain only the code and the description, as this information did not change during the three years this car was manufactured. The last remaining table has a code for the model year, and the 4-digit description of that year (i.e. Code=3, Description=1963).

    I would like to be able to run a query where the user selects the characters in his dataplate from an array of drop-down lists, and the result shows the description of what each code means. For the most part, it will be a simple lookup process, but some of the codes will change depending on the model year, which is the first charachter of the VIN. The six-digit sequential production number is the only thing that is certain to be unique for each model year. I have no interest in saving the information, it will just be a reference tool.

    Can anyone help with this? Thanks.

  2. #2
    Join Date
    Jul 2006
    Sacred Tomatoe, CA

    Re Vin Query

    Ford Products? (I used to be a police dispatcher in a former life and I am (used to be) familiar with many VIN arrangements. Be glad you're not tryng to decipher the 1981 and newer ones.
    It sounds like what you are trying to do is have the user decipher their VIN without saving the info decoded. (63 Mustang made at the Detroit plant with a 327 engine.)
    One possible way might be to have a form set up with text boxes pointing to the various tables. (txtYr) (txtPlant) (txtModel) (txtEngine) (txtSequential)
    They start by filling in the year. That allows them to select the Plant, Model, and Engine fields.
    One fancy thing might be to include a photograph linked to the year/model table.
    Good luck


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

Similar Threads

  1. Default Information for an existing field HELP
    By opinionsrfun in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:30 AM
  2. Replies: 0
    Last Post: 11-11-2008, 07:15 AM
  3. Form that hides information
    By dromorkid in forum Forms
    Replies: 0
    Last Post: 11-04-2008, 11:25 AM
  4. Replies: 1
    Last Post: 07-06-2007, 08:27 AM
  5. Replies: 0
    Last Post: 12-11-2006, 04:55 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