Object variable or With block variable not set

[rmtiptoes]

Please help. I am trying to print a barcode by calling a barcode application and printing the number thru a test label formated for a Zebra printer. I have read the docs and continue to get the "Object variable or With block variable not set" error when I open the form. The application is getting called but it failes at the "Set MyDoc" line. What am I doing wrong? I have tried this two ways (actually 5,000 ways but I've narrowed it down)

First Way
Option Compare Database

Dim MyApp As Object
Dim MyDoc As Object

Private Sub Form_Load()
Set MyApp = New LabelManager2.Application
Set MyDoc = MyDoc.Documents.Add("My Documents\Mylan Documents\test.lab")
MyApp.EnableEvents = True

End Sub


Second Way
Option Compare Database

Dim MyApp As Object
Dim MyDoc As Object

Private Sub Form_Load()
Set MyApp = New LabelManager2.Application
Set MyDoc = MyDoc.Documents.Add("My Documents\Mylan Documents\test.lab")
MyApp.EnableEvents = True

End Sub

 

[HarleyQuinn]

Could it be:

Set MyDoc = [red]MyApp[/red].Documents.Add("My Documents\Mylan Documents\test.lab")

Hope this helps


Harleyquinn

---------------------------------
For tsunami relief donations

 

[rmtiptoes]

Thank you for your quick response. Unfortunately, that did not work. I received the same error at that protion of the code. Anything else?

Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive?
Marge Simpson: That's because you were drunk!
Homer: And how.

 

[rmtiptoes]

Sorry. That DID work!!! Thanks a million!!!!

Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive?
Marge Simpson: That's because you were drunk!
Homer: And how.

 

[HarleyQuinn]

Glad I could help.

Harleyquinn

---------------------------------
For tsunami relief donations