Quantity on Hand

[Karan]

Hi,

I have posted many messages and got replies to most of them, I am very
thankful to all of you for spending your valueable time to my posts. Thanks
a lot !!

I am struck with the above said subject: How to Calculate the Quantity on
Hand ???

I had got some helpful replies from Mr. Allen Browne and when i saw them it
was very difficult for me to do what it explained. Mainly because i don't
know ABCD.... of programing. Please look this link that Mr. Browne sent to
me: http://allenbrowne.com/AppInventory.html .

I have created the tables same as Northwind Traders Database and Included
the two more tables as shown in the above link viz., Acquisition and
Acquisition Details. Now, how to put the Function (which is shown in the
above link) to get the Quantity on Hand.

Please help.

Thanks

Karan.

 

[Pieter Wijnen]

Create a new Module & paste the code

You should perhaps go out & buy a book on Access Programming? - There are
quite a few around...

;-) Pieter

 

[Karan]

Thanks for your reply,

In which Event Procedure i should paste the code. Is it in the Stock Take ?
In which field ?

I have created Table Relationships and Have done the Queries for Invoice
calculations.

Done couple of forms using Products table and Orders table.

And also, i will purchase the book on programming on access.

thanks

karan.

 

[Pieter Wijnen]

Lots of ways , the two most likely ones beeing:

1) You can bind a control on your form (Myform) to the function
ie Control Source: =OnHand(Forms!MyForm!ProductID)

2) or include it in the query for the form:
SELECT ... ,OnHand(tblProduct.ProductID) AS OnHand FROM ....

HTH

Pieter