Access 97 Version of ReportToPDF

[Jana]

I would love to check out Stephen Leban's ReportToPDF database, but
only have Access 97. Is there a way to get a 97 version?

Thanks,
Jana

[Tony Toews [MVP]]

Jana <Ba********@gmail.comwrote:

>I would love to check out Stephen Leban's ReportToPDF database, but
only have Access 97. Is there a way to get a 97 version?

The code might work in A97 as is. I don't recall any specific things that wouldn't
work in A97. I just quickly reviewed the code in oen of my databases and nothing
jumps out at me as being a problem. Ah, the first line in the module states
"'DEVELOPED AND TESTED UNDER MICROSOFT ACCESS 97 through A2003"

I'd suggest trying it yourself and see what happens.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Stephen Lebans]

Tony I simply got tired(read lazy) of maintaining two versions. Further it
was time to stop developing A97.

The code converts with no issues back to A97 format. If the OP does not have
the capability to covert the A2K ReportToPDF MDB then they can send me an
Email requesting an A97 version.

My*********@MyLastName.com

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Tony Toews [MVP]" <tt****@telusplanet.netwrote in message
news:7f********************************@4ax.com...

Jana <Ba********@gmail.comwrote:

>>I would love to check out Stephen Leban's ReportToPDF database, but
only have Access 97. Is there a way to get a 97 version?

The code might work in A97 as is. I don't recall any specific things that
wouldn't
work in A97. I just quickly reviewed the code in oen of my databases and
nothing
jumps out at me as being a problem. Ah, the first line in the module
states
"'DEVELOPED AND TESTED UNDER MICROSOFT ACCESS 97 through A2003"

I'd suggest trying it yourself and see what happens.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[David W. Fenton]

"Stephen Lebans"
<[e-mail] in
news:47**********************@news.aliant.net:

The code converts with no issues back to A97 format. If the OP
does not have the capability to covert the A2K ReportToPDF MDB
then they can send me an Email requesting an A97 version.

I've put it on my website for download here:

http://dfenton.com/DFA/download/Acce...oPDFver751.zip

If Stephen wants to put it on his own website, I'll take it down
from mine.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Jana]

On Nov 20, 2:22 pm, "David W. Fenton" <[e-mail]>
wrote:

"Stephen Lebans"
<[e-mail] innews:47**********************@news.aliant.net:

The code converts with no issues back to A97 format. If the OP
does not have the capability to covert the A2K ReportToPDF MDB
then they can send me an Email requesting an A97 version.

I've put it on my website for download here:

http://dfenton.com/DFA/download/Acce...oPDFver751.zip

If Stephen wants to put it on his own website, I'll take it down
from mine.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Awesome! Thanks very muchly. Stephen emailed me one, but it kept
crashing when I went to create a report even though I made the changes
he said I'd need to make. Your copy works like a dream, and I can't
wait to implement it in my own app.

Jana

[David W. Fenton]

Jana <Ba********@gmail.comwrote in
news:cd**********************************@s8g2000p rg.googlegroups.com
:

On Nov 20, 2:22 pm, "David W. Fenton"
<[e-mail]:

>I've put it on my website for download here:

http://dfenton.com/DFA/download/Acce...ToPDFver751.zi
p

If Stephen wants to put it on his own website, I'll take it down
from mine.

Awesome! Thanks very muchly. Stephen emailed me one, but it kept
crashing when I went to create a report even though I made the
changes he said I'd need to make. Your copy works like a dream,
and I can't wait to implement it in my own app.

Perhaps that's because I compiled it in A97 before zipping it up?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Stephen Lebans]

Hi David,
I asked the OP to add ByVal for a parameter in a function declaration. It
was to fix a bug mistakenly introduced during the last release. The A97
version had not been corrected - see why I prefer to publish only one
version on my site!

Thank you for putting an A97 version on your site. The computer containing
my Lebans.com FrontPage stuff died several months ago. I will rebuild the
machine over the Christmas holidays and hopefully start updating my site
again.

