Multiple Records Query
Hello,
I have an Excel Spreadsheet that has thousands of Part Numbers. I need a query that allows me to select multiple Part Numbers for printing.
I was able to successful set up a query for one part number and print it, but i can't figure out how to set it up for multiple part numbers.
The query box pops up to input the part number. When you input the part number it comes up with a record you want to print. I need the query box to pop open again to continue adding part numbers to the list to print.
Any ideas on how to achieve this?
Thanks!
-
What you'll want to do is configure BarTender so that the prompt window comes back up after printing. To do that,select File, than Print, than in the print window select 'options' (it's about halfway down the print window), than check 'automatically print again' or 'repeat data entry until cancelled'.
0 -
Thanks for your response!
I tried this, but i need to select multiple records for one print job. After i query one record, i need to be able to query another record and add it to the list to be printed.
0 -
If you know the number of part numbers to be added beforehand, you could create one query prompt per part number in BT's database connection setup dialog. You would use the "OR" parameter for linking the query prompts.
Furthermore, apart from BT's query prompt dialog, you can also select the records at print time from a table. The query prompt and the record selection dialogs can be used together:
If this doesn't help, then you might wish to consider writing a front-end application using our .NET SDKs. Your application would perform the query prompts to the database, then create a text file with the records to be printed, and you would then have BarTender connect to this text file and print one label per database record.
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
3 Kommentare