debug this problem ' run-time error '91': object variable or with block variable not

[christine0207]

hi

Can anyone help to debug this problem?

the error msg is run-time error '91':
object variable or with block variable not set.

here is my source code:

Option Explicit
Private m_conOra As ADODB.Connection
Private m_conEXTT As ADODB.Connection
Private m_strStatus As String
Private m_strDate As String

Private Sub Form_Load()

Set m_conOra = ConnectMe ' Connect DataBase
Set m_conEXTT = Connect_EXTT ' Connect EXIT DataBase

Private Sub Form_Unload(Cancel As Integer)
m_conOra.Close
Set m_conOra = Nothing
m_conEXTT.Close
Set m_conEXTT = Nothing
End Sub

[Killer42]

Which line produces the error?

[scripto]

neither one of your databases were opened, so you will get an error when you call .Close()

[sashi]

Hi there,

Kindly refer to below attached link, hope it helps. Good luck & take care.

http://www.thescripts.com/forum/thread13693.html