G
Guest
I buy used books from many vendors and I generate a detailed invoice each
week for the books I buy from each vendor. One vendor might send me 5 boxes
of books in one week and I might get only 3 boxes in the mail when I create
the invoice. To help my vendors know which boxes are received and invoiced,
they label each box with a unique BoxID. Every book I load into Access
includes the BoxID for the box in which it was shipped.
I need to have one textbox on the statement that looks at all the books
(records) for that invoice period and lists the BoxIDs in the text box. This
textbox with a list of all the Unique BoxIDs for that invoice period will not
only be used in the statement, but more importantly, on the "Memo" line of
the remittance check I send to the vendor in payment of the books received.
Some vendors don't use the BoxID field so it will be blank. Other vendors
might have sent 3 or more boxes, each with a unique boxID with 20 or 30
individual books in each box. I need to list on the statement all of the
BoxIDs represented on the statement those in a single textbox.
I don't know how to create that kind of textbox. Would I use the
UniqueValue function? I am learning VBA and haven't come across the way this
might be handled.
I thank you in advance for your help!
week for the books I buy from each vendor. One vendor might send me 5 boxes
of books in one week and I might get only 3 boxes in the mail when I create
the invoice. To help my vendors know which boxes are received and invoiced,
they label each box with a unique BoxID. Every book I load into Access
includes the BoxID for the box in which it was shipped.
I need to have one textbox on the statement that looks at all the books
(records) for that invoice period and lists the BoxIDs in the text box. This
textbox with a list of all the Unique BoxIDs for that invoice period will not
only be used in the statement, but more importantly, on the "Memo" line of
the remittance check I send to the vendor in payment of the books received.
Some vendors don't use the BoxID field so it will be blank. Other vendors
might have sent 3 or more boxes, each with a unique boxID with 20 or 30
individual books in each box. I need to list on the statement all of the
BoxIDs represented on the statement those in a single textbox.
I don't know how to create that kind of textbox. Would I use the
UniqueValue function? I am learning VBA and haven't come across the way this
might be handled.
I thank you in advance for your help!