Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-27-2017, 10:30 AM   #1
nickaccess
Newly Registered User
 
Join Date: Jul 2017
Posts: 43
Thanks: 17
Thanked 0 Times in 0 Posts
nickaccess is on a distinguished road
Unhappy Access Report to PDF loses unique URLs

Hi Guys

This is going to sound really weird. I have managed to create an Access report that has unique URLs to each record that will take you online, to again a unique place. It all works brilliantly in the report when I have it opened in access, it goes direct to each record(online) with no problem at all.

When I use the Access program to create a PDF (or XPS), here I want PDF only, it saves the unique URL but it adds the file directory to the beginning of the URL in the PDF, so this then takes me to our company intranet (internal page) and not the unique URL. No matter what I do when converting it to PDF it will put the file directory I have saved it to in front of each unique URL. Am I going mad and not doing something. I have never seen this before and its driving me nuts.

so instead of the URL reading:

worldwideweb.uniquerecord.6458b.co.uk

In the PDF is says

c:/general/files/nick/worldwideweb.uniquerecord.6458b.co.uk

Can anyone help or make a suggestion. THANK YOU all so much. There isn't an icon with tears on it

nickaccess is offline   Reply With Quote
Old 07-27-2017, 11:27 AM   #2
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,085
Thanks: 110
Thanked 2,739 Times in 2,500 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Access Report to PDF loses unique URLs

Hi again

Presumably you start with www rather than worldwideweb!
Have you tried putting http:// at the start?

Unless that fixes it, please post the code you use to create PDFs from your reports.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by isladogs; 07-27-2017 at 11:33 AM.
isladogs is offline   Reply With Quote
Old 07-28-2017, 01:06 AM   #3
nickaccess
Newly Registered User
 
Join Date: Jul 2017
Posts: 43
Thanks: 17
Thanked 0 Times in 0 Posts
nickaccess is on a distinguished road
Unhappy Re: Access Report to PDF loses unique URLs

[QUOTE=ridders;1540804]Hi again

I am not allowed to post links at this moment in time hence below looking a little weird (put all together to get link as I have built it)

The coding I am using is as follows:

h(tee)tps
:
/
/
planning.
Plymouth(dot)

gov(dot)
uk/
online-applications/applicationDetails(dot)do?activeTab(equals)summary &keyVal(equals)[KEYVAL]

This looks for the keyVal which is the reference number of that particular application and goes to with no trouble at all when you run the report. When I pdf it, it then looks like this.

file////cifs01/home$/KingNX/desktop (followed by the URL above).

Really not sure why it is saving the file path and adding it into the URL?

That means it just goes to my internal systems.

nickaccess is offline   Reply With Quote
Old 07-28-2017, 02:28 AM   #4
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,085
Thanks: 110
Thanked 2,739 Times in 2,500 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Access Report to PDF loses unique URLs

OK 2 things:

1. New members can only upload zip files (to help prevent spam)
- the restriction is lifted after 10 posts

2. Use the code tag in the toolbar - it's the # 'button'
So is that:

Code:
https://planning.Plymouth.gov.uk/online-applications/applicationDetails.do?activeTab=summary &keyVal=[KEYVAL]
No idea why it adds the
Quote:
file////cifs01/home$/KingNX/desktop (followed by the URL above).
Try zipping a stripped down version of the relevant bit of your db for someone to look at.
It will probably not be me as I'm logging off shortly but hopefully someone else will step in
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
nickaccess (07-28-2017)
Old 07-28-2017, 02:55 AM   #5
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,356
Thanks: 159
Thanked 1,706 Times in 1,676 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: Access Report to PDF loses unique URLs

Is the field stored as a hyperlink? If it is they don't play nice with pdf conversion.

Change it to a text field or create a text version of it in the underlying query and it will probably work.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 07-28-2017, 04:39 AM   #6
nickaccess
Newly Registered User
 
Join Date: Jul 2017
Posts: 43
Thanks: 17
Thanked 0 Times in 0 Posts
nickaccess is on a distinguished road
Re: Access Report to PDF loses unique URLs

Quote:
Originally Posted by ridders View Post
OK 2 things:

1. New members can only upload zip files (to help prevent spam)
- the restriction is lifted after 10 posts

2. Use the code tag in the toolbar - it's the # 'button'
So is that:

Code:
https://planning.Plymouth.gov.uk/online-applications/applicationDetails.do?activeTab=summary &keyVal=[KEYVAL]
No idea why it adds the


