Object Variable not set , Run Time error 91, please Help 
Author Message
 Object Variable not set , Run Time error 91, please Help

Hi Guys,

I got this message when I try to call one of the function that I have in my
dll . I set all properties but when I call method I got this error , I set
reference to my dll .  here is my code

Private Sub Command1_Click()

Dim rs
Dim KB

Set Conn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
Set KB = CreateObject("KBAPP.KB_App")

Conn.ConnectionString = " Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Initial Catalog=KB_Test;Data
Source=zeus "
Conn.Open
With KB
    .ArtFormat = 1
    .ArtType = 2
    .BType = "All"
    .Cat = "All"
    .PubDate = 44
    .SearchBy = 1
    .SearchVal = "beef"
    .Seg = "All"
    .SessionID = "1270013200169142997V3P771I1SG3Z9FW66N1QK"
    .SubCat = "All"
    .SearchLogic = 1
End With

Set rs = KB.GetArt   ''' <<<------ I GOT THIS ERROR HERE

End Sub

Any suggestion ?

Thanks in advance,

Sam



Sat, 27 Sep 2003 00:36:54 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Run Time Error 91: Object variable or With Block variable not set

2. Object variable or With block variable not set (Error 91) Please Help

3. HELP : Error 91 : Run-Time Error 91 Object Variable or With

4. Run Time Error 91: Object Variable not set.....

5. Object variable or With block variable not set (Error 91)

6. error 91 Object Variable o on with block variable is not set

7. Runtime error 91/Object variable or With block variable not set problems

8. runtime error: 91 Object variable or with block variable not set

9. VB 5.0 - Error:91 Object Variable Or With Block Variable Not Set

10. Object variable or With block variable not set (Error 91)

11. Error 91 Object variable or With-Block, variable not set

12. Error 91 - Object Variable Not Set **** Need Help

 

 
Powered by phpBB® Forum Software