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  

Hyperlink to Page number in Report that is exported to PDF



 
 
Thread Tools Display Modes
  #1  
Old May 25th, 2010, 04:38 PM posted to microsoft.public.access.reports
Charlotte[_2_]
external usenet poster
 
Posts: 20
Default Hyperlink to Page number in Report that is exported to PDF

I am using the Inittoc() function to generate a Table of Contents from
a source report. In addition, I am using Leban's ReporttoPDF code to
auto generate the PDF, with both the Table of Contents report and
source report combined. This all works.

I would really like the Table of Contents page numbers to hyperlink to
that page in the final report. Is this possible? I thought in the
[Page Number] text box control a TAG or hyperlink like #[Page Number]
would do, but I can't figure it out.

Thanks!
  #2  
Old May 25th, 2010, 08:29 PM posted to microsoft.public.access.reports
Mark Andrews[_4_]
external usenet poster
 
Posts: 169
Default Hyperlink to Page number in Report that is exported to PDF

I did something similar to create bookmarks in the pdf file (which are those
links that when clicked jump into the pdf).
I used the NovaPDF printer driver which has extra functionality and rules on
how to automatically setup bookmarks.
Perhaps you could use this pdf printer driver and rules to also achieve what
you want to do?

I know the win2pdf printer dirver takes text that looks like hyperlinks and
changes it to actual hyperlinks.
Maybe this would help if the hyperlink text you have is actually the
hyperlinks that are needed?

I do not know what capabilities the pdf creation (while using Leban's code)
is capable of?

There are probably other ways to merge two pdf files together and you can
have code use other pdf printer drivers
(however sometimes registry settings are needed via code). Lebans's code
does make it easy to make pdf files.

Hope this helps,
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

"Charlotte" wrote in message
...
I am using the Inittoc() function to generate a Table of Contents from
a source report. In addition, I am using Leban's ReporttoPDF code to
auto generate the PDF, with both the Table of Contents report and
source report combined. This all works.

I would really like the Table of Contents page numbers to hyperlink to
that page in the final report. Is this possible? I thought in the
[Page Number] text box control a TAG or hyperlink like #[Page Number]
would do, but I can't figure it out.

Thanks!


  #3  
Old May 25th, 2010, 08:50 PM posted to microsoft.public.access.reports
Charlotte[_2_]
external usenet poster
 
Posts: 20
Default Hyperlink to Page number in Report that is exported to PDF

On May 25, 3:29*pm, "Mark Andrews"
wrote:
I did something similar to create bookmarks in the pdf file (which are those
links that when clicked jump into the pdf).
I used the NovaPDF printer driver which has extra functionality and rules on
how to automatically setup bookmarks.
Perhaps you could use this pdf printer driver and rules to also achieve what
you want to do?

I know the win2pdf printer dirver takes text that looks like hyperlinks and
changes it to actual hyperlinks.
Maybe this would help if the hyperlink text you have is actually the
hyperlinks that are needed?

I do not know what capabilities the pdf creation (while using Leban's code)
is capable of?

There are probably other ways to merge two pdf files together and you can
have code use other pdf printer drivers
(however sometimes registry settings are needed via code). *Lebans's code
does make it easy to make pdf files.

Hope this helps,
Mark Andrews
RPT Softwarehttp://www.rptsoftware.comhttp://www.donationmanagementsoftware.com

"Charlotte" wrote in message

...

I am using the Inittoc() function to generate a Table of Contents from
a source report. *In addition, I am using Leban's ReporttoPDF code to
auto generate the PDF, with both the Table of Contents report and
source report combined. *This all works.


I would really like the Table of Contents page numbers to hyperlink to
that page in the final report. *Is this possible? *I thought in the
[Page Number] text box control a TAG or hyperlink like #[Page Number]
would do, but I can't figure it out.


Thanks!


Thank you. I saw your posting regarding NovaPDF, but was hoping I
could find a free solution. I will download the trial version and see
if it does the trick.

Thanks
  #4  
Old May 26th, 2010, 02:49 PM posted to microsoft.public.access.reports
Mark Andrews[_4_]
external usenet poster
 
Posts: 169
Default Hyperlink to Page number in Report that is exported to PDF

It was a while ago but I think you need the professional version of the
product or something like that.
There are a few versions and the one with the rules to make bookmarks is the
most expensive I think.

Mark

"Charlotte" wrote in message
...
On May 25, 3:29 pm, "Mark Andrews"
wrote:
I did something similar to create bookmarks in the pdf file (which are
those
links that when clicked jump into the pdf).
I used the NovaPDF printer driver which has extra functionality and rules
on
how to automatically setup bookmarks.
Perhaps you could use this pdf printer driver and rules to also achieve
what
you want to do?

I know the win2pdf printer dirver takes text that looks like hyperlinks
and
changes it to actual hyperlinks.
Maybe this would help if the hyperlink text you have is actually the
hyperlinks that are needed?

I do not know what capabilities the pdf creation (while using Leban's
code)
is capable of?

There are probably other ways to merge two pdf files together and you can
have code use other pdf printer drivers
(however sometimes registry settings are needed via code). Lebans's code
does make it easy to make pdf files.

Hope this helps,
Mark Andrews
RPT
Softwarehttp://www.rptsoftware.comhttp://www.donationmanagementsoftware.com

"Charlotte" wrote in message

...

I am using the Inittoc() function to generate a Table of Contents from
a source report. In addition, I am using Leban's ReporttoPDF code to
auto generate the PDF, with both the Table of Contents report and
source report combined. This all works.


I would really like the Table of Contents page numbers to hyperlink to
that page in the final report. Is this possible? I thought in the
[Page Number] text box control a TAG or hyperlink like #[Page Number]
would do, but I can't figure it out.


Thanks!


Thank you. I saw your posting regarding NovaPDF, but was hoping I
could find a free solution. I will download the trial version and see
if it does the trick.

Thanks


  #5  
Old May 26th, 2010, 06:22 PM posted to microsoft.public.access.reports
Charlotte[_2_]
external usenet poster
 
Posts: 20
Default Hyperlink to Page number in Report that is exported to PDF

On May 26, 9:49*am, "Mark Andrews"
wrote:
It was a while ago but I think you need the professional version of the
product or something like that.
There are a few versions and the one with the rules to make bookmarks is the
most expensive I think.

Mark

"Charlotte" wrote in message

...

On May 25, 3:29 pm, "Mark Andrews"
wrote:
I did something similar to create bookmarks in the pdf file (which are
those
links that when clicked jump into the pdf).
I used the NovaPDF printer driver which has extra functionality and rules
on
how to automatically setup bookmarks.
Perhaps you could use this pdf printer driver and rules to also achieve
what
you want to do?


I know the win2pdf printer dirver takes text that looks like hyperlinks
and
changes it to actual hyperlinks.
Maybe this would help if the hyperlink text you have is actually the
hyperlinks that are needed?


I do not know what capabilities the pdf creation (while using Leban's
code)
is capable of?


There are probably other ways to merge two pdf files together and you can
have code use other pdf printer drivers
(however sometimes registry settings are needed via code). *Lebans's code
does make it easy to make pdf files.


Hope this helps,
Mark Andrews
RPT
Softwarehttp://www.rptsoftware.comhttp://www.donationmanagementsoftware.com


"Charlotte" wrote in message


....


I am using the Inittoc() function to generate a Table of Contents from
a source report. *In addition, I am using Leban's ReporttoPDF code to
auto generate the PDF, with both the Table of Contents report and
source report combined. *This all works.


I would really like the Table of Contents page numbers to hyperlink to
that page in the final report. *Is this possible? *I thought in the
[Page Number] text box control a TAG or hyperlink like #[Page Number]
would do, but I can't figure it out.


Thanks!


Thank you. *I saw your posting regarding NovaPDF, but was hoping I
could find a free solution. I will download the trial version and see
if it does the trick.


Thanks


I tested novaPDF and it works great. However, it seems that Leban's
ReporttoPDF code is generating the PDF from registry settings or some
other method, because it is not using the novaPDF print driver, even
if I have novaPDF installed as the default printer and even tried
renaming it to 'Adobe PDF'. I know Leban's code passes it to snapshot
format first. I will continue to dig deeper on this, but does anyone
have ideas?
  #6  
Old May 26th, 2010, 07:50 PM posted to microsoft.public.access.reports
Charlotte[_2_]
external usenet poster
 
Posts: 20
Default Hyperlink to Page number in Report that is exported to PDF

On May 26, 1:22*pm, Charlotte wrote:
On May 26, 9:49*am, "Mark Andrews"



wrote:
It was a while ago but I think you need the professional version of the
product or something like that.
There are a few versions and the one with the rules to make bookmarks is the
most expensive I think.


Mark


"Charlotte" wrote in message


....


On May 25, 3:29 pm, "Mark Andrews"
wrote:
I did something similar to create bookmarks in the pdf file (which are
those
links that when clicked jump into the pdf).
I used the NovaPDF printer driver which has extra functionality and rules
on
how to automatically setup bookmarks.
Perhaps you could use this pdf printer driver and rules to also achieve
what
you want to do?


I know the win2pdf printer dirver takes text that looks like hyperlinks
and
changes it to actual hyperlinks.
Maybe this would help if the hyperlink text you have is actually the
hyperlinks that are needed?


I do not know what capabilities the pdf creation (while using Leban's
code)
is capable of?


There are probably other ways to merge two pdf files together and you can
have code use other pdf printer drivers
(however sometimes registry settings are needed via code). *Lebans's code
does make it easy to make pdf files.


Hope this helps,
Mark Andrews
RPT
Softwarehttp://www.rptsoftware.comhttp://www.donationmanagementsoftware.com


"Charlotte" wrote in message


...


I am using the Inittoc() function to generate a Table of Contents from
a source report. *In addition, I am using Leban's ReporttoPDF code to
auto generate the PDF, with both the Table of Contents report and
source report combined. *This all works.


I would really like the Table of Contents page numbers to hyperlink to
that page in the final report. *Is this possible? *I thought in the
[Page Number] text box control a TAG or hyperlink like #[Page Number]
would do, but I can't figure it out.


Thanks!


Thank you. *I saw your posting regarding NovaPDF, but was hoping I
could find a free solution. I will download the trial version and see
if it does the trick.


Thanks


I tested novaPDF and it works great. However, it seems that Leban's
ReporttoPDF code is generating the PDF from registry settings or some
other method, because it is not using the novaPDF print driver, even
if I have novaPDF installed as the default printer and even tried
renaming it to 'Adobe PDF'. I know Leban's code passes it to snapshot
format first. *I will continue to dig deeper on this, but does anyone
have ideas?


BTW - this seems to be an issue of the bookmarks being retained when
using NovaPDF to convert from .snp (snapshot) format; and not an issue
w/ Leban's code. I sent an email to the NovaPDF vendor inquiring
if .snp format is supported.
 




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


All times are GMT +1. The time now is 04:14 AM.


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