Results 1 to 11 of 11
  1. #1
    Join Date
    May 2009
    Location
    Devon, England
    Posts
    8

    Unanswered: Advice needed to create an order processing database

    Hi everyone.

    I am an a level student and my (first) project is to create a database that can process orders. I am very new to Access and i'm struggling a bit and really need some advice.

    I've created my tables and relationships with no problems. I'm now trying to create the form to input a new order. This is where i'm stuck. What i've come up with is not working as i want it to.

    So far, i've got a query that has the order_id, products, price, and it calculates the discount, VAT, and totals. I've then got a datasheet form created from this query - this is my subform.

    The main form i've set up to allow the client information and order number and shipping address to be input. The main form and subform are linked with the order_id.

    The totals for each product ordered, and other calculations, are showing on the subform correctly, but i don't how to get a field on the main form that shows the total amount for the entire order, i.e. to add the totals for each of the products selected. I don't even know if what i've done so far is right or if there's a better way i can achieve what i need.

    I've spent hours going through the text books i've got and i'm still none the wiser. I've attached a zipped copy of the database so far because it's difficult to explain, and it may help to actually look at what i've done so far incase anyone can help.



    TIA, Jamie
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2003
    Location
    Bulgaria, Plovdiv
    Posts
    36
    Your zip file appears to be in another format.

  3. #3
    Join Date
    May 2009
    Location
    Devon, England
    Posts
    8
    I'm not sure what you mean. I zipped it with winzip. Can you not open it?

  4. #4
    Join Date
    Aug 2003
    Location
    Bulgaria, Plovdiv
    Posts
    36
    I use WinZip 9.0 and when I try to extract the file it says:

    skipping: OMS - Copy.mdb this file is not in the standard Zip 2.0 format.
    Please see WinZip - Unsupported Zip Format for more information.
    Version required to extract this file is 63.
    Compression method required to extract this file is 14
    error: no files were found - nothing to do

  5. #5
    Join Date
    May 2009
    Location
    Devon, England
    Posts
    8
    i've rezipped it and attached it again. Sorry about that.
    Attached Files Attached Files

  6. #6
    Join Date
    Aug 2003
    Location
    Bulgaria, Plovdiv
    Posts
    36
    No change. Can you upload the file in mdb format?

  7. #7
    Join Date
    May 2009
    Location
    Devon, England
    Posts
    8
    I'm sorry about that. I can't upload in mdb format, the forum restricts that file type.

  8. #8
    Join Date
    May 2009
    Location
    Devon, England
    Posts
    8
    I'm using winzip 12, a much newer version. Maybe that's the problem? not sure how to get around that.

  9. #9
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I can't unzip it either. Perhaps look for an option in the new version like "use old winzip format" or something?

    Perhaps get your mdb file and rename it to .zip, then upload it? Not sure if the forum gods would like that though :/
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  10. #10
    Join Date
    May 2009
    Location
    Devon, England
    Posts
    8
    Ok, sorry guys. I think i must have been doing something wrong when zipping the file.

    I *think* i've got it right this time and attached another one.

    Jamie
    Attached Files Attached Files

  11. #11
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I still get the same problem.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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