K
Keith G Hicks
Access 2003 (2000 format)
I've done quite a bit of Word automation from Access to build forms for
clients but I'm stumped. I'm trying to dynamically build a table of
signatures at the bottom of a document. The signatures are stored in a table
in Access in an OLE Object type field. I created a single row table in the
form with a bookmark in the first cell (I've done this type of thing before
using objWord.Selection.MoveRight Unit:=wdCell and it works fine for
creating tables of info in a Word doc from Access). But I need to get the
signatures into the cells and not just text.
I've tried this:
Set rngWord = docWord.Goto(what:=wdGoToBookmark, Name:="FirstSignature")
rngWord.InsertAfter rs!Signature
The code runs but it pastes the long string of unintelligable garbage that
is the textual interpretation of the signature into the cell.
I'm really not sure how to handle this. If anyone can help I'd really
appreciate it.
Thanks,
Keith
I've done quite a bit of Word automation from Access to build forms for
clients but I'm stumped. I'm trying to dynamically build a table of
signatures at the bottom of a document. The signatures are stored in a table
in Access in an OLE Object type field. I created a single row table in the
form with a bookmark in the first cell (I've done this type of thing before
using objWord.Selection.MoveRight Unit:=wdCell and it works fine for
creating tables of info in a Word doc from Access). But I need to get the
signatures into the cells and not just text.
I've tried this:
Set rngWord = docWord.Goto(what:=wdGoToBookmark, Name:="FirstSignature")
rngWord.InsertAfter rs!Signature
The code runs but it pastes the long string of unintelligable garbage that
is the textual interpretation of the signature into the cell.
I'm really not sure how to handle this. If anyone can help I'd really
appreciate it.
Thanks,
Keith