I'm doing a booklet for a class reunion. Got all the data and everybody's life
history in a little MS Access app and now it's time to get the booklet ready to
go to the printer's.
I have a report that creates same, but rather than send it to a printer of PDF
file, I'd prefer to get it into MS Word, PageMaker, or some other document
editor. Reason: some people have sent in pictures, and I'd like to flow the
text around their pix.
I've considered exporting to an MS Word mail-merge, but there's so much
contitional formatting in the report (mainly, if somebody is deceased, various
fields become invisible and an obituary takes over the whole space) that I'd
probably have to go back and re-think the whole document to do so.
I've tried copying/pasting from Acrobat, but it only gets the text - no
positioning or lines...
So: bottom-line question.... Is there some way I can render this thing and get
it into a document editor?
--
PeteCresswell
3  2137 
Try setting up the report in Access, then just exporting it to Word, not as
a mail-merge. It should come across in RTF format, which will preserve your
formatting. You can open it in Word and edit further.
HTH
- Turtle
"(Pete Cresswell)" <x@y.z> wrote in message
news:vc******** *************** *********@4ax.c om... I'm doing a booklet for a class reunion. Got all the data and
everybody's life history in a little MS Access app and now it's time to get the booklet
ready to go to the printer's.
I have a report that creates same, but rather than send it to a printer of
PDF file, I'd prefer to get it into MS Word, PageMaker, or some other document
editor. Reason: some people have sent in pictures, and I'd like to flow
the text around their pix.
I've considered exporting to an MS Word mail-merge, but there's so much
contitional formatting in the report (mainly, if somebody is deceased,
various fields become invisible and an obituary takes over the whole space) that
I'd probably have to go back and re-think the whole document to do so.
I've tried copying/pasting from Acrobat, but it only gets the text - no
positioning or lines...
So: bottom-line question.... Is there some way I can render this thing and
get it into a document editor?
--
PeteCresswell
Pete,
I'd tend to do some VBA where I fired up an instance of Word in my code and
then had Word do whatever heavy lifting was needed to complete the document.
There is limited support for conditional branching in the mail-merge codes
supported by Word but it may not be enough. The automation possible in Word
with its command set in VB is extensive so that's probably where I'd focus
my energy.
"(Pete Cresswell)" <x@y.z> wrote in message
news:vc******** *************** *********@4ax.c om... I'm doing a booklet for a class reunion. Got all the data and
everybody's life
history in a little MS Access app and now it's time to get the booklet
ready to
go to the printer's.
I have a report that creates same, but rather than send it to a printer of
PDF
file, I'd prefer to get it into MS Word, PageMaker, or some other document
editor. Reason: some people have sent in pictures, and I'd like to flow
the
text around their pix.
I've considered exporting to an MS Word mail-merge, but there's so much
contitional formatting in the report (mainly, if somebody is deceased,
various
fields become invisible and an obituary takes over the whole space) that
I'd
probably have to go back and re-think the whole document to do so.
I've tried copying/pasting from Acrobat, but it only gets the text - no
positioning or lines...
So: bottom-line question.... Is there some way I can render this thing and
get
it into a document editor?
--
PeteCresswell
RE/ I'd tend to do some VBA where I fired up an instance of Word in my code and
then had Word do whatever heavy lifting was needed to complete the document.
There is limited support for conditional branching in the mail-merge codes...
I never thought of that: just open up an instance of Word from Access and build
customized pages individually on-the-fly. Thanks. I've done this before in
customer-response letters...I guess I just got so fixated on mail-merge this
time that it didn't occurred to me.
--
PeteCresswell This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Mark C |
last post by:
All,
I have exhaustingly been looking through the newsgroups in search of a way
to systemically output an Access 97 report to a pdf file using the full
version of Adobe Acrobat. I want the user to be able to click a button and
have the Access report saved as a pdf in a directory specified by me the
programmer.
I have seen a posting by John Baker promoting a web-sight that has an mde
that one can reference in any database but after 30...
|
by: dog |
last post by:
I've seen plenty of articles on this topic but none of them have been
able to solve my problem.
I am working with an Access 97 database on an NT4.0 machine, which has
many Access reports.
I want my users to be able to select a report, click on a command
button on a form, which will then automatically create the report as a
pdf file and save it to the user's machine.
I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
|
by: Jorge Cecílio |
last post by:
Hi!
I would like to export some MS-Access reports output to pdf.
However, the only possibility offered by Access (afaik) for me to export
formatted output is snp (snapshot) (I use MS-Office XP Prof. 2002 version).
With formatted output I mean the *exactly* output I produce from executing
my report (information is gathered from an ODBC database).
|
by: Grasshopper |
last post by:
Hi,
I am automating Access reports to PDF using PDF Writer 6.0. I've
created a DTS package to run the reports and schedule a job to run this
DTS package. If I PC Anywhere into the server on where the job is
running, the job runs sucessfully, PDF files got generated, everything
is good. If I scheduled the job to run at the time that I am not
logged into the server, Access is not able to print to the printer.
The error is pretty...
|
by: cyranoVR |
last post by:
This is the approach I used to automate printing of Microsoft Access
reports to PDF format i.e. unattended and without annoying "Save As..."
dialogs, and - more importantly - without having to use a commercial
program such as Adobe Acrobat and its associated API.
The technique uses Ghostscript and Redirection Port Monitor - two free
programs for creating PDF documents provided free by Russell Lang. The
actual automation requires VBA...
| | |
by: sbnj |
last post by:
I have an existing database up and running great but im looking to ad
some new features. I currently import a "new orders" file everyday
the file contains order #, item #, qty ordered etc... when ou
products are made I print product barcode labels from a separat
program on a laser printer using full sheets (14 labels per sheet).
I want to be able to print the data/barcode labels from a menu withi
access to a single label thermal printer...
|
by: salad |
last post by:
Hi Guys: I was stuck. I needed to send a report to a file. My
beautiful report(s) in Access were going to require loss of formatting
with RTFs, a PITA in WordMailMerge, sending it as a text file...whatever.
I described my situation to the guy I'm doing work for and he did some
research for me and came up with the following link.
http://www.novapdf.com/
The part that should excite us Access developers is their SDK
|
by: sphinney |
last post by:
OK, is Access 2007 driving anyone else nuts? I've got three lines of VBA code that sends a report to the printer:
DoCmd.OpenReport RPT_NAME, acViewPreview, , , , ARGS
DoCmd.RunCommand acCmdQuickPrint
DoCmd.Close acReport, RPT_NAME, acSaveNo
These lines worked perfectly in Access 2003. Now with 2007, the report is being sent to the wrong printer. I don't understand why Access 2007 has choosen the particular printer it's sending the...
|
by: Snoopy33 |
last post by:
I have a DB that I developed on access XP (2002) and deployed over a
year ago. No one has had problems printing any of the reports within
the DB until we started loading 2007 on new computers. The access
2007 users cannot print one of the reports. This is maddening since I
cannot duplicate the issue on any computer that runs 2003 or below.
Is there something going on that I'm not seeing? Does anyone have any
suggestions at all on...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
