J
James
I have a sales order database (comprising 3 main tables: Order Header, Order
Lines and Stock) and I'm trying to create a report that will allow me to type
in an order number and then it will print 1 card per item per quantity on an
order, pulling the product details (sizes, colours etc.) from the Stock table.
For example if a customer has ordered 5 of "Product A" and 2 of "Product B"
I want the report to print 5 separate cards for "A" which should be numbered
1 of 5, 2 of 5, 3 of 5, etc. and 2 separate cards for "B" numbered 1 of 2, 2
of 2.
I did it in a DOS based version of Dataease years ago but this isn't
compatible with my new systems so I would like to use Access. I really don't
know where to start with this in VBA. Any help would be appreciated.
Thanks.
Lines and Stock) and I'm trying to create a report that will allow me to type
in an order number and then it will print 1 card per item per quantity on an
order, pulling the product details (sizes, colours etc.) from the Stock table.
For example if a customer has ordered 5 of "Product A" and 2 of "Product B"
I want the report to print 5 separate cards for "A" which should be numbered
1 of 5, 2 of 5, 3 of 5, etc. and 2 separate cards for "B" numbered 1 of 2, 2
of 2.
I did it in a DOS based version of Dataease years ago but this isn't
compatible with my new systems so I would like to use Access. I really don't
know where to start with this in VBA. Any help would be appreciated.
Thanks.