Hi,
I've looked thought the forums to see if I can get help with this but no luck so far.
Basically I have got some code that will take data from a word form although it wont run even though it appears correct. From what I can see I presume I didn't have the correct references enabled, but from what I've read I have. Currently I have the below references turned on.
Visual Basic for application
M/S Access 11.0 Object Library
M/S Word 11.0 Object Library
M/S DAO 3.6 Object Library
The code is basically
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....ect ect
It is the blue bit that it is falling over. Can anyone help I presume it is simple but I just cant get it to work...The error I'm get is User-defined type not defined
I've looked thought the forums to see if I can get help with this but no luck so far.
Basically I have got some code that will take data from a word form although it wont run even though it appears correct. From what I can see I presume I didn't have the correct references enabled, but from what I've read I have. Currently I have the below references turned on.
Visual Basic for application
M/S Access 11.0 Object Library
M/S Word 11.0 Object Library
M/S DAO 3.6 Object Library
The code is basically
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....ect ect
It is the blue bit that it is falling over. Can anyone help I presume it is simple but I just cant get it to work...The error I'm get is User-defined type not defined