• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2520
  • Last Modified:

ActiveX component can't create object, Dymo in VBA on Windows 7 x64

Hello,

I'm trying to use my Dymo LabelWriter Duo in Access 2007. I've tried to use  a few different code examples, but none have been successful so far, including the ones in the Dymo SDK. I would prefer to retain the usage of predefined labels. The examples in the SDK appear to have references for the predefined labels and the printer to the registry. Those are no longer valid in Windows 7, so I've fixed those parts.

The part that I'm hung up on is this part:

Set DymoAddIn = CreateObject("Dymo.DymoAddIn")
Set DymoLabels = CreateObject("Dymo.DymoLabels")

This doesn't appear to work, the error that is given is: ActiveX component can't create object

I've tried adding references to anything with the name Dymo, but with no change.

Thank you for your help
0
avirocks12345
Asked:
avirocks12345
  • 4
  • 3
  • 2
1 Solution
 
puppydogbuddyCommented:
If you have not done so already, try declaring your object variables globally as shown in the SDK at the following link:    http://www.dymo.com/media/UserGuides/AppNote2-OLEAccess.pdf

Option Compare Database ' Use database order for string comparisons.
Option Explicit ' Requires variables to be declared before they are used.
'Global declarations.
Public DymoAddIn As Object, DymoLabels As Object
0
 
Davis McCarnOwnerCommented:
Have you added Dymo to the Trusted Publishers in Access?
http://technet.microsoft.com/en-us/library/cc178948(office.12).aspx
0
 
avirocks12345Author Commented:
Thanks for the responses.

Puppy, I'm trying to get the example in the SDK working, so yes I have declared the variables globally.

Davis, I've attached the only digital signature I could find. What I would think would be the relevant dll files didn't seem to have digital signatures. In any case, I was under the impression that Access would warn you about a problem with the digital signatures and ask you to add them to the trusted publishers. No change with the added trusted publisher.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
puppydogbuddyCommented:
Have you registered your ActiveX wth Windows?
          See:  http://social.technet.microsoft.com/Forums/en/w7itproinstall/thread/e1465a28-9e18-448a-9bf8-51638bf2452d
0
 
avirocks12345Author Commented:
Ok, no change.
0
 
Davis McCarnOwnerCommented:
Hey; I want to back up a minute...
Do you mean a Labelwriter 450 DOU?
Is it Win7 x64?
And, It wouldn't install properly when you first installed the DYMO software?
0
 
avirocks12345Author Commented:
Thanks, it is a Dymo Labelwriter Duo. There is no number attached to this version, it's different from the 450. The model number is 93105. Am using Windows 7 Home premium, 64bit. I had no problems installing the Dymo software. The dymo software works great.
0
 
Davis McCarnOwnerCommented:
Why did you start with the predefined labels don't work?
Are you using V8.3 from December 2010? http://download.dymo.com/download%20drivers/LW/DLS8Setup.8.3.0.1242.exe
0
 
avirocks12345Author Commented:
Davis I love you. I was using version 8.1 and for some reason it didn't say that it needed an upgrade when I kept checking. For some strange reason it works perfectly with 8.3. How freaking bizarre. Thank you thank you thank you thank you!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now