S
sbnj
I have an existing database up and running great but im looking to add some
new features. I currently import a "new orders" file everyday - the file
contains order #, item #, qty ordered etc... when our products are made I
print product barcode labels from a separate program on a laser printer using
full sheets (14 labels per sheet). I want to be able to print the
data/barcode labels from a menu within access to a single label thermal
printer (like a UPS label printer).
The problem I am having is how to have access use the "qty ordered" number
from the table containing the daily order info and repeat that product label
that many times - example.. I get an order for 3 different items, lets say
the customer ordered 1 of the first item and 10 of the second item etc... I
need access to see that and generate or duplicate the label the appropiate
amount of times either on screen prior to printing or at print time. I get
hundreds of separate orders a day from about 400 different products to choose
from.
What I've tried so far.... I read a post earlier that basically asked the
same question - Allen Browne provided a great solution but when I follow the
instructions (correctly??) I get an error message "data type mismatch in
criteria expression" I have my order table and newly created tblCount table
(with 2,000 records 1-2000) in the query window with no links between them -
in the criteria section below tblCount I have <= [Qty] which is the field in
my main order table. When I run the query I get that message.
If I change the expression I get different results but never the desired
result of x copies of the particular record - I get things like 10 full
copies of all records where the CountID=1 for all 245 records then CountID=2
for all etc...
Not sure where I went wrong?
Thanks so much for reading this terribly long message
Scott
new features. I currently import a "new orders" file everyday - the file
contains order #, item #, qty ordered etc... when our products are made I
print product barcode labels from a separate program on a laser printer using
full sheets (14 labels per sheet). I want to be able to print the
data/barcode labels from a menu within access to a single label thermal
printer (like a UPS label printer).
The problem I am having is how to have access use the "qty ordered" number
from the table containing the daily order info and repeat that product label
that many times - example.. I get an order for 3 different items, lets say
the customer ordered 1 of the first item and 10 of the second item etc... I
need access to see that and generate or duplicate the label the appropiate
amount of times either on screen prior to printing or at print time. I get
hundreds of separate orders a day from about 400 different products to choose
from.
What I've tried so far.... I read a post earlier that basically asked the
same question - Allen Browne provided a great solution but when I follow the
instructions (correctly??) I get an error message "data type mismatch in
criteria expression" I have my order table and newly created tblCount table
(with 2,000 records 1-2000) in the query window with no links between them -
in the criteria section below tblCount I have <= [Qty] which is the field in
my main order table. When I run the query I get that message.
If I change the expression I get different results but never the desired
result of x copies of the particular record - I get things like 10 full
copies of all records where the CountID=1 for all 245 records then CountID=2
for all etc...
Not sure where I went wrong?
Thanks so much for reading this terribly long message
Scott