Label Validation Follow

0
Avatar
Legacy Poster

Good Morning

 

I am connected to our ERP database and the user scans the Job Number and Assembly Number.  I then use this info to check to make sure the part number for the job they are working on matches the label number:

 

Here is the Code:

ReferenceField("JobAsmbl.PartNum")

if Field("JobAsmbl.PartNum") <> "1004206" then

Format.CancelPrinting "This is not the correct Label for the part, please
verify you are scanning the correct Job and Assembly and Try again"

end if

I have placed it in the OnNewRecord event.

 

The problem is, the first time I try to print a label it gives me the cancel printing error above, but I know the record exists.  Without changing anything I try it again and it works just fine.

 

I am open to other ways to do this also.

 

Any help would be greatly appreciated.

 

Thanks

Chris

4 comments

0
Avatar
Legacy Poster
Comment actions Permalink

I'd move it to the print time event

0
Avatar
Legacy Poster
Comment actions Permalink

I moved it to the 'OnPrintJobStart' event but now I am not getting the cancel printing error message, it just goes right back to the printstation main window.

0
Avatar
Legacy Poster
Comment actions Permalink

I am outside my realm of knowledge, maybe a moderator will help you. 

0
Avatar
Shotaro Ito
Comment actions Permalink

Assuming that you're using BarTender 10.1 Automation edition or above, you can have condition for a template to print.

in Page setup > templates, you can specify when to print the main template such as database value doesn't match a number.

 

Another thought is keep the script in OnNewRercord of a text datasource then insert the line below at the beginning of the script.

 

If Format.IsPrinting = false Then Exit sub

Please sign in to leave a comment.