Save file as pdf - Microsoft Access / VBA

5 New Member

I have inherited a program in which I'm finding that Access is running strangely. I broke the entire function into multiple macros as the reports would fail. It seems that when the DoCmd.OpenReport is called the reports fail? I'm assuming that this is because of a timeout issue. I have scheduled 8 macros to run a single report and save it to the hard drive as a pdf. When I return, after the macros have ran, I notice that EVERY instance is stuck on the same issue. I have a dialog box that is asking me if I want to save the document. I get stuck at this point whether the file does or does not exist. How can I fix this? From what I've been told this code worked before. Why would it quit working all of a sudden?

Thanks in advance,

Jan 22 '08 #1

Subscribe Reply

3123

ADezii

8,834

Recognized Expert Expert

I have inherited a program in which I'm finding that Access is running strangely. I broke the entire function into multiple macros as the reports would fail. It seems that when the DoCmd.OpenReport is called the reports fail? I'm assuming that this is because of a timeout issue. I have scheduled 8 macros to run a single report and save it to the hard drive as a pdf. When I return, after the macros have ran, I notice that EVERY instance is stuck on the same issue. I have a dialog box that is asking me if I want to save the document. I get stuck at this point whether the file does or does not exist. How can I fix this? From what I've been told this code worked before. Why would it quit working all of a sudden?

Thanks in advance,

We will definately need more detail than that which you have provided.

Jan 23 '08 #2

jyoung2

New Member

As an aside I have had many problems with adobe Acrobat 8 creator. When it installs by default it includes some links to access that have caused some strange problems. If you have made no changes to the access side and it used to work and now it doesn't you may want to consider security patches, software upgrades, or security settings.

Jan 23 '08 #3

dmagoo22

New Member

When I open my Report with DoCmd.OpenReport "ReportName". This should save my pdf file to the directory that I have set up. This does not happen. I get a "Dialog Box" that asks me if I want to save the report. I DO NOT want that. From every piece of documentation that I have read it states that this dialog box shouldn't appear. Do you know why that is?

Jan 23 '08 #4

dmagoo22

New Member

As an aside I have had many problems with adobe Acrobat 8 creator. When it installs by default it includes some links to access that have caused some strange problems. If you have made no changes to the access side and it used to work and now it doesn't you may want to consider security patches, software upgrades, or security settings.

Thanks, I'll look into that.

Jan 23 '08 #5

jyoung2

New Member

With your DoCmd.OpenReport "ReportName". make sure you have warnings set to false

Expand|Select|Wrap|Line Numbers

 docmd.Setwarnings False

DoCmd.OpenReport "ReportName".

docmd.Setwarnings True

Jan 23 '08 #6

jyoung2

New Member

So is the PDF creater based on a Printed report? Any progress on this?

Jan 28 '08 #7

dmagoo22

New Member

With your DoCmd.OpenReport "ReportName". make sure you have warnings set to false

Expand|Select|Wrap|Line Numbers

docmd.Setwarnings False

DoCmd.OpenReport "ReportName".

docmd.Setwarnings True

Thanks! This worked. I also added the following to make sure

DoCmd.Close acReport, "ReportName", acSaveyes

Feb 6 '08 #8

Similar topics

6410

save text file (stream) as html

by: a | last post by:

Save text file as html kloepper 17:42 23 Jul '04 I'm using httpwebresponse and a StringBuilder to return a stream that originates as a file with the .txt suffix (My download code converts the html...

C# / C Sharp

6850

Downloading file from remote server with 'Save As' dialogue

by: kevin | last post by:

Hi, Any help with this would be really appreciated! I'm trying to download a file from a remote server. The access permissions is okay but the problem I'm facing is that the file is getting...

C# / C Sharp

5510

"Save As" dialog???

by: Richard | last post by:

Hi I'm new to ASP/Web programming so any help would be appreciated... Situation: On my web page I would like to present a link {or button} that would allow the user to download a large file. ...

ASP.NET

4493

download a file in a background without Save As

by: sunilj20 | last post by:

Hello, I have a requirement wherein, a user clicks on a file name in an ASP.NET web application, and the file should automatically be downloaded (Without showing the "Open", "Save As") in the...

ASP.NET

3465

Save to file

by: Patrick | last post by:

Following on from the excellent example at http://www.c-sharpcorner.com/Code/2003/Sept/ExportASPNetDataGridToExcel.asp on how to save a data-grid to excel file, how can I extend the example such...

ASP.NET

4320

save file dialog

by: GJP | last post by:

Hello. Ive been asked to make my own notepade for college assignment. All ig going well, but i cant get the save to work. I can get Save a (shows dialog box), i can get it to just save too,...

Visual Basic .NET

39444

save DataGridView to Xml

by: Henok Girma | last post by:

Hello Gurus, I want to save the state of an unbound DataGridView on my Windows Form application to an XML file so i can later load it back.. Basically, on my form I have a DataGridView, it's got...

C# / C Sharp

6767

how to save a screenshot in pygame?

by: liuliuliu | last post by:

hi -- sorry if this is trivial -- but how do you make a screenshot of a pygame display? i have a surface which is basically the entire visible screen -- how do you write this surface as an image...

Python

8550

Save a web page - hyperlinks question

by: fiefie.niles | last post by:

I would like to save a web page to a file and have the hyperlinks work when I bring the file back up. If the web page has a hyperlink like the following <a href="OurWeb/News/abcFile.htm">, after...

ASP / Active Server Pages

6413

save as dialog

by: =?Utf-8?B?YXNkZg==?= | last post by:

Hello. I am making a web application with c# and am using this code: Response.ContentType = "application/x-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=" +...

ASP.NET

6964

Changing the language in Windows 10

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...

Windows Server

7123

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7175

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

6842

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

7319

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

5430

AI Job Threat for Devs

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,...

Career Advice

3070

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

598

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

262

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General