A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Lebans ReportToPDF test



 
 
Thread Tools Display Modes
  #11  
Old November 11th, 2005, 05:04 PM
Dieter Liessmann
external usenet poster
 
Posts: n/a
Default Lebans ReportToPDF test

Hi Stephen,
Stephen Lebans wrote:

I was not able to test every single page size. What page size is your
report formatted for?


German DIN-A4 Letter

Can you export the report that is failing to Snapshot format and
Email me the Snapshot please.


.... in progress


--
So long Dieter

  #12  
Old November 11th, 2005, 07:19 PM
Stephen Lebans
external usenet poster
 
Posts: n/a
Default Lebans ReportToPDF test

Dieter the Snapshot file you sent me converted without any problems. What
happens when you use ReportToPDF to convert the Snapshot file itself, not
the original report?
The error message is not from my source code but from Access itself. If I
translate it correctly, it is saying the report you selected is not
available to be exported to Snapshot format. Did you produce the exported
Snapshot in A2003 or another version of Access.

Do you have a default printer driver selected for the machine that has
Access 2003 on it? If so then use Page Setup to select a specific printer
driver for the report in A2003.

Honestly Dieter, at this point, I really do n ot belive it is a problem with
my code but a problem with your setup in A2003.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"Dieter Liessmann" wrote in message
...
Hi Stephen,

sorry, but i didn't have read the headline on your hompage until now.

It works fine with A2000 and A2002 but there always is a Problem with
A2003.

The error is the one you aleready know:
"Das Format, in dem Sie das aktuelle Objekt auszugeben versuchen, ist
nicht
verfügbar"
The Title of the MsgBox: ReportToPDF:2282

--
So long Dieter



  #13  
Old November 11th, 2005, 07:36 PM
Dieter Liessmann
external usenet poster
 
Posts: n/a
Default Lebans ReportToPDF test

Hi Stephen,

Stephen Lebans wrote:

Dieter the Snapshot file you sent me converted without any problems.
What happens when you use ReportToPDF to convert the Snapshot file
itself, not the original report?


Works fine?!

The error message is not from my source code but from Access itself.
If I translate it correctly, it is saying the report you selected is
not available to be exported to Snapshot format. Did you produce the
exported Snapshot in A2003 or another version of Access.


A2003

Do you have a default printer driver selected for the machine that has
Access 2003 on it?


Yes

If so then use Page Setup to select a specific
printer driver for the report in A2003.


