Bar Tender 2022 - Evaluation

Michael Robinson

• 25. Mai 2023 10:08

Hi Everyone

Firstly I hope this is the correct forum to post in, there is quite a choice.

I am currently evaluating BT 2022 and I have what I believe is a very simple requirement but I am struggling to make it work smoothly.

I have designed a label and connected to a MS SQL database. (312,000 records, single table, no joins) DB is remote to the PC I am working on but connected by 1GB links with low latency.

I would like to have a dialogue box appear where I can scan a barcode in to it, find the record in the database and it prints. (all in one go if possible)

I tried the record picker and whilst it worked the reload time of the form was 20 seconds plus lost of click and setting the cursor back in the field before scanning.

I then tried the "Query Prompt" and this is much better but still requires me to scan the barcode, then press next, it then loads a data grid which it then requires another click to print. Focus is set to both controls so RET RET does work, it just seems a little long winded.

Looked online and one post looked really promising but the link failed :-(

Any help or ideas would be greatly appreciated.

Thanks

Mick

0

• 

  Xabier Clemente

  Moderator

  ★ BarTender Hero ★

  • 1. Juni 2023 07:27

  Hello Michael,
  
  Thank you for reaching us via our Community Forums!
  
  Could you share the link URL you found? If it's a link to somewhere in our Knowledge Base, perhaps we can dig it up to see if it has valuable information. 
  
  Regarding your issue, if you'd like to completely automate the process, we have a Professional Services team who, in exchange for a quote, can assist you with creating a VB script that could automate the process and set your BarTender environment just the way you'd like it.
  
  Thank you.

  0
• 

  Peter Thane

  ★ BarTender Hero ★

  • 1. Juni 2023 07:52

  Hi Mick,

  For your Database Filter make sure this is ticked and also that your scanner sends a Carriage Return after the data too (scan into Notepad to see if each new data appears on separate lines when you scan it):

  

   

  On the File>Print screen and Selected Records set this to All rather than Selected or Selected at Print Time and see what that does.

   

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.