Try zipping a stripped down version of the relevant bit of your db for someone to look at.
It will probably not be me as I'm logging off shortly but hopefully someone else will step in
Thanks but it still will not work, I suppose it is the simplest of things, will attack it next week when I am not frazzled. Thank you for all of you help so far, I really appreciate it. Have a lovely weekend.
nickaccess is offline   Reply With Quote
Old 07-28-2017, 04:43 AM   #7
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,085
Thanks: 110
Thanked 2,739 Times in 2,500 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Access Report to PDF loses unique URLs

Still here!

Just saw the reply in my email notification & noticed the space in your hyperlink after summary.

Try:
Code:
https://planning.Plymouth.gov.uk/online-applications/applicationDetails.do?activeTab=summary&keyVal=[KEYVAL]
Failing that, check out Minty's response

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by isladogs; 07-28-2017 at 04:52 AM.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
nickaccess (07-28-2017)
Old 07-28-2017, 04:49 AM   #8
nickaccess
Newly Registered User
 
Join Date: Jul 2017
Posts: 43
Thanks: 17
Thanked 0 Times in 0 Posts
nickaccess is on a distinguished road
Re: Access Report to PDF loses unique URLs

Quote:
Originally Posted by Minty View Post
Is the field stored as a hyperlink? If it is they don't play nice with pdf conversion.

Change it to a text field or create a text version of it in the underlying query and it will probably work.

I am losing the will on this one and maybe I should leave it until next week. I have tried the above and I still call not it to work. Maybe when I can post screen shots etc it may make it easier to understand. Thank you so much for your help so far, I really appreciate it. Have a lovely weekend.
nickaccess is offline   Reply With Quote
Old 07-28-2017, 04:53 AM   #9
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,085
Thanks: 110
Thanked 2,739 Times in 2,500 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Access Report to PDF loses unique URLs

Nick

I just edited my last post - have a look again.
The space is almost certainly the problem
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 07-28-2017, 05:06 AM   #10
nickaccess
Newly Registered User
 
Join Date: Jul 2017
Posts: 43
Thanks: 17
Thanked 0 Times in 0 Posts
nickaccess is on a distinguished road
Re: Access Report to PDF loses unique URLs

Quote:
Originally Posted by ridders View Post
Nick

I just edited my last post - have a look again.
The space is almost certainly the problem
No luck I am afraid. I am signing off, I do not want to give up on this one, it the last report of over 50 I have written. Brain needs to rest hahahaha, getting old. Thank you
nickaccess is offline   Reply With Quote
Old 07-28-2017, 05:19 AM   #11
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,085
Thanks: 110
Thanked 2,739 Times in 2,500 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Access Report to PDF loses unique URLs

Just in case you're still there: I tried this

Code:
Sub TEST()

Dim strKeyword As String
strKeyword = "OTOUA5MMJCW00"
Application.FollowHyperlink "https://planning.plymouth.gov.uk/online-applications/applicationDetails.do?activeTab=summary&keyVal=" & strKeyword & ""
End Sub
It took me to the specified webpage
Worth a try?
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 07-28-2017, 05:28 AM   #12
nickaccess
Newly Registered User
 
Join Date: Jul 2017
Posts: 43
Thanks: 17
Thanked 0 Times in 0 Posts
nickaccess is on a distinguished road
Re: Access Report to PDF loses unique URLs

Quote:
Originally Posted by ridders View Post
Just in case you're still there: I tried this

Code:
Sub TEST()

Dim strKeyword As String
strKeyword = "OTOUA5MMJCW00"
Application.FollowHyperlink "https://planning.plymouth.gov.uk/online-applications/applicationDetails.do?activeTab=summary&keyVal=" & strKeyword & ""
End Sub
It took me to the specified webpage
Worth a try?
It should take you to a unique record of an application. Will try it all next week I am getting really confused now. Sorry, I have to say it confusing me so much. Maybe when I am fresher I can give it all a go. Its not the link that's the issue as far as I can see. They all work perfectly when I run the report and can link to every unique application number I want to and it goes to the online application and page. Its when I convert to PDF it add the file location I save it to and the URL. Are we saying by changing the link or messing around with it, this issue will not happen? Sorry again for causing this issue for you guys. I am always thankful for any help.
nickaccess is offline   Reply With Quote
Old 07-28-2017, 05:39 AM   #13
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,085
Thanks: 110
Thanked 2,739 Times in 2,500 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Access Report to PDF loses unique URLs

