Results 1 to 9 of 9
  1. #1
    pnorsworthy is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2023
    Posts
    4

    Table update using forms

    I have a BD that uses a work orders table and parts inventory table. I am trying to figure out how, when I add a part to a work order it will remove the quantity of parts used from the inventory table. Seems simple but I am struggling as to how to start. Any help would be greatly appreciated. Thanks.

  2. #2
    CarlettoFed is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2019
    Posts
    255
    Attach a sample file to see what you've made.

  3. #3
    pnorsworthy is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2023
    Posts
    4
    Quote Originally Posted by CarlettoFed View Post
    Attach a sample file to see what you've made.
    Unable to upload. File is too big

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Do a "compact and repair ". Then "zip" the file and attach the zipped file to your post.

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Quote Originally Posted by pnorsworthy View Post
    Unable to upload. File is too big
    Key word there was 'sample' ?
    We do not need the whole db.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  7. #7
    pnorsworthy is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2023
    Posts
    4
    Quote Originally Posted by Bob Fitz View Post
    Do a "compact and repair ". Then "zip" the file and attach the zipped file to your post.

    Zip file attached
    Attached Files Attached Files

  8. #8
    pnorsworthy is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2023
    Posts
    4
    Quote Originally Posted by pnorsworthy View Post
    Zip file attached
    Using the "Copy of WorkOrder, I need to have "Inventory QTY" update when "Qty Part #" has a value added to it. This way my inventory is current after a repair is complete. Thanks

  9. #9
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    Your Work Order Table has what are known as Repeating Groups.

    These fields:-
    Part 1 to 6
    Qty Part 1 to 6
    Part 1 to 6 Description
    Part 1 to 6 Cost

    These should all be records in a related table named tblWorkOrderItems
    Attached Thumbnails Attached Thumbnails Work Order.PNG  
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

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

Similar Threads

  1. Replies: 4
    Last Post: 03-09-2022, 11:28 AM
  2. Replies: 15
    Last Post: 12-08-2017, 05:32 PM
  3. Update column in table/forms
    By sk88 in forum Access
    Replies: 1
    Last Post: 01-15-2015, 01:00 PM
  4. Using forms to immediately edit/update a table
    By TKTheKid in forum Reports
    Replies: 18
    Last Post: 11-19-2012, 11:58 PM
  5. Replies: 0
    Last Post: 07-08-2010, 11:22 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