To complete this thread, Bug details to follow:

There was a bug introduced for Font Embedding in the last release.

At the top of your modReportTOPDF module is the function signature:
Public Declare Function ConvertUncompressedSnapshot Lib "StrStorage.dll" _
(ByVal UnCompressedSnapShotName As String, _ ByVal OutputPDFname As String,
_ Optional ByVal CompressionLevel As Long = 0, _ Optional ByVal
PasswordOwner As String = "", _ Optional ByVal PasswordOpen As String = "",
_ Optional ByVal PasswordRestrictions As Long = 0, _ Optional
PDFNoFontEmbedding As Long = 0 _
) As Boolean
The very last line of the Sig is missing the ByVal declaration:
Optional PDFNoFontEmbedding As Long = 0 _
Should be changed to:
Optional ByVal PDFNoFontEmbedding As Long = 0 _


--

Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@64.209.0 .95...

Jana <Ba********@gmail.comwrote in
news:cd**********************************@s8g2000p rg.googlegroups.com
:

>On Nov 20, 2:22 pm, "David W. Fenton"
<[e-mail]:

>>I've put it on my website for download here:

http://dfenton.com/DFA/download/Acce...ToPDFver751.zi
p

If Stephen wants to put it on his own website, I'll take it down
from mine.

Awesome! Thanks very muchly. Stephen emailed me one, but it kept
crashing when I went to create a report even though I made the
changes he said I'd need to make. Your copy works like a dream,
and I can't wait to implement it in my own app.

Perhaps that's because I compiled it in A97 before zipping it up?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[David W. Fenton]

"Stephen Lebans"
<[e-mail] in
news:47**********************@news.aliant.net:

At the top of your modReportTOPDF module is the function
signature:
Public Declare Function ConvertUncompressedSnapshot Lib
"StrStorage.dll" _ (ByVal UnCompressedSnapShotName As String, _
ByVal OutputPDFname As String, _ Optional ByVal CompressionLevel
As Long = 0, _ Optional ByVal PasswordOwner As String = "", _
Optional ByVal PasswordOpen As String = "", _ Optional ByVal
PasswordRestrictions As Long = 0, _ Optional PDFNoFontEmbedding As
Long = 0 _
) As Boolean
The very last line of the Sig is missing the ByVal declaration:
Optional PDFNoFontEmbedding As Long = 0 _
Should be changed to:
Optional ByVal PDFNoFontEmbedding As Long = 0 _

I've fixed this, compacted/decompiled/recompiled/compacted and
reuploaded it:

http://dfenton.com/DFA/download/Acce...oPDFver751.zip

If you want it taken down when you restore your website, I'm happy
to comply.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Jana]

On Nov 22, 12:42 pm, "David W. Fenton" <[e-mail]>
wrote:

"Stephen Lebans"
<[e-mail] innews:47**********************@news.aliant.net:

At the top of your modReportTOPDF module is the function
signature:

Public Declare Function ConvertUncompressedSnapshot Lib
"StrStorage.dll" _ (ByVal UnCompressedSnapShotName As String, _
ByVal OutputPDFname As String, _ Optional ByVal CompressionLevel
As Long = 0, _ Optional ByVal PasswordOwner As String = "", _
Optional ByVal PasswordOpen As String = "", _ Optional ByVal
PasswordRestrictions As Long = 0, _ Optional PDFNoFontEmbedding As
Long = 0 _

) As Boolean

The very last line of the Sig is missing the ByVal declaration:

Optional PDFNoFontEmbedding As Long = 0 _

Should be changed to:

Optional ByVal PDFNoFontEmbedding As Long = 0 _

I've fixed this, compacted/decompiled/recompiled/compacted and
reuploaded it:

http://dfenton.com/DFA/download/Acce...oPDFver751.zip

If you want it taken down when you restore your website, I'm happy
to comply.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/- Hide quoted text -

- Show quoted text -

Thanks again to the both of you!
Jana