Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Problem with PRINT REPORT TO PDF in microsoft.public.access.modulesdaovba
Started 1 month, 2 weeks ago by BlueWolverine
Hello, MS ACCESS 2003 on XP PRO. A while ago, I found out about lebans.com and the marvelous code there to print a report to PDF. using VBA. I have found that code to be reliable and generally awesome. It is with that code that I am having trouble today however. Here's the deal. I am using ConvertToPDF in a loop,...
Site: Discussions in microsoft.public.access.modulesdaovba  Discussions in microsoft.public.access.modulesdaovba - site profile
Forum: microsoft.public.access.modulesdaovba  microsoft.public.access.modulesdaovba - forum profile
Total authors: 3 authors
Total thread posts: 8 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

Jack Leach replied 1 month, 2 weeks ago
Wiithout looking at your actual code, and just a shot in the dark to boot, I would be suspicious of using the square brackets [] as characters in a filename. Aside from how the filesystem might handle these (I don't know how), these to have a special meaning in VBA and there's a good possibility that somewhere in that code of Mr. ...
Size: 18 kb
Customize:  Customize "<b>Reply 1</b>: Problem with PRINT REPORT TO PDF in microsoft.public.access.modulesdaovba :: microsoft.public.access.modulesdaovba :: Discussions in microsoft.public.access.modulesdaov..."

BlueWolverine replied 1 month, 2 weeks ago
I thought about that, and I guess now I'll test it. But It works elsewhere! Stupid inconsistency I'll try that and report back. Please keep ideas coming. -- BlueWolverine MSE - Mech. Eng. Go BLUE! "Jack Leach" wrote: > Wiithout looking at your actual code, and just a shot in the dark to...
Size: 19 kb
Customize:  Customize "<b>Reply 2</b>: Problem with PRINT REPORT TO PDF in microsoft.public.access.modulesdaovba :: microsoft.public.access.modulesdaovba :: Discussions in microsoft.public.access.modulesdaov..."

BlueWolverine replied 1 month, 2 weeks ago
I have now tried parans and underscores. (2009-11NOV-09) and _2009-11NOV-09_. Niether works. I get the same problem. and like I said Brackets always worked before. HELP! -- BlueWolverine MSE - Mech. Eng. Go BLUE! "BlueWolverine" wrote: > I thought about that, and I guess ...
Size: 20 kb
Customize:  Customize "<b>Reply 3</b>: Problem with PRINT REPORT TO PDF in microsoft.public.access.modulesdaovba :: microsoft.public.access.modulesdaovba :: Discussions in microsoft.public.access.modulesdaov..."

BlueWolverine replied 1 month, 2 weeks ago
SOLUTION: COLONS. I HATE COLONS. I had found earlier that colons crap out filenames. AWESOME so I now use an underscore in between hours and minutes in my timestamps on purpose. This however does not prevent me from being a dumbass and putting a colon SOMEWHERE ELSE in the filename variable. IN ...
Size: 21 kb
Customize:  Customize "<b>Reply 4</b>: Problem with PRINT REPORT TO PDF in microsoft.public.access.modulesdaovba :: microsoft.public.access.modulesdaovba :: Discussions in microsoft.public.access.modulesdaov..."

Dirk Goldgar replied 1 month, 2 weeks ago
"BlueWolverine" <BlueWolverine@discussions.microsoft.com> wrote in message news:0C6D9404-7563-4B2A-87C7-02E2B9E34F8E@microso ft.com... >I have now tried parans and underscores. (2009-11NOV-09) and > _2009-11NOV-09_. > > Niether works. I get the same problem. and like I said Brackets always > worked before. > > HELP! I ...
Size: 1,468 bytes
Customize:  Customize "<b>Reply 5</b>: Problem with PRINT REPORT TO PDF in microsoft.public.access.modulesdaovba :: microsoft.public.access.modulesdaovba :: Discussions in microsoft.public.access.modulesdaov..."

Jack Leach replied 1 month, 2 weeks ago
Duh, I didn't even see that, should have known -- Jack Leach www.tristatemachine.com "I haven''t failed, I''ve found ten thousand ways that don''t work." -Thomas Edison (1847-1931) "BlueWolverine" wrote: > SOLUTION: > > COLONS. I HATE COLONS. > > > I had found ...
Size: 21 kb
Customize:  Customize "<b>Reply 6</b>: Problem with PRINT REPORT TO PDF in microsoft.public.access.modulesdaovba :: microsoft.public.access.modulesdaovba :: Discussions in microsoft.public.access.modulesdaov..."

Dirk Goldgar replied 1 month, 2 weeks ago
"BlueWolverine" <BlueWolverine@discussions.microsoft.com> wrote in message news:473AC5E0-09CC-4348-9F5E-610E11B64656@micros oft.com... > Hello, > MS ACCESS 2003 on XP PRO. > > A while ago, I found out about lebans.com and the marvelous code there to > print a report to PDF. using VBA. I have found that code to be reliable >...
Size: 3,228 bytes
Customize:  Customize "<b>Reply 7</b>: Problem with PRINT REPORT TO PDF in microsoft.public.access.modulesdaovba :: microsoft.public.access.modulesdaovba :: Discussions in microsoft.public.access.modulesdaov..."

 

Top contributing authors

Name
Posts
BlueWolverine
4
user's latest post:
Problem with PRINT REPORT TO PDF...
Published (2009-11-10 05:58:00)
&nbsp; SOLUTION: COLONS. I HATE COLONS. I had found earlier that colons crap out filenames. AWESOME so I now use an underscore in between hours and minutes in my timestamps on purpose. This however does not prevent me from being a dumbass and putting a colon SOMEWHERE ELSE in the filename variable. IN SHORT - DO NOT USE COLONS IN FILE NAMES. GUARANTEED FAIL. Thank you for your time and help. -- BlueWolverine MSE - Mech. Eng. Go BLUE!...
Jack Leach
2
user's latest post:
Problem with PRINT REPORT TO PDF...
Published (2009-11-10 06:29:00)
&nbsp; Duh, I didn't even see that, should have known -- Jack Leach www.tristatemachine.com &quot;I haven''t failed, I''ve found ten thousand ways that don''t work.&quot; -Thomas Edison (1847-1931) &quot;BlueWolverine&quot; wrote: &gt; SOLUTION: &gt; &gt; COLONS. I HATE COLONS. &gt; &gt; &gt; I had found earlier that colons crap out filenames. AWESOME so I now use...
Dirk Goldgar
2
user's latest post:
Problem with PRINT REPORT TO PDF...
Published (2009-11-10 18:10:00)
&nbsp; &quot;BlueWolverine&quot; &lt;BlueWolverine@discussions.microsoft.com&gt; wrote in message news:473AC5E0-09CC-4348-9F5E-610E11B64656@microsoft.com... &gt; Hello, &gt; MS ACCESS 2003 on XP PRO. &gt; &gt; A while ago, I found out about lebans.com and the marvelous code there to &gt; print a report to PDF. using VBA. I have found that code to be reliable &gt; and &gt; generally awesome. It...

Related threads on "Discussions in microsoft.public.access.modulesdaovba":

Opening a pdf with VBA in MS Access in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Opening a pdf with VBA in MS Access in microsoft.public.access.modulesdaovba
Opening a pdf with VBA in MS Access in microsoft.public.access.modulesdaovba
Updating an Access database using PDF forms in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Updating an Access database using PDF forms in microsoft.public.access.modulesdaovba
Updating an Access database using PDF forms in microsoft.public.access.modulesdaovba
Multiple access reports into one pdf file in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Multiple access reports into one pdf file in microsoft.public.access.modulesdaovba
Multiple access reports into one pdf file in microsoft.public.access.modulesdaovba
Using Access to fill out PDF forms? in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Using Access to fill out PDF forms? in microsoft.public.access.modulesdaovba
Using Access to fill out PDF forms? in microsoft.public.access.modulesdaovba
Automate saving filtered report as PDF in Access 2007 in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Automate saving filtered report as PDF in Access 2007 in microsoft.public.access.modulesdaovba
Automate saving filtered report as PDF in Access 2007 in microsoft.public.access.modulesdaovba
Email pdf report Access 2003 in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Email pdf report Access 2003 in microsoft.public.access.modulesdaovba
Email pdf report Access 2003 in microsoft.public.access.modulesdaovba
How do I view a PDF document, from the file system, in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile How do I view a PDF document, from the file system, in access form in microsoft.public.access.modulesdaovba
How do I view a PDF document, from the file system, in access form in microsoft.public.access.modulesdaovba
Access 2000 Send as PDF in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Access 2000 Send as PDF in microsoft.public.access.modulesdaovba
Access 2000 Send as PDF in microsoft.public.access.modulesdaovba
PDF Preview in Access 2003 in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile PDF Preview in Access 2003 in microsoft.public.access.modulesdaovba
PDF Preview in Access 2003 in microsoft.public.access.modulesdaovba
MS Access Data & PDF Files in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile MS Access Data & PDF Files in microsoft.public.access.modulesdaovba
MS Access Data & PDF Files in microsoft.public.access.modulesdaovba

Related threads on other sites:

Access Report Save as PDF using microsoft Addin in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Access Report Save as PDF using microsoft Addin in microsoft.public.access.modulesdaovba.ado
Access Report Save as PDF using microsoft Addin in microsoft.public.access.modulesdaovba.ado
INSERT records from local Access-DB to another Access-DB...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile INSERT records from local Access-DB to another Access-DB in microsoft.public.access.modulesdaovba.ado
INSERT records from local Access-DB to another Access-DB in microsoft.public.access.modulesdaovba.ado
How do I access a field in a previous record? (Access...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile How do I access a field in a previous record? (Access 2997) in microsoft.public.access.modulesdaovba.ado
How do I access a field in a previous record? (Access 2997) in microsoft.public.access.modulesdaovba.ado
Connect to Access DB without installing Access in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Connect to Access DB without installing Access in microsoft.public.access.modulesdaovba.ado
Connect to Access DB without installing Access in microsoft.public.access.modulesdaovba.ado
Access form in Module question, Can Access do this? in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Access form in Module question, Can Access do this? in microsoft.public.access.modulesdaovba.ado
Access form in Module question, Can Access do this? in microsoft.public.access.modulesdaovba.ado
Access 2007 File Disappears in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Access 2007 File Disappears in microsoft.public.access.modulesdaovba.ado
Access 2007 File Disappears in microsoft.public.access.modulesdaovba.ado
Import .dbf files to MS ACCESS in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Import .dbf files to MS ACCESS in microsoft.public.access.modulesdaovba.ado
Import .dbf files to MS ACCESS in microsoft.public.access.modulesdaovba.ado
Opening Lotus Notes from Access in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Opening Lotus Notes from Access in microsoft.public.access.modulesdaovba.ado
Opening Lotus Notes from Access in microsoft.public.access.modulesdaovba.ado
Opening Outlook from Access in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Opening Outlook from Access in microsoft.public.access.modulesdaovba.ado
Opening Outlook from Access in microsoft.public.access.modulesdaovba.ado
Reading VB Random Files with Access in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Reading VB Random Files with Access in microsoft.public.access.modulesdaovba.ado
Reading VB Random Files with Access in microsoft.public.access.modulesdaovba.ado
Thread profile page for "Problem with PRINT REPORT TO PDF in microsoft.public.access.modulesdaovba" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "Problem with PRINT REPORT TO PDF in microsoft.public.access.modulesdaovba", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity