Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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
3
Medium Priority
?
312 Views
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.
0
Comment
Question by:Jsara
  • 2
3 Comments
 
LVL 27

Expert Comment

by:jjafferr
ID: 20051414
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:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21364610.html

jaffer
0
 

Author Comment

by:Jsara
ID: 20056381
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.
0
 
LVL 27

Accepted Solution

by:
jjafferr earned 2000 total points
ID: 20058378
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.

jaffer
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

810 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