pasting picture from Access to Word

D

DrEvil

Good evening,
I'm finishing development of database that exports data to bookmarked fields
including signature ole field in word (2003) then converts word documents to
pdf and mail pdf's via outlook to multitude of set recipients as well as
variable recipient. My problem is with copy and paste of signature (user
selects one of many judge signatures to approve adult/child abuse protection
order) which are stored in table and displayed in combo box. My current
procedure worked on older laptops and desktops and before I added email and
pdf procedure although i don't think that is the issue at this time since vba
code for them is below code in question.
Here is the current procedure for exporting picture;
DoCmd.GoToControl "pic"
DoCmd.RunCommand acCmdCopy
..ActiveDocument.Bookmarks("picture").Select
..Selection.Paste
this now throws 5097 error "there is insufficient memory" and everything
stops.
I tried using
..ActiveDocument.Bookmarks("picture").Select
..Selection.Text = (CStr(Forms!frmExParteOrder!Pic))
and this code will run just fine but picture looks like bunch of characters
(Japanese and God knows what else) instead of picture/signature.

In addition to this picture I export few dozen other text fields and that
all works well, again picture paste worked too but now doesn't, I even tried
2nd computer with office 2003 with same error.
I need some help as everything else is done but this is stopping me to put
this database to good use.
There cannot be shortage of memory on my computer as I have 4 GB of RAM.

Thanks in advance!

Amir
 
D

DrEvil

I found out that pasting works just fine under Office 97 but not under Office
2003 and Office 2007.. pretty strange. No missing references or anything like
that.
Can anyone give me assistance with maybe using InlineShapes in my case since
this;
DoCmd.GoToControl "pic"
DoCmd.RunCommand acCmdCopy
..ActiveDocument.Bookmarks("picture").Select
..Selection.Paste

doesn't work.

Thanks

Amir
 

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