Generate Print Externally From Ms Access? 关注

0
Avatar
Legacy Poster

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

4 评论

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

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
Avatar
Ian Cummings
版主
评论操作 固定链接

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
Avatar
Legacy Poster
评论操作 固定链接

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
Avatar
Ian Cummings
版主
评论操作 固定链接

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

 

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

请先登录再写评论。