Search results

It works! Thanks a bunch! :) Anything I can do to repay the favor?

I have highlighted the line in red. Looks like I am missing some code that identifies the second table that I want to pull data into. Sub GetWordData() Dim appWord As Word.Application Dim doc As Word.Document Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim strDocName As...

Hi SOS, I removed the **, but i am still receiving this error, "3705: Operation is not allowed when the object is open" The only file open is the mdb. Sub GetWordData() Dim appWord As Word.Application Dim doc As Word.Document Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset...

I get a Compile error: Syntax error Sub GetWordData() Dim appWord As Word.Application Dim doc As Word.Document Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim strDocName As String Dim blnQuitWord As Boolean On Error GoTo ErrorHandling strDocName = "C:\Documents and...

typo :o sorry :)

Made the change (code below), but still getting the error "3705: Operation is not allowed when the object is open" The only file open is the mdb. I really appreciate your help! Sub GetWordData() Dim appWord As Word.Application Dim doc As Word.Document Dim cnn As New ADODB.Connection Dim...

Sorry about that.. Here's the code I am working with now. I am attempting to pull in data from one word doc into 2 different access tables (tblContracts & tblSecurity), which are both located in the same db. I am receiving the following error.. "3705: Operation is not allowed when the object...

Hello, I have code that will allow me to import data directly from Word into Access, but I am also looking for code that will allow me to import data directly from InfoPath into Access. Below is the code that imports from Word. Any idea on how to update this code to reference the same...

Thanks! The code is being run from the HealthCare Contract.mdb and I updated the code, but then I receive the following error msg. "3704:Operation is not allowed when the object is closed" When the original code is left in the script, it runs without error. Thoughts?

Hello, Can InfoPath be used in place of Word in this example? I have created a InfoPath form that mirrors the Word Form, but now I am not sure on how to update the code. Please advise :o http://msdn.microsoft.com/en-us/library/aa155434(office.10).aspx Sub GetWordData() Dim appInfoPath As...

Hello, I was able to resolve the error, which occurred because Outlook was open and I had a draft email in Word. Thanks for looking into it though. Have a nice day. :)

Here's the link and code. The word document was also closed when I ran the code. Thanks again! http://msdn.microsoft.com/en-us/library/aa155434(office.10).aspx Sub GetWordData() Dim appWord As Word.Application Dim doc As Word.Document Dim cnn As New ADODB.Connection Dim rst As New...

Hello, I have followed the msdn Healthcare example on importing data from word into an access table (link below). However, when I run the code, i get the following error.. -2147467259: Could not use" ; file already in use. The only difference in the code is the folder location and the mdb...