Results 1 to 5 of 5
  1. #1
    Kamal123 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jun 2017
    Posts
    3

    Main form and sub form created for frmOrder and/frmSubOrderform is not functional to place a order?

    I would like to know whats wrong with my database, for some reason I cannot place a order. I would appreciate if someone can have a look at my database file and give me some advice. My email address is kamal53@hotmail.co.uk. Thanks!

    Regards,

    Kamal.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    could be many reasons - some that immediately spring to mind are form/subform allow additions/edits are false, subform has more than one table as a recordsource, relationships incorrectly set up, linkchild/master properties not set.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You should be able to attach the db here, after compacting and zipping.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    Kamal123 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jun 2017
    Posts
    3

    Database file for review regarding to problem.

    Hi Pbaldy and Ajax, thanks for the reply! Here is my database file, I'm not sure what's the problem so I appreciate if you can have a look at it please. Thanks!

    Regards,

    Kamal
    Attached Files Attached Files

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    there is quite a lot of things, if not wrong, then make it difficult to use.

    Why preface all ID's with 'CUST', 'PROD' etc? It means your indexes are all text and consequently 'expensive' in terms of space the index requires and the subsequent hit on performance. Also disconcerting for the user (in my humble opinion) - if they tab through the fields ORD will appear as they start to type. An if they use the mouse the could appear anywhere within the mask.

    Why not use combo boxes so the user does not need to know a product code but can simply find as they type? - same for customers.

    On another note, your order subform should just be based on tblOrderline. This is probably why you are unable to save an order. All it needs is the product code in a combo box. Similarly OrderID etc does not need to be displayed. If you want to display things like product names, then you would use a combo for the productID which has a rowsource which would also include the description - which can then be referenced by an unbound control

    You also do not include a price field. OK it's getting it from the product table - but what if you change the price there? All your orders which use that product will change as well - is that what you want?

    And you include an ordertotal field in the order table and subtotal field in the orderline table - both totals should be calculated as and when required

    Think about how you will manage this. You have entered an order. Then you change a price in the product table. You need to manage that so you will need to recalculate every orderline and order total. Or is the plan that you will reverse calculate a price every time your review an order?

    You need to read up on table design, you are not far off, but needs some improvement. Also read up on form design and the use of the different controls. Take a look at some of the templates provided with Access and see how they manage it

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

Similar Threads

  1. Replies: 9
    Last Post: 08-25-2015, 12:35 PM
  2. Replies: 2
    Last Post: 11-13-2012, 02:11 PM
  3. Replies: 6
    Last Post: 09-02-2012, 04:30 PM
  4. Replies: 2
    Last Post: 07-21-2011, 08:57 AM
  5. open small popup form by press functional key
    By alex_raju in forum Access
    Replies: 0
    Last Post: 07-13-2011, 09:20 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