Newbie Inventory Help

Rixx

Registered User.
Local time
Today, 18:42
Joined
Mar 3, 2005
Messages
25
Hi all,

I have been browsing the forum concerning methods of implementing inventory control and came across this link.

http://members.iinet.net.au/~allenbrowne/AppInventory.html

I have the tables set up in the same way etc.
But being a newbie!, can anyone tell me where I put this code or function?

Do I set up a query and put it somewhere there? or is it something else? This must be a simple question for someone that is beyond the novice level!

Please help, and thanks in advance

Ricky
 
Last edited:
Put the OnHand() function in a module. Save the module as any name you like. Then you can use the function anywhere in the database as if it were a built-in function.

See how it is used in the Query and Form in the sample database attached.


Note
The code in Allen's function assumes ProductID is a numeric field.

The code was written in DAO. If you use Access 2000 or 2002, you must make a reference to DAO (when the code window is open, choose menu Tools, References... and select the Microsoft DAO 3.6 Object Library.)
.
 

Attachments

Last edited:
hey, ive tried running the query, but it comes up with a compile error, does anyone know aht is causing this?

how do i run the module? is this when I open the Select query? Does it run the Module automatically? Any advice would be much appreciates. Thank you
Alex
 
please can someone tell me what the tblAcq and tblAcqDetail does in this dtabase? i ont understand what is it that it does is it a necessary tables?
 
tblAcq = tblAcquired
and
tblAcqDetail = tblAcquiredDetail = Itms Received
 

Users who are viewing this thread

Back
Top Bottom