same error as before :-(

Honestly Dieter, at this point, I really do n ot belive it is a
problem with my code but a problem with your setup in A2003.


sorry, but i can't belive this, becaus i have tested on 2 different
machienes.

I will make a few more tests on other machienes on monday.

--
So long Dieter

  #14  
Old November 11th, 2005, 08:11 PM
Stephen Lebans
external usenet poster
 
Posts: n/a
Default Lebans ReportToPDF test

Dieter do the sample reports in the ReportToPDF MDE convert OK?

I have 2 machines with A2003/WinXP Pro and your file converted fine.

Just to get things straight, when I asked you if you were able to convert
the exported SNapshot file you sent me you said:
Works fine?!

Does that mean the Snapshot converted properly?


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Dieter Liessmann" wrote in message
...
Hi Stephen,

Stephen Lebans wrote:

Dieter the Snapshot file you sent me converted without any problems.
What happens when you use ReportToPDF to convert the Snapshot file
itself, not the original report?


Works fine?!

The error message is not from my source code but from Access itself.
If I translate it correctly, it is saying the report you selected is
not available to be exported to Snapshot format. Did you produce the
exported Snapshot in A2003 or another version of Access.


A2003

Do you have a default printer driver selected for the machine that has
Access 2003 on it?


Yes

If so then use Page Setup to select a specific
printer driver for the report in A2003.


same error as before :-(

Honestly Dieter, at this point, I really do n ot belive it is a
problem with my code but a problem with your setup in A2003.


sorry, but i can't belive this, becaus i have tested on 2 different
machienes.

I will make a few more tests on other machienes on monday.

--
So long Dieter



  #15  
Old November 14th, 2005, 07:49 AM
Dieter Liessmann
external usenet poster
 
Posts: n/a
Default Lebans ReportToPDF test

Hi Stephen,
Stephen Lebans wrote:
Dieter do the sample reports in the ReportToPDF MDE convert OK?


No. I still get the same Message when i try the reoprts in your mde.

I have 2 machines with A2003/WinXP Pro and your file converted fine.

Just to get things straight, when I asked you if you were able to
convert the exported SNapshot file you sent me you said:
Works fine?!

Does that mean the Snapshot converted properly?


Yes!
Sorry for my confusing "?!".
I placed it because I don't understand why I can manually export a report to
snp an then convert it into pdf, but not automatically.


--
So long Dieter

  #16  
Old November 14th, 2005, 08:51 AM
Dieter Liessmann
external usenet poster
 
Posts: n/a
Default Lebans ReportToPDF test

Hi Stephen,

i have made a few more tests and solved the problem!

To my shame it's a servicepack problem.
On my systems there was only SP1 for O2003 installed. Now i have installed
SP2 an int works!

Sorry for all the work because of my stupid beginnersmistake.

--
So long Dieter

  #17  
Old November 14th, 2005, 02:08 PM
Stephen Lebans
external usenet poster
 
Posts: n/a
Default Lebans ReportToPDF test

Dieter I really appreciate that you stuck with this issue until it was
resolved. I'll post your findings on the ReportToPDF Web page. I'm sure you
will help the next person who runs into this issue.
:-)
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Dieter Liessmann" wrote in message
...
Hi Stephen,

i have made a few more tests and solved the problem!

To my shame it's a servicepack problem.
On my systems there was only SP1 for O2003 installed. Now i have installed
SP2 an int works!

Sorry for all the work because of my stupid beginnersmistake.

--
So long Dieter



  #18  
Old November 17th, 2005, 04:29 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Lebans ReportToPDF test

Posted a new and improved version of the ReportToPDF project tonight.
http://www.lebans.com/reporttopdf.htm

Major change to project. No more MDE! Core logic is now contained within a
standard Windows DLL named StrStorage.dll produced in C++. New version of
the DynaPDF library. Neither the DyanPDF DLL or the StrStorage DLL require
Registration or a Reference to be set in your MDB. Solution now works with
all versions of Access. Several minor bug fixes and huge increase in
execution speed.


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Stephen Lebans"
wrote in message ...
Dieter I really appreciate that you stuck with this issue until it was
resolved. I'll post your findings on the ReportToPDF Web page. I'm sure
you will help the next person who runs into this issue.
:-)
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Dieter Liessmann" wrote in message
...
Hi Stephen,

i have made a few more tests and solved the problem!

To my shame it's a servicepack problem.
On my systems there was only SP1 for O2003 installed. Now i have
installed SP2 an int works!

Sorry for all the work because of my stupid beginnersmistake.

--
So long Dieter





  #19  
Old November 17th, 2005, 12:38 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Lebans ReportToPDF test

Never fails! Two days after I deploy there is a new version. :-)

Stephen thanks again for the generous contributions of your time and
expertise to the Access developer community. I haven't tested the new
version, but this is exactly what we have needed in Access for quite some
time. I had gotten tired of telling my customers that they needed to buy a
PDF maker or download a freeware solution and then install it on every PC
that used my app. Then having to fight with code that could work using a
zillion different PDF creators in various version levels. It was a
nightmare!!

I am on a different project now, but you can be sure that the next time that
I need PDF output from Access, or when we upgrade my last project I will be
using your solution.

As an aside can you point me to where I might be able to get additional
information on the Enhanced Metafile format, and how I might be able to
create them from other applications like Word, Excel, VB, etc. Just
wondering out loud ;-} Always need to be willing to look at new ways to get
things done, and be ambidextrous in this business to survive.

--
Ron W
www.WorksRite.com
"Stephen Lebans"
wrote in message ...
Posted a new and improved version of the ReportToPDF project tonight.
http://www.lebans.com/reporttopdf.htm

