OLE or Image, Bound or Unbound?

R

Robin

I have a Word Doc 2003, 1/2 page, that I would like to show on a form and
report. I like the idea of the users being able to edit the info on the form
from time to time, but they can edit the file itself if that's recommended as
the users will have Word available on their machines. I've tried so many
different combinations I can't even remember which combinations did what. Is
there a "right" way to do this that I've certainly missed?

My current best guess is an Unbound OLE box, linked rather than embeded.
But I can never seem to get the changes made on the form appear on the
report, tried the Report format event.

Me!OLEObject1.sourcedoc = Me!ImagePath
or
Me!OLEObject1.sourcedoc = [ImagePath]
or
Me!OLEObject1.sourcedoc = "[ImagePath]"
or
Me!OLEObject1.sourcedoc = "C:\ImagePath\Image.doc"

I either get varying errors or nothing shows on the report, If I link or
embed the file on the report initially, it never changes.

I've tried dozens of other threads trying to decipher my shortfalls but no
luck. Any help or suggestions is appreciated.

Thanks,
Robin
 
R

Robin

Ok, I got this far. OleUnbound Frame, linked file, enabled, not locked(on
form) for both the report and form.

Secret seems to be linking to the same MyTest.Doc from file at the
OleUnbound Frame creation wizard. Which lists the correct MyTest.Doc in
SourceDoc property. Changing this after the OLE control has been created has
no effect unless it is edited from "inside" Access on the form which appears
to work under runtime simulation. I can also replace the contents externally
with Word as long as I save the file with the same as MyTest.Doc.

I don't seem to be allowed to change the SourceDoc property through events,
even in the report format event, to say MyNew.Doc and have the information
displayed of a different file. Is this the end of the possible capabilities?

Any insight is always appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top