Run-time error '91'

[Kandiman]

sorry, its me again... stuck. im getting the error:

Run-time error '91': Object Variable or With block variable not set




My code is:


Function LoginEntry(strXMLLoginDetails) As String

'VARIABLE DECLARATION
Dim objXMLDOM As MSXML2.DOMDocument 'xml dom object
Dim objDBConnection As ADODB.Connection 'db connection object
Dim objSearchRecordset As ADODB.Recordset 'recordset object to hold search results
Dim strDBPath As String 'this is the path of my access database
Dim strSQL As String 'string variable to hold my SQL statement
Dim strXMLResponse As String 'XML which will be returned to the front end
Dim strXMLResult As String 'XML which will return if anything is returned or not

'create a new DOM object
Set objXMLDOM = New MSXML2.DOMDocument

'load the xml into the DOM
objXMLDOM.loadXML strXMLLoginDetails

'create new DB connection
Set objDBConnection = New ADODB.Connection

'set the path of the access database
strDBPath = "C:\Inetpub\wwwroot\MyWeb\skooldays.mdb"

'open the database connection, using a connection string [Provider=###;Data Source=###]
objDBConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath

'build my SQL statement
strSQL = "SELECT Members.Name, Security.Password FROM Members INNER JOIN Security ON Members.Username = Security.Username WHERE (((Members.Username)='" & objXMLDOM.selectSingleNode("HXML/Username").Text & "') AND Security.Password)='" & objXMLDOM.selectSingleNode("HXML/Password").Text & "'));"



and the value of strXMLLoginDetails is:

<HXML><Username>sunny</Username><Password>password</Password><HXML>


can anyone see what i done wrong, im literally suicidal now... :(

[stepterr]

I've found this site to be helpful, maybe you will too. I'm wondering if that isn't your issue.