Results 1 to 4 of 4
  1. #1
    GCS is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2011
    Location
    Swartz Creek, MI
    Posts
    10

    Exporting Images to Word

    Hello....



    I am a novice and self taught Access database builder and have created a database for my children's Christian school auction. I have a table of auction lots that I need to merge with a Word file to create a promotional card for each lot up for bid.

    Problem: How do I export the image of the lot into a Word merge document? I have a field to attach the image and the image shows up in the form for the table, but when I tried all I got was the name of the file.btmp.

    Like I said...I'm a novice.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Recently worked with other posters who wanted to update an attachment field in a table with entries from an attachment field in another table. Couldn't be done. This leads me to believe the attached image cannot be passed to Word. If the images were stored externally then the name could be saved in a field in table and name passed to Word and then code in Word could load the image.

    Couldn't this promotional card be built as a report in Access?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    GCS is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2011
    Location
    Swartz Creek, MI
    Posts
    10
    Yes! I can't believe that I didn't think to do it as a report. I went straight to Word merge because that's what I'm used to doing. I just designed the PR card as an Access report and the images are printing great! Thanks!

    I've never designed a report before, so now I am working on how to make it date sensative...only print a card for records with a specific entry date.

    I really appreciate your help....so do the kids at the school.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Printing for a specific date or any other value you wish just requires applying filter criteria. There are a number of ways to accomplish this.

    The simplest is to have a query as the report's RecordSource and type into the query criteria row the exact values you want to filter on. Next is to use input parameter prompts set in the report Filter property or in a query as the report RecordSource. Anything else requires use of forms and/or code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access to Word - Multiple Word Templates?
    By alpinegroove in forum Programming
    Replies: 11
    Last Post: 06-12-2012, 04:42 PM
  2. Linking to images
    By Mclaren in forum Forms
    Replies: 2
    Last Post: 06-07-2011, 12:08 PM
  3. Exporting Report to a word file or PDF or whatever
    By AccessDatabaseGuy in forum Access
    Replies: 1
    Last Post: 05-03-2011, 02:03 PM
  4. Exporting Memo field Data to Word document
    By samlennox in forum Programming
    Replies: 2
    Last Post: 04-25-2011, 11:57 PM
  5. Replies: 17
    Last Post: 08-26-2009, 11:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums