Stopping Print Job After One Record
Hi, I have a query prompt running that, based on the value entered, has the possibility to pull more than one record in the database. Since this is also a prompted layout, it just means that once the first label has printed, it prompts again for each subsequent record.
My request is simple - I need a way so that the print job ends, and thus the prompting windows stop, after the first record printed. I assume there must be some value I can increment, and then if that value = 1, send a cancel command. I'm just not sure of the correct command, or if there is a better way to do that.
Thanks.
My request is simple - I need a way so that the print job ends, and thus the prompting windows stop, after the first record printed. I assume there must be some value I can increment, and then if that value = 1, send a cancel command. I'm just not sure of the correct command, or if there is a better way to do that.
Thanks.
0
-
Oh don't tell me all I have to do is put "1" in the Selected Records box on print prompt. I had "1..." 
0 -
Gene Henson
★ BarTender Hero ★
If all you want to do is print the first record returned, then you can set the selected records box to “1”, and BarTender always print the first record returned by your query. If you want BarTender to just prompt once, but print the entire print job, you can adjust the prompt frequency on the [b]Prompting [/b]tab in BarTender.
To access this:
[list=1]
[*]Open [b]BarTender [/b]and your label format
[*]Double click on the object being prompted for
[*]On the [b]Data Source[/b] tab, click [b]More Options[/b]
[*]On the [b]Prompting [/b]tab, adjust the [b]Frequency[/b]
[list]
[*][b]Once at Start of Print Job[/b] will print the same prompted value across all records.
[*][b]Every Record[/b] will prompt you for each record returned by the query.
[/list]
[/list]
Hope that helps!0 -
Hi Gene,
Thanks for the response. The one issue with your approach is that fields that are set to pull from the database are *Forced* to prompt on every record. We want to populate the fields from database, but also allow the user to manually change things in the prompt if need be.
Luckily, I do not need to print any record other than the first, so the approach to just putting a "1" in selected records works for this application.0 -
I label therefore I am. 0
Please sign in to leave a comment.
Comments
4 comments