Barcodes On Access Report 关注

0
Avatar
Legacy Poster

Hello,

We are using Bartender Automation to print tags and pricing stickers for plants we sell.  Plant information and customer pricing information are stored in SQL database.  We have an Access GUI to handle the process and interact between Bartender, the data and the user.  All of that is working great!

 

When we ship an order, we send a supplement page that lists each plant, its UPC number, our price and the customer's retail price.  This is a Report generated by Access.  We have several customers who have asked for this list to show the physical barcode in addition to (or instead of) the UPC number.  Is there any way to get the barcode generated by Bartender back into Access for inclusion on the report?  My guess is that there is not.

 

If not, is my best alternative to create a template in Bartender that prints to 8.5 x 11 paper in our laser printer and generate the list that way?  If so, is there a way to include our company name, the customer's name and address, and maybe even a page number at the top of each page?  How about just at the top of the first page?

 

Thank you!

J. R.

 

2 评论

0
Avatar
Legacy Poster
评论操作 固定链接

I'm looking here for  a similar solution but if you already have a report from Ms Access, have you looked into Font For Barcode? is a font that you will have to installed in your server/ client and all you have to do is set the barcode value font to this font and voila!

 

The value will need to be like *1234445* and it will print a barcode. Give it a shot. One font I've used for past project is Archon Code 39 Barcode ttf. 

 

If you have have found a way to create a report with Bartender let me know. 

0
Avatar
Legacy Poster
评论操作 固定链接

It takes a bit to setup initially but instead of creating a report in Access you could output the data into a flat text file and use Commander/Integration Builder (depending on which version or Automation you have) to process it.

 

What you would need to do is

 

  • create a dummy data file with enough fields to allow for a full page worth of information including variable address data .
  • create a full page report sheet in BarTender adding on any fixed information fields, like your company name and details etc. plus a sequential number for the page number together with text or barcode objects for each field in your file
  • Link the label to the dummy data file and then (and this is where the fun begins) go through each variable field in turn linking them to the corresponding field in the data file.
  • Create the appropriate trigger in Commander?integration Builder to look for you live output trigger file and open and print the report label

Your report would need to be output in such a way that if more than one page were to be printed then the 2nd and subsequent page information would each be added to the data/trigger file as a separate line/record, including allowance for the address fields with either data in them or blank if you did not want these printed on each page. 

 

It does take quite a bit to setup, especially the laborious process of linking each label field to the correct data file field but should do what you require.

请先登录再写评论。