468,301 Members | 1,532 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,301 developers. It's quick & easy.

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

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
Nov 1 '06 #1
3 3922
Killer42
8,434 Expert 8TB
Which line produces the error?
Nov 1 '06 #2
scripto
143 100+
neither one of your databases were opened, so you will get an error when you call .Close()
Nov 1 '06 #3
sashi
1,754 Expert 1GB
Hi there,

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

http://www.thescripts.com/forum/thread13693.html
Nov 1 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Keld Hammerum | last post: by
9 posts views Thread by Robert Ferrell | last post: by
2 posts views Thread by Philip | last post: by
10 posts views Thread by Bhavna Rohra | last post: by
1 post views Thread by Sam Kong | last post: by
6 posts views Thread by Luis Esteban Valencia | last post: by
3 posts views Thread by Rena | last post: by
4 posts views Thread by herc | last post: by
3 posts views Thread by =?Utf-8?B?bG10dGFn?= | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.