By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,968 Members | 1,215 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,968 IT Pros & Developers. It's quick & easy.

Save file as pdf

P: 5
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
Share this Question
Share on Google+
7 Replies


ADezii
Expert 5K+
P: 8,679
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

P: 32
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

P: 5
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

P: 5
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

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


Expand|Select|Wrap|Line Numbers
  1. docmd.Setwarnings False
  2. DoCmd.OpenReport "ReportName".
  3. docmd.Setwarnings True
Jan 23 '08 #6

P: 32
So is the PDF creater based on a Printed report? Any progress on this?
Jan 28 '08 #7

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


Expand|Select|Wrap|Line Numbers
  1. docmd.Setwarnings False
  2. DoCmd.OpenReport "ReportName".
  3. docmd.Setwarnings True

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

DoCmd.Close acReport, "ReportName", acSaveyes
Feb 6 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.