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 generic. It says Cannot print xxx.pdf to xxx
location, would you like to retry?. Is this a PDF Writer printing
permission problem? FYI, the account that I used to run the job is the
same as the account I used to log into the server.
Please help out. Let me know if more explaination is needed.
Thanks.
Nov 13 '05
11 6598
I actually have a similar annoyance: my one reports that needs to be on
legal-sized paper never "remembers" that it's legal sized. I always
have to set the printing preferences manually before printing. Yet
another report always wants to print to wrong printer on the other side
of the of the office, which is a shame because it's belongs in the
middle of a large set of reports.
However, since we now know that we can set the Default Printer
programmaticall y, a solution for both our problems would be as follows:
configure a second virtual PDF printer that prints Legal paper by
default (how to do this depends on the "Printing Preferences..." window
of your print driver). Then code your VBA so that our legal-sized
reports print to this printer:
net.SetDefault Printer "GS PDF Printer - Legal"
acc.DoCmd.OpenR eport "rptSales_TwoYe arHist" ' legal-paper
However, if you have 20 different reports, each of which is on its own
custom paper-size, things could get messy. On the other hand, if you're
really organized and keep all the report/printer/distribution
information in a local access table (as opposed to hard-coded in the
VBScript), you at least stand a chance of scaling to 100s of reports
and multiple virtual PDF printers.
Thank you cyranoVR.
I only have 2 reports that needed to be printed to legal sized paper.
Seems like Access remembers the report printing preferences while the
reports are printing from one server, however this changes when the
database is moved to another server. Since I only have 2 reports to
worrry about, I just manually set the printing preferences on the
reports and save it. It seems to be running ok.
Just want to say thank you. This is my first Google post, and It has
been a great one. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Peter Petrillo |
last post by:
The Access development group here at this company has exported its reports in xml format from Access 2003. I have no influence on how they have created them. I received the following files
xm
xs
xsl
asp or html (my option
Using a simple ASP.NET form with only a System.Web.UI.WebControls.Xml on it, I receive an error (below) that the scripting language 'vbscript' is not supported. The xslt file has in it vbscript scripting to...
|
by: Gheaci Maschl |
last post by:
Hi all!
I would like to have your opinion about my problem and my proposal how
to solve it:
Ingredients:
- BTriev database
- Crystal Reports
- maybe MS Access
- Liinos6 (small ERP software)
|
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: jdph40 |
last post by:
We recently had to upgrade the computers in our company. Now our
office's website on our company intranet no longer recognizes reports
saved in snapshot format. We get an error message that the file we are
downloading "cannot be opened by the default program. It is either
corrupted or it has an incorrect file type." We had no problem until
our upgrade, but our IT department says there's no fix. My question is
concerning Adobe Acrobat....
| |
by: Bob Alston |
last post by:
I am looking for Access reporting add-in that would be easy to use by
end users. My key focus is on selection criteria. I am very happy with
the Access report writer capabilities. As far as development of
reports, it is certainly fine in my book.
But for end-users, with little experience or training, it would be nice
to have an easy way to handle various selection criteria, perhaps with
relatively stock reports. I see easy to use by...
|
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: babyangel43 |
last post by:
Hello, I have a query set up in Access. I run it monthly, changing
"date of test". I would like this query to be merged with a Word
document so that the cover letter is created in Word, the fields from
Access are automatically filled into the Word document. The query
could be anywhere from 0-5000 names, one cover letter per name. AND to
this cover letter for each applicant, there has to be attached a two
page document. How in the world can...
|
by: prakashwadhwani |
last post by:
Hi !! I'm about to develop a new project for a client.
Should I go about it in Access 2003 or 2007 ? Purchasing it either
for me or for my client is not a major consideration here ... what I'd
like to know is the stability, speed & ease of use of both the
products.
I believe Access 2007 has a new file format too and that it may be
slower.
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |