L
Larry Kahm
I've inherited a task for which I need some help.
Client has an Access database that contains project information. The
original designer felt it was easy for everyone to use a Word template to
enter information. Of course, none of that is searchable - and the
marketing folks would like to be able to do just that.
So, one table contains a field defined as OLE object. In 97% of the cases,
this field contains a Word document. In the other cases, I've been unable to
determine just what the server object is.
Now, I've written the VBA code to parse the document to pull out the
necessary text - so that I can place it into separate fields.
Questions:
1. How should I code the section that loops through the recordset to launch
the OLE object? I'm concerned that if it isn't Word, it is going to error
out badly.
2. Once I get the values from the document, I am going to assume I should
use the update method to include these fields in the current row.
Thanks, in advance, for any suggestions.
Larry
Client has an Access database that contains project information. The
original designer felt it was easy for everyone to use a Word template to
enter information. Of course, none of that is searchable - and the
marketing folks would like to be able to do just that.
So, one table contains a field defined as OLE object. In 97% of the cases,
this field contains a Word document. In the other cases, I've been unable to
determine just what the server object is.
Now, I've written the VBA code to parse the document to pull out the
necessary text - so that I can place it into separate fields.
Questions:
1. How should I code the section that loops through the recordset to launch
the OLE object? I'm concerned that if it isn't Word, it is going to error
out badly.
2. Once I get the values from the document, I am going to assume I should
use the update method to include these fields in the current row.
Thanks, in advance, for any suggestions.
Larry