Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2004
    Location
    Bournemouth, Dorset, England
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    OLE Objects in Reports (again) (Access 97)

    Hello, after trying (unsuccessfully) to print an OLE object in my report I tried doing a mail merge from word using the query as my data source. All fields came out fine except for the OLE object (a word document) here it just printed "Long binary or text value" does any one know how I can get it to recognise it and print it in full?

    Thank you very much.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: OLE Objects in Reports (again) (Access 97)

    Mail merge cannot handle OLE fields. You would have to store the path + file name of the Word docs in a text field, and use an INCLUDETEXT field containing a MERGEFIELD field.

  3. #3
    New Lounger
    Join Date
    Jan 2004
    Location
    Bournemouth, Dorset, England
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OLE Objects in Reports (again) (Access 97)

    Hi, thanks for all your help on this. I'm going to be a pain now and ask for some more. I can put the file name and path in a text field (I'll change the OLE field to text and type it in) but can you give me a bit more explanation on this bit "INCLUDETEXT field containing a MERGEFIELD field" which I haven't come across before?

    Thank you very much. <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: OLE Objects in Reports (again) (Access 97)

    Say that you have a field named DocPath in your table, containing the complete path and file name of the documents.

    When you set up the mail merge in Word, select the Access database as data source, then the table (or a query) containing DocPath.

    In the document itself, click where you want to insert a document. Press Ctrl+F9 to insert a pair of field brackets { } (you must NOT type those yourself). Inside the brackets, type INCLUDETEXT, then a space, then two double quotes. It should now look like this:

    { INCLUDETEXT "" }

    Position the insertion point between the quotes. Press Ctrl+F9 to insert another pair of field brackets { }. Inside them, type MERGEFIELD "DocPath". It should now look like this:

    { INCLUDETEXT "{ MERGEFIELD "DocPath" }" }

    Press Alt+F9 to hide field codes. When you merge to a new document, the merge field will be replaced by the document path, and the INCLUDETEXT field will use this to insert the entire text of the document.

  5. #5
    New Lounger
    Join Date
    Jan 2004
    Location
    Bournemouth, Dorset, England
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OLE Objects in Reports (again) (Access 97)

    Thank you so much. You're a star <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> . I'll have a go at this tomorrow (when I'm allowed some database time between boring meetings).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •