Access 97 Version of ReportToPDF

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

Re: Access 97 Version of ReportToPDF

Jana wrote:

>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/

Re: Access 97 Version of ReportToPDF

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@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]" wrote in message
news:7f44k3po3ajs796ouhv4iilb2qnj0nqf5q@4ax.com...
> Jana wrote:
>
>>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/

Re: Access 97 Version of ReportToPDF

On Nov 19, 6:21 pm, "Stephen Lebans" WWWdotlebansdot...@linvalid.com> wrote:
> 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@MyLastName.com
>
> --
>
> HTH
> Stephen Lebanshttp://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
> "Tony Toews [MVP]" wrote in messagenews:7f44k3po3ajs796ouhv4iilb2qnj0nqf5q@4ax.com...
>
>
>
> > Jana wrote:
>
> >>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/- Hide quoted text -
>
> - Show quoted text -

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

Re: Access 97 Version of ReportToPDF

"Stephen Lebans"
wrote in
news:474236ab$0$5290$9a566e8b@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/Access/A1997SnapshotToPDFver 751.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/

Re: Access 97 Version of ReportToPDF

On Nov 20, 2:22 pm, "David W. Fenton"
wrote:
> "Stephen Lebans"
> wrote innews:474236ab$0$5290$9a566e8b@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/Access/A1997SnapshotToPDFver 751.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

Re: Access 97 Version of ReportToPDF

Jana wrote in
news:cd4d4f76-11bf-4400-b9a9-9e1dedbf81cc@s8g2000prg.googleg roups.com
:

> On Nov 20, 2:22 pm, "David W. Fenton"
> wrote:
>> I've put it on my website for download here:
>>
>> http://dfenton.com/DFA/download/Access/A1997SnapshotToPDFver 751.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/

Re: Access 97 Version of ReportToPDF

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" wrote in message
news:Xns99EFA94757DA9f99a49ed1d0c49c5bbb2@64.209.0.95...
> Jana wrote in
> news:cd4d4f76-11bf-4400-b9a9-9e1dedbf81cc@s8g2000prg.googleg roups.com
> :
>
>> On Nov 20, 2:22 pm, "David W. Fenton"
>> wrote:
>>> I've put it on my website for download here:
>>>
>>> http://dfenton.com/DFA/download/Access/A1997SnapshotToPDFver 751.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/

Re: Access 97 Version of ReportToPDF

"Stephen Lebans"
wrote in
news:4744f1eb$0$5265$9a566e8b@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/Access/A1997SnapshotToPDFver 751.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/

Re: Access 97 Version of ReportToPDF

On Nov 22, 12:42 pm, "David W. Fenton"
wrote:
> "Stephen Lebans"
> wrote innews:4744f1eb$0$5265$9a566e8b@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/Access/A1997SnapshotToPDFver 751.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