Generate Print Externally From Ms Access?

Legacy Poster

• February 19, 2013 02:42

I'm brand new to this forum and barcode technology...I've been doing lots of research and here we are, printer bought and scanner at the ready. 

 

I've already pre-prepared an ms access database to link this too, and I can see how I can link bartender to the database to print things, but what I really want to do is print directly from ms access rather than build a list, open bartender and print (which seems to be the common suggestion). I'm sure someone else must have brought this up, but I can't seem to think of a search that finds it...

 

at the end of the day, how do I set up a bartender template so I can access it's fields and print it using VBA from MS access? Is there information on this out there already? Am I even on the right track? I have a 200 or so page "Programming manual" but before I get into that I'm praying there is a short answer....

 

So sorry if this information is easy to find, I appreciate the pointing out in any case,

 

Thanks in advance,

 

ChaosInACT

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • February 19, 2013 03:35

  Not sure if I have the full answer, but I seem to be on the right track.

   

  For the next poor soul who is in this sitch and finds this thread,

   

  http://www.bartenderbarcodesoftware.com/label-software/whitepapers/barcode-and-label-software-integration-methods(english).pdf

   

   

  EDIT: 

  ok, that is what I'm looking for but the examples are all in C, I'm using vba from withing MS Access, any have any examples of that somewhere?

   

  is there some kind of bartender reference model I can find...?

  0
• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • February 19, 2013 08:30

  Yes you are on the right track and many other customers have taken this approach.  Perfectly normal.  Note however that you will need either the Automation or Enterprise Automation edition in order to access the automation interface of BarTender.  Yes the Trial edition will also work, so long as you are within the trial period.

   

  Take a look at the below white papers:

   

  http://www.bartenderbarcodesoftware.com/label-software/whitepapers/Controlling-Barcode-Label-Software-using-ActiveX-Automation.pdf

   

  http://www.bartenderbarcodesoftware.com/label-software/whitepapers/Controlling-Barcode-Label-Software-using-C-Sharp-and-VB.NET(English).pdf

   

  Also, you will find a full programming reference in the BarTender Help system under the topic "Automating BarTender".  In there you will find both VB.NET and C# examples.

   

  *Note that the .NET SDK is an installable option that is not selected by default in the general install.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • February 19, 2013 21:37

  Thanks, Ian...

   

  I ended up with the poor mans version for now :) I have 2 days to get everything working. when the dust settles I'll revisit the programming choice.

   

  For others like me the answer was,

  1.design a template in bartender

  2. link the template to a dummy table in ms access (in my case, tblPrintNow) with all the fields the bartender template will need.

  3. create a shortcut to the *.btw file from bartender, edit it like so

               "C:\Program Files (x86)\Seagull\BarTender UltraLite\BarTend.exe" "C:\...\dir\test1.btw" /p /xs

   

  4. fire a shell command from ms access on the .lnk shortcut. ta da. then you just have to manage the PrintNow table.

   

  a bit cheap, but it works.

   

   

  Ian, what's the lowest version of bartender I need just to do the database link?

  0
• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • February 19, 2013 21:42

  The lowest edition that supports connecting to database is the Professional edition.

   

  http://www.bartenderbarcodesoftware.com/label-software/barcode-label-software-features.aspx

  0

Please sign in to leave a comment.