Major change to project. No more MDE! Core logic is now contained within a
standard Windows DLL named StrStorage.dll produced in C++. New version of
the DynaPDF library. Neither the DyanPDF DLL or the StrStorage DLL require
Registration or a Reference to be set in your MDB. Solution now works with
all versions of Access. Several minor bug fixes and huge increase in
execution speed.


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Stephen Lebans"
wrote in message ...
Dieter I really appreciate that you stuck with this issue until it was
resolved. I'll post your findings on the ReportToPDF Web page. I'm sure
you will help the next person who runs into this issue.
:-)
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Dieter Liessmann" wrote in message
...
Hi Stephen,

i have made a few more tests and solved the problem!

To my shame it's a servicepack problem.
On my systems there was only SP1 for O2003 installed. Now i have
installed SP2 an int works!

Sorry for all the work because of my stupid beginnersmistake.

--
So long Dieter







  #20  
Old November 17th, 2005, 02:18 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Lebans ReportToPDF test

Hi Ron,
If your idea is to use the ReportToPDF solution for other applications then
I am afraid it its simply not possible. The key here is the Snapshot format.
In a nutshell, it is similiar to the output of your printer driver Spool
files. In order to simlulate this with other applications, you would have to
either:

1) Using Win2K or higher, enable saving of the printer spooler files.
or
2) Purchase and install an EMF Printer driver.

ReportToPDF was written for Access only.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Ron Weiner" wrote in message
...
Never fails! Two days after I deploy there is a new version. :-)

Stephen thanks again for the generous contributions of your time and
expertise to the Access developer community. I haven't tested the new
version, but this is exactly what we have needed in Access for quite some
time. I had gotten tired of telling my customers that they needed to buy
a
PDF maker or download a freeware solution and then install it on every PC
that used my app. Then having to fight with code that could work using a
zillion different PDF creators in various version levels. It was a
nightmare!!

I am on a different project now, but you can be sure that the next time
that
I need PDF output from Access, or when we upgrade my last project I will
be
using your solution.

As an aside can you point me to where I might be able to get additional
information on the Enhanced Metafile format, and how I might be able to
create them from other applications like Word, Excel, VB, etc. Just
wondering out loud ;-} Always need to be willing to look at new ways to
get
things done, and be ambidextrous in this business to survive.

--
Ron W
www.WorksRite.com
"Stephen Lebans"
wrote in message ...
Posted a new and improved version of the ReportToPDF project tonight.
http://www.lebans.com/reporttopdf.htm

Major change to project. No more MDE! Core logic is now contained within
a
standard Windows DLL named StrStorage.dll produced in C++. New version of
the DynaPDF library. Neither the DyanPDF DLL or the StrStorage DLL
require
Registration or a Reference to be set in your MDB. Solution now works
with
all versions of Access. Several minor bug fixes and huge increase in
execution speed.


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Stephen Lebans"

wrote in message ...
Dieter I really appreciate that you stuck with this issue until it was
resolved. I'll post your findings on the ReportToPDF Web page. I'm sure
you will help the next person who runs into this issue.
:-)
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Dieter Liessmann" wrote in message
...
Hi Stephen,

i have made a few more tests and solved the problem!

To my shame it's a servicepack problem.
On my systems there was only SP1 for O2003 installed. Now i have
installed SP2 an int works!

Sorry for all the work because of my stupid beginnersmistake.

--
So long Dieter








 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Test for query returning no records The Grape Hunter Running & Setting Up Queries 1 October 4th, 2005 10:20 PM
Quiz Test Maker Tony Dondero Running & Setting Up Queries 0 September 8th, 2005 11:00 PM
Trying to find Nulls in an IIF statement Lori Running & Setting Up Queries 12 August 12th, 2005 11:32 AM
Test Scoring Query Help [email protected] Running & Setting Up Queries 1 December 6th, 2004 01:55 PM
Applying styles during Import Joe Publisher 2 June 28th, 2004 08:36 PM


All times are GMT +1. The time now is 05:27 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.