object variable or with block not set...HELP!!

[gilly]

Ive got an error in my vb module saying:

"object variable or with block not set"

What does this mean??heres my code below:

Public Sub Fetch_GeneralAdmin()

Dim objFetch_GeneralAdmin As New DCGeneraladmin.DcGeneralAdminClass, mysql As String

Dim rs As New ADODB.Recordset
Set rs = objFetch_GeneralAdmin.Fetch_GeneralAdmin
On Error Resume Next
g_objSC.Response.Write "<TABLE><TR><TH>General Admin</TH></TR>" & vbCrLf

rs.Open

g_objSC.Response.Write "<TR><TD>Claim Date Range</TD><TD><input type=text id=txtclaimdaterange name=txtclaimdaterange maxlength=20 value=" & rs.Fields("claimdaterange") & "></TD></TR>" & vbCrLf

g_objSC.Response.Write "</TABLE>"
rs.Close
Set rs = Nothing
Set objFetch_GeneralAdmin = Nothing
Err = 0
End Sub

[Lafor]

Ive got an error in my vb module saying:

"object variable or with block not set"

What does this mean??heres my code below:

Public Sub Fetch_GeneralAdmin()

Dim objFetch_GeneralAdmin As New DCGeneraladmin.DcGeneralAdminClass, mysql As String

Dim rs As New ADODB.Recordset
Set rs = objFetch_GeneralAdmin.Fetch_GeneralAdmin

'I am sure you've taken care of this... But I will just
'ask a couple of questions
1. The method you're invoking
Fetch_GeneralAdmin

returns an ADODB recordset... right?
Are you re returning to this? or is it dying inside
the method?

If it is returning set a break point on the line
Set Rs = .....

and look at rs

In any case, I'd check the method....

Post it, if u can
Another set of eyes could help

Take care...



On Error Resume Next
g_objSC.Response.Write "<TABLE><TR><TH>General Admin</TH></TR>" & vbCrLf

rs.Open

g_objSC.Response.Write "<TR><TD>Claim Date Range</TD><TD><input type=text id=txtclaimdaterange name=txtclaimdaterange maxlength=20 value=" & rs.Fields("claimdaterange") & "></TD></TR>" & vbCrLf

g_objSC.Response.Write "</TABLE>"
rs.Close
Set rs = Nothing
Set objFetch_GeneralAdmin = Nothing
Err = 0
End Sub

[kedaman]

"object variable or with block not set"
means probably in this case that you're trying to access an object using a object reference that contains nothing.

You may have used set to set the object but that doesn't mean it's set, if the object you've set it to is nothing.

Now you could check this by typing
[ode]
If thatobject is nothing then 'oh that object is nothing!! don't try to access it.
else
'access it
thatobject.dowhatever
end if
[/code]