Results 1 to 5 of 5
  1. #1
    sukhjinder's Avatar
    sukhjinder is offline Beginner
    Windows 10 Access 2016
    Join Date
    May 2016
    Posts
    43

    Form to enter multiple values at same time


    I have a table in which i received spare parts with different serial numbers. Every time the quantity of the spare parts are different. How to make a form to enter all the part number in a single go. As entering the details one by one is a hectic task. Is it possible to create multiple text boxes in the form based upon number of spare parts received.

    Please suggest me any idea the quantity never exceed 30 but it is also not fixed every time.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    not clear on what you are trying to achieve - please provide some examples

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    Like Ajax I find your post is not clear; my guess is that you have a list of data and do not want to manually enter it line-by-line. The more efficient approach would be to import the data. The specifics of how that is set up will depend on the structure of your data but in general one would use:
    * a link to the list file
    * an append data
    * join on unique product ID

  4. #4
    sukhjinder's Avatar
    sukhjinder is offline Beginner
    Windows 10 Access 2016
    Join Date
    May 2016
    Posts
    43
    Thanks a lot. this approach is much much better than to enter line by line. I have done it on excel and it is working fine

  5. #5
    sukhjinder's Avatar
    sukhjinder is offline Beginner
    Windows 10 Access 2016
    Join Date
    May 2016
    Posts
    43
    Quote Originally Posted by NTC View Post
    Like Ajax I find your post is not clear; my guess is that you have a list of data and do not want to manually enter it line-by-line. The more efficient approach would be to import the data. The specifics of how that is set up will depend on the structure of your data but in general one would use:
    * a link to the list file
    * an append data
    * join on unique product ID

    Thanks a lot again

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

Similar Threads

  1. Replies: 5
    Last Post: 11-18-2016, 10:27 AM
  2. Replies: 2
    Last Post: 11-06-2016, 09:23 AM
  3. Replies: 5
    Last Post: 08-20-2013, 09:37 AM
  4. Enter Orders for Multiple Customers in a Form
    By nelsonsbrian in forum Forms
    Replies: 1
    Last Post: 07-16-2013, 03:29 PM
  5. Enter Daily time in Form
    By Lorlai in forum Forms
    Replies: 6
    Last Post: 03-11-2013, 11:00 AM

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