Quote:
It should take you to a unique record of an application.
Yes it did so. I did a search on the site & found a random planning application

As an experiment, I've just saved a report of mine containing a hyperlink as a PDF and the link worked absolutely fine from the PDF.

I can't think of any reason why converting to PDF would cause it.
There must be an error in your code

Leave it till Monday & post your code if you still can't fix it
Have a good weekend
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by isladogs; 07-29-2017 at 11:52 PM.
isladogs is offline   Reply With Quote
Old 07-31-2017, 01:21 AM   #14
nickaccess
Newly Registered User
 
Join Date: Jul 2017
Posts: 43
Thanks: 17
Thanked 0 Times in 0 Posts
nickaccess is on a distinguished road
Re: Access Report to PDF loses unique URLs

Quote:
Originally Posted by ridders View Post
Yes it did so. I did a search on the site & found a random planning application

As an experiment, I've just saved a report of mine containing a hyperlink as a PDF and the link worked absolutely fine from the PDF.

I can't think of any reason why converting to PDF would cause it.
There must be an error in your code

Leave it till Monday & post your code if you still can't fix it
Have a good weekend
Hi ridders,

Thanks for all of the advice. The coding is as follows:

https://planning.plymouth.gov.uk=online-applicationsapplicationDetails.do=activeTab=summar ykeyVal=[KEYVAL]
It looks like this in the bottom bar.
https://planning.plymouth.gov.uk/[...]/applicationDetails.do?[...]=[...]&keyVal=[...]
Ok here goes. We have a field called REFVAL (eg 17/01125/FUL) that relates to the actual application number.The system stores this as a keyVAL (OE14587896K125), again this would be a unique number the system gives it but is still linked to the REFVAL.The above link will take you to the actual application online using the keyVal as this is the system number for what we enter as the reference number (REFVAL).It works brilliantly in the report when you have it on screen and each links works and goes directly to the application for everyone to see, but as I have said in my feed when I PDF it,it seems to add the file path of where I am saving it to the beginning of each link (never had this before). Also can I do screen shots and add them??? Thanks to everyone especially ridders.
nickaccess is offline   Reply With Quote
Old 07-31-2017, 01:40 AM   #15
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,085
Thanks: 110
Thanked 2,739 Times in 2,500 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Access Report to PDF loses unique URLs

Quote:
Originally Posted by nickaccess View Post
Hi ridders,

Thanks for all of the advice. The coding is as follows:

https://planning.plymouth.gov.uk=online-applicationsapplicationDetails.do=activeTab=summar ykeyVal=[KEYVAL]
It looks like this in the bottom bar.
https://planning.plymouth.gov.uk/[...]/applicationDetails.do?[...]=[...]&keyVal=[...]
Ok here goes. We have a field called REFVAL (eg 17/01125/FUL) that relates to the actual application number.The system stores this as a keyVAL (OE14587896K125), again this would be a unique number the system gives it but is still linked to the REFVAL.The above link will take you to the actual application online using the keyVal as this is the system number for what we enter as the reference number (REFVAL).It works brilliantly in the report when you have it on screen and each links works and goes directly to the application for everyone to see, but as I have said in my feed when I PDF it,it seems to add the file path of where I am saving it to the beginning of each link (never had this before). Also can I do screen shots and add them??? Thanks to everyone especially ridders.
Yes you can post screenshots like this one which is the page opened using my code in post #11



See here for instructions https://www.access-programmers.co.uk...d.php?t=194680

However it might save time if you could post a stripped down version of your db removing any confidential data
Attached Images
File Type: png Capture.PNG (44.9 KB, 336 views)

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
nickaccess (07-31-2017)
Reply

Tags
reports , unique , url

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Access Forms using VBA to auto login in https URLs Chuckie Modules & VBA 1 05-08-2013 06:56 AM
using a batch file to import multiple urls into access db JustJill54 Tables 0 04-11-2007 05:16 AM
Report loses custom paper setting jcobas Reports 0 02-09-2007 03:16 AM
Report-Export to excel loses properties B&R Reports 0 02-08-2004 11:37 AM
[SOLVED] Exporting Access report to HTML loses pictures Mike VE Reports 0 04-18-2000 01:08 PM




All times are GMT -8. The time now is 07:17 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World