To covert an access report with pictures to any editable document format retaining all the graphics and other formatting settings

Posted on 2007-10-10
Last Modified: 2008-02-20
I have a MS access report created with programming effort to dispaly several images with corresponding data from the database placed in appropriate postions on the report  to give the look of a poster.

THis needs to be sent to a vendor from time to time and should be something in editable document format.
What is the best way to acheive this retaining all the formatting settings.
As one could convert the access report to pdf or snapshot to retain the setting but these are not editable.
Please advise.
Question by:Jsara
    LVL 27

    Expert Comment

    Hi Jsara,

    Your best bet would be a MailMerge to Word,
    OR a Bookmark to Word.

    This link explains an important part of the process:


    Author Comment

    While using bookmark, say I have 6 pictures and data coming from single table, can I depending
    on the where clause be able to send data accordingly, like

    select * from temp where color = blue and picture assoicated to this  to go on the left side
    slect *  from temp where color = red and prority = 'Urgent' and the picture assoicated to right
    and so on to the bottom row etc.
    LVL 27

    Accepted Solution

    with bookmark, you assign control names in Word,
    then you decide from Access what goes to the controls in Word.

    So what you are trtying to do is possible, but with 1 value to each control in Word.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Introduction This tutorial provides instructions on how to properly format your Word document using the inbuilt tools provided. The benefits of using these tools means your documents are more accessible and easily portable to other applications an…
    Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now