5 replies
by sl-campbell
The only way I know how to do this is to create a form and put a OLE control on it.
Create a DataControl using the table and Ole field as the source. Set the DataSource of the OLE control to the DataControl and the OLE DataField the the OLE field name.
Now, use a loop to go through all the records. At each record, check the OLE controls' SourceDoc setting a variable to it, parse it seperating the path from the file name, add the new path to the file name, and set it back to the SourceDoc and then update the record and move to the next record.
Because the OLE control is bound and the SourceDoc was change, the Jet updates the record with the needed change that is otherwise hidden from viewers of the tables.
Any more questions then send me a comment.
Hope you get it to work!
by jammin
by jammin
by jammin
by jammin
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending