Aug 032016
 

Anyone who is interested in using our SDK with Visual Basic and MS Access should take a look at our VB/Access sample found here:

http://labelwriter.com/software/dls/sdk/samples/DymoLabelFramework.accdb

  28 Responses to “How to use DYMO DLS SDK with VB and MS Access”

  1. hello! great sample

    can anyone please tell me how to change the code to print BARCODES instead of text?

    thanks!

  2. I have Office 2010 32bit and DLS 8.6 installed.
    Now I have tried to use the sample in this accdb file to print via msaccess.
    When I try to print the following error occurs:
    Unable to load DLL ‘DYMOPrinting.dll’: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
    Any help is appreciated.

    • Hi Thomas,

      We are working on that issue right now. There seems to be a problem with our installer. The immediate workaround is to manually copy DYMOPrinting.dll from the DLS installation folder.

      Let me know if that helps.

      Regards,
      Jeff

      • Hi Jeff

        Hi good to know that it is not my fault and that the error is known. ;)
        And where do I have to put the dll file? Tried it with system32 folder but without luck.

        Regards,

        Thomas

      • Hi,

        Is there a chance that I get an answer to my previous question?
        Where do I have to put the dll file?

        The installer seems to be still the old one.

        Regards,

        Thomas

      • Run into the same issue here:
        Unable to load DLL ‘DYMOPrinting.dll’: The specified module could not be found. (Exception from HRESULT: 0x8007007E)

        Place the dll right in your projects directory side by side with your other dlls, maybe try different subfolders (bin/..)..
        Make sure to grab the right one (x86 or x64)

      • 10 days later,
        still no answer…..

        Is here nobody who can help?
        Where do I have to put this dll file?

        • Hello

          I can speak English well..;;

          I have been successful in 64bit system

          I try to change 64bit environment to any cpu enviroment, Because program that i am making have to use in any cpu

          So when I try to resolve this program, I find this blog..

          Sorry, I can help you T_T

          I will wait person that will resolve..

        • The immediate workaround is to manually copy DYMOPrinting.dll from the DLS installation folder into your working directory (i.e., wherever you’re executing from).

  3. Copied the dll file to the project folder but it doesn’t solved the problem.

  4. Found a solution!
    Copied the dll file in the msaccess folder c:\ProgramFiles\office\….

    Now I can start testing, finally.

  5. In VB6 and VBA it is possible to use a .NET com class.

    Read more at:
    https://www.acgminvent.nl/2017/10/10/dymo-vb6vba/

    Good luck.

  6. Can anyone help me print a label with a simple button exactly like they do in the sample Access file? I want the button to take the data from the currently selected record (address, name, phone no, etc.) and print directly to the LabelWriter (preferably with no additional prompts, just instantaneous) using a template I made in DLS v.8. I have tried using a combination of code from this website: http://developers.dymo.com/2010/07/21/how-to-set-data-on-your-label-using-the-sdk/
    Along with the code in the sample Access file, to no avail.

    Thanks to anyone who helps me

    • Hi Tim,

      What kind of problems are you having? Are you able to print a label (any label with any content)?

      Ron

  7. Hello,

    I am trying to make a barcode printer. I have a lot of records with barcodes which i can select in a form.

    Now when I click on the print butten after selecting the right printer, I want to have that barcode printed out instant.

    I can print at the moment but only in text, how do i change this to a barcode and if I need to make a label for myself where do I need to link this label with my VB code?

    Jon

  8. Can anyone please help me write a code to print 2 lines in a continuous roll?

    Sample Layout:

    Kei
    Ries

    I can’t figure out how to modify the example.

    • I am using dynamo LabelWriter 450 Twin Turbo in MS Access

      Thank you in advance for your help

    • Hi Kie,

      It is best to create the label you want to print in DLS and then reference the DLS file in your custom solution. That will be the easiest way for you to get your desired result.

      Regards,
      Ron

  9. A simple ask (I hope), I’m using VBA in Excel (very simple programming which suits the author who is no whizz at this!).

    I can select a cell and populate the clipboard but I cannot seem to find a way to programmatically press the Print Label button and let smart paste and the Dymo add-in do it’s thing and print me a label.

    Thanks in advance

    Steve

    • Hi Steve,

      Typically, when using EXCEL, it is beneficial to use our COM based SDK in VBA to get the functionality that you desire.

      Ron

  10. I am using access and setting the label to a form. The problem is how can I set the label size through VBA. I want it to always print on 30256 Shipping label.

    • Hi Dan,

      It is best to create a label file using DLS. This label file will include the necessary instructions to use 30256.
      Use this label file in your VBA code to update the appropriate label objects with the data you desire (using out interface) and then print the label using our interface.

      regards,
      Ron

  11. Is there any sample code for printing using VBA? I found the following online but I get an error on the line:
    Set myDymo = New DYMO_DLS_SDK.DymoHighLevelSDK

    The error I get is Automation error, Invalid pointer. Not a VBA programmer, so I am stumped. Any sample code exists for doing this? I couldn’t find any. Thanks.

    Sub TestLabel()

    Dim myDymo As DYMO_DLS_SDK.DymoHighLevelSDK
    Dim dyAddin As DYMO_DLS_SDK.ISDKDymoAddin
    Dim dyLabel As DYMO_DLS_SDK.ISDKDymoLabels

    Set myDymo = New DYMO_DLS_SDK.DymoHighLevelSDK

    Set dyAddin = myDymo.DymoAddIn
    Set dyLabel = myDymo.DymoLabels

    dyAddin.SelectPrinter dyAddin.GetDymoPrinters

    dyAddin.Open Environ$(“USERPROFILE”) & “\My Documents\DYMO Label\Labels\BoardFile.label”
    dyLabel.SetField “Text”, “My text goes here”
    dyAddin.Print2 1, True, 1

    Set myDymo = Nothing

    End Sub

    • Hi John,

      When coding with VMA you will need to use our COM interface… there are several samples using COM in the SDK install.

      Hope this helps,

      Ron

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)