Lookup Values To Validate User Input Field Follow

0
Avatar
Legacy Poster

Hi Guys,

 

I have a label created which looks up a part number (via an access DB), then returns fields required, which is all working well.

 

Now then, we have a text field on the data entry form which a user manually types a booking in number, is there any way I can get bartender to look at this field and compare it to a list of values for the given part number, to validate it?

 

My end result would go along the lines of..........if that part number doesn't have the same booking in number (compared to a list of possible options) as what the user types in, they will receive a message warning them that no part numbers on that booking in number exists.

 

We would also like the ability to override if possible, as there a sometimes exceptions to the rule

 

Hope this makes sense and hope someone could point me in the right direction

 

Regards

 

Ryan

5 comments

0
Avatar
Shotaro Ito
Comment actions Permalink

Hi Ryan,

I would try from VB Script cancel printing, in OnPostPrompt event. You can have override button by

 

Format.CancelPrinting "Error","Continue"

 

http://forums.seagullscientific.com/index.php?/topic/2815-comparing-two-prompt-values/

 

The harder part is you need to connect to database within VB Script - something like this.

http://forums.seagullscientific.com/index.php?/topic/331-get-data-from-excel-db/

0
Avatar
Legacy Poster
Comment actions Permalink

Shotaro,

 

Many thanks for your reply.

 

Part one is coming together nicely, I've managed to get the script to look at a value and continue if ok, and stop (with the warning message) if the data doesn't match

 

Thanks a lot for your help...............i'll continue now trying to get it to look up multiple values

 

Regards

 

Ryan

0
Avatar
Legacy Poster
Comment actions Permalink

Also..................is there a way of changing the size of the message box font and title etc?

 

I'm also keen to try and make the override option password protected, is this at all possible?

 

Regards

 

Ryan

0
Avatar
Shotaro Ito
Comment actions Permalink

Text input box's font can be specified to any TrueType font, and Size can be changed by drag corners.

Label design including data entry form can be password locked by File > BarTender Document Password.

 

If you want to dynamically modify data entry form's text box font / size, there's no such option.

In that case I would create MS Access form, and export necessary data as CSV file then feed that to Commander.

Another option is create windows form by C#/VB.net and call BarTender in background via .net SDK.

0
Avatar
Legacy Poster
Comment actions Permalink

Ok so it's looking like creating an Access FE then passing the details to the label then

 

Do you know if it's possible to specify the start label number from outside bartender?

 

Regards

 

Ryan

Please sign in to leave a comment.