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

Jana <Bauer.Jana (AT) gmail (DOT) com> wrote:

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/

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.

MyFirstName (AT) MyLastName (DOT) 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]" <ttoews (AT) telusplanet (DOT) net> wrote

On Nov 19, 6:21 pm, "Stephen Lebans" <ForEmailGotoMy.WebSite.-
WWWdotlebansdot... (AT) linvalid (DOT) com> wrote:
Tony:

Unfortunately, without A2K, I can't open the db in order to grab the
code.

Stephen:

Thanks, I've sent an email requesting the A97 version. I'm looking
forward to it!

Jana

On Nov 20, 2:22 pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid>
wrote:
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

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" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote

On Nov 22, 12:42 pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid>
wrote:
Thanks again to the both of you!
Jana