Results 1 to 6 of 6
  1. #1
    Join Date
    May 2020
    Posts
    26

    Shipment creation

    Hi,
    I want to create a new shipment record , pulling information from a list of PO items and then adding the new record to a different table.

    Each shipment will have items from several different PO's and but only some of the items from each of the PO's.

    So I would create the new shipment number then find the correct PO number from the PO file, select the items off the given PO and add them to the shipment. I then need to repeat this with other PO's to add to the same shipment.
    This would then be added to a new table to do other manipulations with.



    Hope you can help

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I use a list box to pick items.
    User dbl-clicks the item ,this runs an append query to add to the Ship table. (del key can remove it via Delete query)
    Then when all items are added, the Final button prints manifests, etc.

    similar to this:
    Click image for larger version. 

Name:	pick state lbls.png 
Views:	12 
Size:	27.7 KB 
ID:	41989

  3. #3
    Join Date
    May 2020
    Posts
    26
    Hi,
    My list is a bit more complicated.

    I need to input the PO number then select the lines that are on the shipment.
    The select another PO and add items from that one.

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I suggest you show us a zip copy of your database --remove anything private/confidential first.
    Perhaps you could lead us through a specific example using a data value(s) in your PO info and illustrate how items on the PO(s) get put into a Shipment for clarification.

    You may also get some info from this free data model from Barry Williams' site. Just substitute Shipment for Delivery.

    Or this model from same site.

  5. #5
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you add boxes to the form for user to fill

  6. #6
    Join Date
    May 2020
    Posts
    26
    I think I need to use a sub form. It turns out the amount of data I have does not need such a complicated solution. Thanks anyway.

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

Similar Threads

  1. Subform creation
    By fspata in forum Forms
    Replies: 6
    Last Post: 11-04-2015, 07:51 PM
  2. PDF creation in VBA
    By BobRich99 in forum Access
    Replies: 2
    Last Post: 03-20-2015, 03:16 PM
  3. creating shipment confirmation
    By shank in forum Queries
    Replies: 3
    Last Post: 12-20-2013, 08:12 PM
  4. Replies: 8
    Last Post: 07-18-2013, 01:52 PM
  5. Help With A Shipment Tracking Project
    By iitenaciousg in forum Database Design
    Replies: 4
    Last Post: 01-07-2013, 07:41 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