How do I insert best quality Access report into Publisher?
Spinbud
want to include as part of the Publisher booklet. I have tried creating a PDF
and selecting and some other methods but the quality is not nearly as good
when copied and pasted into Publisher. Any ideas on how to take an Access
report and copy/paste or insert into Publisher where there is very high
quality?
Thanks
Mary Sauer
In Publisher, create a text box, right-click, click change text, click text
file, browse to the report.
--
Mary Sauer
http://msauer.mvps.org/
"Spinbud" <Spi...@discussions.microsoft.com> wrote in message
news:9AA1F48C-75A0-43F2...@microsoft.com...
Spinbud
Thank you. I did exactly as you said it it worked, the print is now much
better. The only problem is the data overflows the text box. I can place in a
table and manipulate, but I would like to not have to do that. Any ideas on
how I can get the Access report to fit format almost exactly like it is in
Access? I know a picture will do the job, but the quality is not there. Your
solution is perfect to get the printing crisp, any ideas to make the job less
cumbersome when inserting the report?
Many thanks for your help,
Mike
Spinbud
Thanks,
Mike
Mary Sauer
format.
You also can create another text box and link them so the text flows. You also
can use the *continued on page....*(format text box, text box tab).
--
Mary Sauer
http://msauer.mvps.org/
"Spinbud" <Spi...@discussions.microsoft.com> wrote in message
news:87243027-0B3F-4A3D...@microsoft.com...
Spinbud
simply copy and past that it would print crisply. This way I have the exact
document formatted already. I easily copy and paste a picture but the
crsipness is just not there. The other methods will require formatiing in
Publisher to make it look right. Many thanks for your help.
JoAnn Paules
version of the Access report in the .pdf version of the Publisher document?
--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Spinbud" <Spi...@discussions.microsoft.com> wrote in message
news:8F357035-A747-4E29...@microsoft.com...
Spinbud
but I could just create a PDF of the Publisher report and then creat numerous
PDF files from Access reports. If I insert one of these Access PDFs as a PDF
in the primary PDF will I be able to have the proper page numbers noted so
the report is seamless?
Many thanks for your help!
Mike
Mary Sauer
process. Use the keyword combining.
--
Mary Sauer
http://msauer.mvps.org/
"Spinbud" <Spi...@discussions.microsoft.com> wrote in message
news:63AF9BE8-E704-4B7E...@microsoft.com...
Spinbud
not be creating a PDF since I am merging in about 100 company names into the
Publisher document.
I have tried the 'Universal Document Converter' that creates my Access pages
into a TIFF. This seems to work pretty well. I tried JPEG but it is not as
crisp. This way I just paste it onto the page in Publisher as-as. Do you know
of any other vendor where I can create the TIFF/JPEG/etc. that will be most
clear when inserting into Publisher?
Many, many thanks for your help!
Spinbud
How do I get brackets around negative numbers in my Access reports? It is
easy with currency but I cannot figure out how to do it with non-currency
numbers.
Any help would be greatly appreciated.
Thanks
Mary Sauer
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.access&cat=en_US_973e53c3-c10e-4523-9213-cdfd537838f1&lang=en&cr=US
--
Mary Sauer
http://msauer.mvps.org/
"Spinbud" <Spi...@discussions.microsoft.com> wrote in message
news:01C3762C-F18A-4ACD...@microsoft.com...
JoAnn Paules
the report goes in after page 5, start the new section at that point and
change the page numbering to reflect the new page number. You do that for
each place where you want to insert a report.. It'll be a bit of a hassle
but nothing major. I'm not real sure how you can tell Access to put a page
number on the report but *maybe* that could be omitted.
I don't know which program you'll be using to create your .pdf files but
Acrobat makes assembling .pdf files easy. PrimoPDF can also do it but not
nearly as simply as Acrobat. Hey, what can you expect from a free program?
(I'm just tickled I can append files now.)
--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Spinbud" <Spi...@discussions.microsoft.com> wrote in message
news:63AF9BE8-E704-4B7E...@microsoft.com...
JoAnn Paules
work. They want a database, I start to work on it, learning as I go along,
and then they opt to go another route and no longer need the work I've done.
<sigh>
--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Spinbud" <Spi...@discussions.microsoft.com> wrote in message
news:01C3762C-F18A-4ACD...@microsoft.com...
Ed Bennett
> I have tried the 'Universal Document Converter' that creates my Access pages
> into a TIFF. This seems to work pretty well. I tried JPEG but it is not as
> crisp. This way I just paste it onto the page in Publisher as-as. Do you know
> of any other vendor where I can create the TIFF/JPEG/etc. that will be most
> clear when inserting into Publisher?
TIFF is generally a better choice than JPEG for simple images; PNG would
probably give a smaller filesize.
If you can generate a PDF from Access, then you can convert it to a PNG
using the instructions at
http://ed.mvps.org/Static.aspx?=Publisher/convertpdf
--
Ed Bennett - MVP Microsoft Publisher
http://ed.mvps.org
thomaskimberly
and sorting manually) would be a nightmare, though I will need to edit within Publisher.
1) I have no idea how to import the data into Publisher pages. except copy/paste manually from an rtf file... slow, mistake-prone, etc.
2) A second issue, Access can't seem to show linked photos in reports or queries except using bmp format. ???
Ed Bennett wrote:
Re: How do I insert best quality Access report into Publisher?
16-Sep-08
Spinbud wrote:
TIFF is generally a better choice than JPEG for simple images; PNG would
probably give a smaller filesize.
If you can generate a PDF from Access, then you can convert it to a PNG
using the instructions at
http://ed.mvps.org/Static.aspx?=Publisher/convertpdf
--
Ed Bennett - MVP Microsoft Publisher
http://ed.mvps.org
Previous Posts In This Thread:
On Wednesday, September 10, 2008 12:03 PM
Spinbu wrote:
How do I insert best quality Access report into Publisher?
I am creating a booklet in Publisher 2003. I have many Access reports that I
want to include as part of the Publisher booklet. I have tried creating a PDF
and selecting and some other methods but the quality is not nearly as good
when copied and pasted into Publisher. Any ideas on how to take an Access
report and copy/paste or insert into Publisher where there is very high
quality?
Thanks
On Wednesday, September 10, 2008 12:32 PM
Mary Sauer wrote:
Right-click the report in Access, export, save as .rtf or .txt.
Right-click the report in Access, export, save as .rtf or .txt.
In Publisher, create a text box, right-click, click change text, click text
file, browse to the report.
--
Mary Sauer
http://msauer.mvps.org/
"Spinbud" <Spi...@discussions.microsoft.com> wrote in message
news:9AA1F48C-75A0-43F2...@microsoft.com...
On Wednesday, September 10, 2008 1:24 PM
Spinbu wrote:
Mary,Thank you.
Mary,
Thank you. I did exactly as you said it it worked, the print is now much
better. The only problem is the data overflows the text box. I can place in a
table and manipulate, but I would like to not have to do that. Any ideas on
how I can get the Access report to fit format almost exactly like it is in
Access? I know a picture will do the job, but the quality is not there. Your
solution is perfect to get the printing crisp, any ideas to make the job less
cumbersome when inserting the report?
Many thanks for your help,
Mike
"Mary Sauer" wrote:
On Wednesday, September 10, 2008 1:31 PM
Spinbu wrote:
Mary, I have 9 columns in the access database that may present a problem.
Mary, I have 9 columns in the access database that may present a problem.
Thanks,
Mike
"Spinbud" wrote:
On Wednesday, September 10, 2008 2:21 PM
Mary Sauer wrote:
There are tricks you can use to span two pages with your table in a booklet
There are tricks you can use to span two pages with your table in a booklet
format.
You also can create another text box and link them so the text flows. You also
can use the *continued on page....*(format text box, text box tab).
--
Mary Sauer
http://msauer.mvps.org/
"Spinbud" <Spi...@discussions.microsoft.com> wrote in message
news:87243027-0B3F-4A3D...@microsoft.com...
On Wednesday, September 10, 2008 2:33 PM
Spinbu wrote:
Thanks. I guess I am just lazy.
Thanks. I guess I am just lazy. I wish that when you create a PDF and then
simply copy and past that it would print crisply. This way I have the exact
document formatted already. I easily copy and paste a picture but the
crsipness is just not there. The other methods will require formatiing in
Publisher to make it look right. Many thanks for your help.
"Mary Sauer" wrote:
On Wednesday, September 10, 2008 5:55 PM
JoAnn Paules wrote:
If your final product is going to be a .pdf file, why not insert the .
If your final product is going to be a .pdf file, why not insert the .pdf
version of the Access report in the .pdf version of the Publisher document?
--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Spinbud" <Spi...@discussions.microsoft.com> wrote in message
news:8F357035-A747-4E29...@microsoft.com...
On Wednesday, September 10, 2008 8:41 PM
Spinbu wrote:
That is a very good idea.
That is a very good idea. I was planning to print the report from Publisher
but I could just create a PDF of the Publisher report and then creat numerous
PDF files from Access reports. If I insert one of these Access PDFs as a PDF
in the primary PDF will I be able to have the proper page numbers noted so
the report is seamless?
Many thanks for your help!
Mike
On Thursday, September 11, 2008 11:48 AM
Mary Sauer wrote:
There is a complete help dialogue within Acrobat that will walk you through
There is a complete help dialogue within Acrobat that will walk you through the
process. Use the keyword combining.
--
Mary Sauer
http://msauer.mvps.org/
On Thursday, September 11, 2008 12:56 PM
Spinbu wrote:
Thank you. I cannot believe how helpful everyone is.
Thank you. I cannot believe how helpful everyone is. Unfortunately, I will
not be creating a PDF since I am merging in about 100 company names into the
Publisher document.
I have tried the 'Universal Document Converter' that creates my Access pages
into a TIFF. This seems to work pretty well. I tried JPEG but it is not as
crisp. This way I just paste it onto the page in Publisher as-as. Do you know
of any other vendor where I can create the TIFF/JPEG/etc. that will be most
clear when inserting into Publisher?
Many, many thanks for your help!
"Mary Sauer" wrote:
On Thursday, September 11, 2008 5:23 PM
Spinbu wrote:
I have another quick question.
I have another quick question.
How do I get brackets around negative numbers in my Access reports? It is
easy with currency but I cannot figure out how to do it with non-currency
numbers.
Any help would be greatly appreciated.
Thanks
"Spinbud" wrote:
On Thursday, September 11, 2008 6:48 PM
Mary Sauer wrote:
Re: How do I insert best quality Access report into Publisher?
You will be better served asking this in an Access newsgroup.
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.access&cat=en_US_973e53c3-c10e-4523-9213-cdfd537838f1&lang=en&cr=US
--
Mary Sauer
http://msauer.mvps.org/
"Spinbud" <Spi...@discussions.microsoft.com> wrote in message
news:01C3762C-F18A-4ACD...@microsoft.com...
On Thursday, September 11, 2008 7:03 PM
JoAnn Paules wrote:
Yes, create a new section at the point where you want to insert the .pdf.
Yes, create a new section at the point where you want to insert the .pdf. If
the report goes in after page 5, start the new section at that point and
change the page numbering to reflect the new page number. You do that for
each place where you want to insert a report.. It'll be a bit of a hassle
but nothing major. I'm not real sure how you can tell Access to put a page
number on the report but *maybe* that could be omitted.
I don't know which program you'll be using to create your .pdf files but
Acrobat makes assembling .pdf files easy. PrimoPDF can also do it but not
nearly as simply as Acrobat. Hey, what can you expect from a free program?
(I'm just tickled I can append files now.)
--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Spinbud" <Spi...@discussions.microsoft.com> wrote in message
news:63AF9BE8-E704-4B7E...@microsoft.com...
On Thursday, September 11, 2008 7:04 PM
JoAnn Paules wrote:
You have my sympathy workign with Access. I've been struggling with it at work.
You have my sympathy workign with Access. I've been struggling with it at
work. They want a database, I start to work on it, learning as I go along,
and then they opt to go another route and no longer need the work I've done.
<sigh>
--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Spinbud" <Spi...@discussions.microsoft.com> wrote in message
news:01C3762C-F18A-4ACD...@microsoft.com...
On Tuesday, September 16, 2008 1:03 PM
Ed Bennett wrote:
Re: How do I insert best quality Access report into Publisher?
Spinbud wrote:
TIFF is generally a better choice than JPEG for simple images; PNG would
probably give a smaller filesize.
If you can generate a PDF from Access, then you can convert it to a PNG
using the instructions at
http://ed.mvps.org/Static.aspx?=Publisher/convertpdf
--
Ed Bennett - MVP Microsoft Publisher
http://ed.mvps.org
EggHeadCafe - Software Developer Portal of Choice
Generics: Constraints, IComparable, and IEnumerable
http://www.eggheadcafe.com/tutorials/aspnet/7c431a9f-8cbd-4f5c-8397-9c412a25b257/generics-constraints-ic.aspx
Mary Sauer
If you are using 2003 or 07 what you are describing is the catalog merge. Help
here:
Create a catalog merge
http://office.microsoft.com/en-us/publisher/HP101921831033.aspx
I have found in my experience the catalog merge works best when all the elements
are in a common folder. If your pictures are in the same folder as your data
base there is no need to type the path, for example type bird.jpg in the picture
field instead of C:\Users\<<user name>>\Pictures\bird.jpg.
When you are finished inserting all your fields you can create a new publication
in step 3 or step 5 depending on your version, this publication can be edited.
--
Mary Sauer
http://msauer.mvps.org/
"Thomas Kimberly" wrote in message news:200911720...@concast.net...