"E. Kwong" <ekwong999AThotmail.com> wrote in message news:eeNEd3rEJHA.4260@TK2MSFTNGP06.phx.gbl... I'm trying to extract the field names of a one-row table but keep gettning "Error 91 : Object variable or With block variable not set". The code snippet: Dim rst As DAO.Recordset Dim f As DAO.Field On Error GoTo GetFieldNames_Err Set rst = CurrentDb.OpenRecordset
btw: can't you get a reference to the original document via the first node of the node list ? "hon123456" <peterhon321@yahoo.com.hk> wrote in message news:a900dfe8-223a-4118-94c3-a3d722dbb8f6@l28g2000prd.googlegroups.com... On 6$B7n(B4$BF|(B, $B>e8a(B11$B;~(B37$BJ,(B, "Bill McCarthy" <B...@N0SPAM.com> wrote: The element loaded is not a complete element. Try:
The element loaded is not a complete element. Try: doc.LoadXml "<" & elemName & " />" "hon123456" <peterhon321@yahoo.com.hk> wrote in message news:07be460f-b040-41ea-b20b-5585e7588b0d@g16g2000pri.googlegroups.com... Dear all, I have the following code: Private Function MakeDoc(nl As IXMLDOMNodeList, elemName As String) As DOMDocument40 Dim doc As New
Dear all, I have the following code: Private Function MakeDoc(nl As IXMLDOMNodeList, elemName As String) As DOMDocument40 Dim doc As New MSXML2.DOMDocument doc.LoadXml "<" & elemName & ">" Dim n As IXMLDOMNode For Each n In nl Select Case n.nodeType Case NODE_ATTRIBUTE doc.documentElement.setAttribute n.nodeName, n.nodeValue
I have a form (frmDiscs) which can be opened from several other forms. In this particular case, it is called from a button on frmVocalArrangements. On closing frmDiscs and after updating its subform (frmDiscsSubform), I want to return to frmVocalArrangments at the updated record. To achieve this I put theis code in the load event of frmDiscSubform: Private Sub Form_Load() Dim frmCalling