Results 1 to 5 of 5
  1. #1
    tim.cassey is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Aug 2015
    Posts
    25

    Form Help with using multiple of the same thing

    Hi there,

    I am creating a database for users out in the field to use when they use parts on fixing products.

    What I want to be able to do is having the following in a table:

    - Serial Number (of part they are fixing)
    - Location (of part they are fixing)
    - Parts Used
    - Quantity Used
    - Part Status (Chargeable / Warranty)


    Now for one serial number they may use up to 10 parts of different quantities and different statuses (some may be chargeable, some may be warranty claims). How would I go about being able to enter multiple parts, quantities, and part statuses for each record entry? Would I just have to have Part1, Part1 Qty, Part1 Status (up to 10)? Seems like there might be an easier way?

    Any help is appreciated.

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    sounds like you need to use a continuous or datasheet form

  3. #3
    tim.cassey is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Aug 2015
    Posts
    25
    I've watched a few videos on continuous forms but I'm just not too sure... so i thought I would explain a bit more and see if you've got any further advice...

    So for each field:

    - Serial Number of the part they are fixing: they may fix a part many times over it's lifetime, so this is not a one time entry (not unique). This is to entered manually
    - Location (of part they are fixing)... to be entered manually
    - Parts Used: was hoping to use a drop-down box with a set list, from a separate table, linked to the main one
    - Quantity Used: entered in manually for each part that has been used for the job
    - Part Status (Chargeable/Warranty): to be selected from a drop-down box for each part used on the job

    From watching videos, I can't make the link in my head how a continuous form would help me to achieve this, can you help me further at all to make it click?

  4. #4
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    from your post, I'm assuming there are other fields you have provided such as serial/part descriptions

    I would expect to have 3 tables, one for serial data, a second for part data and a third to combine the two and add values like quantity

    so user would have a main form where they can select a serial number for the item they are working on

    on that form would be a subform (continuous) which would use the combining table. This would include a combobox for the user to select a part and controls to add quantities

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You need to get you data base designed to meet your requirements.
    If you work through this tutorial (30-45 minutes) you will learn the basic concepts of table and relationships. That is the major part of what is causing your issues currently.

    The tutorial has problem definition, the process involved, solution and related info.

    Good luck.

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

Similar Threads

  1. Replies: 2
    Last Post: 02-06-2013, 09:19 PM
  2. Replies: 11
    Last Post: 08-22-2012, 06:34 AM
  3. How's This SubForm Thing Done?
    By abrogard in forum Forms
    Replies: 6
    Last Post: 07-13-2012, 10:55 PM
  4. Probably a Strange thing to ask
    By everette in forum Access
    Replies: 3
    Last Post: 03-26-2011, 08:33 PM
  5. Craziest Thing You've Seen/Done
    By Rawb in forum Access
    Replies: 1
    Last Post: 10-25-2010, 02:56 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