Results 1 to 3 of 3
  1. #1
    mbarnesca is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    5

    Northwind Template - Inventory Query

    I am trying to build a Query that will look at an inventory. If there is no inventory left it will not allow it as a selection or give message closed.



    The Northwind Template in Access 2010 has a similar function. When you place a new order it will ask you for quantity. If you select it and there is no quantity left it will give you error message.

    I recognize I need a:

    TABLE - Inventory - Where I can update volume/quantity
    Form - Method to order
    Query - That would reference table and volume/quantity and return message.


    What I would actually love, love to have is a method where for example I have 10 Apples available. 10 people place orders for Apples. Therefore no Apples left. the 11th person doesn't even get Apples as an option to order because it is no longer available versus try to order and get message above stating closed. That would be PERFECT!.

    I would love insight on how to do this. Did my best trying to figure it out on Northwind Template...but my knowledge is limited.

    My thought is maybe this is an append to the table or the like. Unsure

    Thank you in advance.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    make a query that shows the inventory count. User picks an item, that count comes to fill an ON HAND field, even if its zero.
    then you have something to prevent user from picking too many items.

  3. #3
    mbarnesca is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    5
    Sorry if lame at this. Do you mean like this? Click image for larger version. 

Name:	SumorCount.PNG 
Views:	13 
Size:	5.9 KB 
ID:	26229

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

Similar Threads

  1. Northwind Template Modification
    By Raleyoz in forum Access
    Replies: 11
    Last Post: 06-29-2015, 05:11 PM
  2. Error opening Northwind template
    By Lou_Reed in forum Access
    Replies: 7
    Last Post: 06-04-2015, 10:37 AM
  3. Replies: 15
    Last Post: 10-03-2014, 11:15 AM
  4. Customizing the Northwind Access Template help required
    By JulieBright in forum Database Design
    Replies: 12
    Last Post: 04-02-2012, 08:58 PM
  5. Northwind Inventory Error
    By jpl85716 in forum Access
    Replies: 8
    Last Post: 09-28-2010, 10:10 AM

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
  •  
Other Forums: Microsoft Office Forums