UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> need product qtyonhand compared to qtytobeordered    
 
   
codyvance
post Aug 1 2005, 02:46 PM
Post #1

New Member
Posts: 6
When i fill out the purchase requisition and change the quantity for an item, i want it to check the quantity we have on hand in my products table to see if the quantity requested is available and if not display a popup box saying "Item # so and so has only # in stock". Thanks
Go to the top of the page
 
+
HiTechCoach
post Aug 1 2005, 06:37 PM
Post #2

UtterAccess VIP
Posts: 18,427
From: Oklahoma City, Oklahoma
Place the VBA code in the after update event for the "quantity for an item".

Steps:

  • Get the quantity on hand ( probably by opening a recordset)
  • See if quantity requested > quantity on hand
  • display a message is true
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 10:32 AM