K
Kenny
I need to create a sub that can do the following - anyone else able to piont
me in the right direction as I am at quite basic level (Thank you alex for
earlier advice)
The db is for simple stock control, So I want the user to select products
and enter required quantities and hit a button that checks those required
quantities against the quantities on hand. The report should then print out
somthing as such:
Product Collect From
------------------------------------------
Boiler Store
Pipes Store
Radiator Supplier
I have a product table that is linked to an issueOrders table via an
inventory transactions table. as well as a form for issueorders that has a
subform that allows users to select a product and the required qty.
Can anyone help me develop what I need (ie I dont need v basic step-by-step
instructions, just some pointers to set me off...
If anyone could provde some time to assist me I would be most grateful,
Thank you
me in the right direction as I am at quite basic level (Thank you alex for
earlier advice)
The db is for simple stock control, So I want the user to select products
and enter required quantities and hit a button that checks those required
quantities against the quantities on hand. The report should then print out
somthing as such:
Product Collect From
------------------------------------------
Boiler Store
Pipes Store
Radiator Supplier
I have a product table that is linked to an issueOrders table via an
inventory transactions table. as well as a form for issueorders that has a
subform that allows users to select a product and the required qty.
Can anyone help me develop what I need (ie I dont need v basic step-by-step
instructions, just some pointers to set me off...
If anyone could provde some time to assist me I would be most grateful,
Thank you