Lookup Values To Validate User Input Field
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
-
Shotaro Ito
★ BarTender Hero ★
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 -
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 -
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 -
Shotaro Ito
★ BarTender Hero ★
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 -
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
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
5 Kommentare