PC Review


Reply
Thread Tools Rate Thread

Access table with OLE Word doc - convert to fields in table

 
 
Larry Kahm
Guest
Posts: n/a
 
      21st Jan 2007
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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
export/convert an Access table to Word =?Utf-8?B?anRoaG91c2luZw==?= Microsoft Access 2 27th Feb 2006 07:45 PM
Import Word Form-Fields into and Access Table Marsela Microsoft Access VBA Modules 2 16th Mar 2005 03:32 PM
Adding Fields To A Word Table From MS Access Tony C Microsoft Access VBA Modules 1 15th Jul 2004 04:12 PM
Import Fields from Word Table into access record Gordzilla Microsoft Access 1 17th Jun 2004 06:45 PM
Import Fields from Word Table in access record Gordzilla Microsoft Access VBA Modules 0 12th Jun 2004 05:04 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:37 PM.