Automating Label Printing From Access Db Random Printers 追蹤
Currently we have in use an Access database which creates a record to be sent to our designated Bartender label for printing.
How it works is we have created a table in Access for our data to be stored, and each field is linked to the Bartender label, the record gets created as and when we need it, this is done via a delete query to empty the table, then an append query to add the record which needs printing to the table.
I managed to find in the forum somewhere how to set this up.
All works perfectly well..............ish
We print each label one at a time as they are all unique in random ways, but when printing the label (creating the record) we seem to be able to print to the default printer the majority of the time, then every now and then, it would come out on a different printer in the section.
There are four printers and six machines in the area which use this system, and the labels can come out of any one of them, even though they are not connected to the machine it was printed from.
It's almost as if when the job gets sent to the printer, another user has also printed a label and the label just 'follows' the other label out of the printer instead of coming out where it's supposed to
Does anyone have any experience of this?