Pass Recordset as param 
Author Message
 Pass Recordset as param

I have the following procedure:

Public Sub CloseTable(ByRef rs As Recordset) 'rs is for Recordset
    If Not (rs Is Nothing) Then
        rs.Close
        Set rs = Nothing
    End If
End Sub

However, when I try to call it with this:
    PSADO.CloseTable (tblRM_Customer_MSTR)

I get a type mismatch!

Any ideas? PLEASE HELP!  Thanks.
Bryce

Sent via Deja.com http://www.*-*-*.com/
Before you buy.



Tue, 19 Mar 2002 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Passing param from vb to macro

2. Pass param to Office Web Component

3. Passing function param to server side???

4. QBASIC: passing array as param to procedure

5. VAX BASIC pass param. solution

6. pass in Param to Crystal report from vb

7. passing param data in html to activex

8. Passing form AND control as param

9. Passing form AND control as param

10. PASSING FORM AND CONTROL AS PARAM

11. Passing <PARAM>'s to controls from HTML

12. pass PARAM from HTML to VB5 Control

 

 
Powered by phpBB® Forum Software