Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2013
    Posts
    2

    Question Unanswered: Help on Datasheet form - More tricky than it sounds

    I am trying create an order form that looks like an Excel spreadsheet. The sheet has the following fields(Columns): product no, product name, product category all coming from Products table. Now I want to have more columns that will have :Trays(How many trays of the product is required). Pkts( How many packets required), Notes (Notes on the product).
    Once the user enters all the quantities required(There may maybe products that will not be required), this datasheet needs to be save to a OrdersDetails table with OrderID as the reference.
    I have a main form with the following fields: OrderID, OrderDate, RequiredDate, ShopName, OrderStatus, OrderNotes that is Orders table. I have the OrderID in Orders table referenced to OrderID in the OrderDetails table.
    What I don't know is how to create the Order form in Datasheet view and then to save it to my table OrderDetails.
    I know how to use Form Wizard, and to create datasheets, but I am not able to do what I describe above. I am not sure if I will need a combination of VBA and SQl to solve this.
    Any help to point me in the right direction will be much appreciated as I have been struggling to get this simple database running.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    why?
    isn't it time your users dropped the addiction to spreadsheets and moved on into the database world.

    I don't like datasheets, nasty things can happen in an uncontrolled manner (a bit like spreadsheets in fact)
    consider using a sub form to hold details of whats been ordered linked to the parent form which holds the order details such as customer, address and so on.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2013
    Posts
    2

    All my products listed in subform inside Main Order Form

    Thank you for your time and help.
    I have cut down my database to basics.
    I have attached my working updated database.

    What I need is:
    Is there a way to show all my products listed as a subform from qryFreshMeats while showing empty fields for trays, packets and notes.
    Once the order form has been filled with the quantities required, to save it to tblOrderDetails ?

    Now I have only 3 tables
    tblFreshMeats - My product list
    tblShopOrder - main order details
    tblShopOrderDetails - details of the order.
    All 3 tables are linked in my relationships

    qryFreshMeats - filter of products to show only active products

    frmShopOrder - Main order form
    frmShopStart - Just a switchboard that starts the main form
    sbfShopOrderDetails - Subform inside the main form for Order details.

    The database works great, and it built upon many samples I have seen.

    What I need is:
    Is there a way to show all my products listed as a subform from qryFreshMeats while showing empty fields for trays, packets and notes.
    Once the order form has been filled with the quantities required, to save it to tblOrderDetails ?
    Attached Files Attached Files
    Last edited by sassoon; 01-23-13 at 08:36. Reason: Update information on my query

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •