Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-02-2018, 04:40 AM   #1
Jab331
Newly Registered User
 
Join Date: Sep 2018
Posts: 15
Thanks: 1
Thanked 0 Times in 0 Posts
Jab331 is on a distinguished road
Button to follow a hyperlink in a hidden textbox

I have a hidden textbox in a form that contains a link to a folder full of pictures. I have created a small button on the form that i would like to follow the link in the hidden textbox and bring up the relevant pictures. What is the code needed for this?

Jab331 is offline   Reply With Quote
Old 10-02-2018, 06:13 AM   #2
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,366
Thanks: 112
Thanked 2,845 Times in 2,593 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: Button to follow a hyperlink in a hidden textbox

See if you can adapt the attached:
Attached Files
File Type: zip FolderImages v3.zip (119.2 KB, 14 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
Old 10-02-2018, 06:33 AM   #3
Jab331
Newly Registered User
 
Join Date: Sep 2018
Posts: 15
Thanks: 1
Thanked 0 Times in 0 Posts
Jab331 is on a distinguished road
Re: Button to follow a hyperlink in a hidden textbox

I've had a play about and to be honest i am completely lost...Sorry.

I think this is way more complicated than anything i am asking for?

Jab331 is offline   Reply With Quote
Old 10-02-2018, 06:44 AM   #4
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,366
Thanks: 112
Thanked 2,845 Times in 2,593 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: Button to follow a hyperlink in a hidden textbox

All you need to do is click the 'Populate' button and select an image folder.
This will populate the listbox.
Click any image in the list to view it.

Click View All Images to view a report with thumbnails of all images in the folder.

HTH
__________________
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 10-02-2018, 06:50 AM   #5
Jab331
Newly Registered User
 
Join Date: Sep 2018
Posts: 15
Thanks: 1
Thanked 0 Times in 0 Posts
Jab331 is on a distinguished road
Re: Button to follow a hyperlink in a hidden textbox

I have managed to populate the images but that is not the code i require.

The images i want to display are in thousands of different folders across different drives so whenever a record is loaded on to the form a hidden text box includes the hyperlink to the correct folder full of relevant images. I just need to somehow link the button in the form to the click action of the hidden hyperlink so the correct folder is opened.

Thanks,
Jab331 is offline   Reply With Quote
Old 10-02-2018, 07:25 AM   #6
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,366
Thanks: 112
Thanked 2,845 Times in 2,593 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: Button to follow a hyperlink in a hidden textbox

If you want to view all images in your folder at once, I suggest you use an ActiveX web browser control. AWF member static did an example movie database last year showing loads of DVD cover images. A forum search should find it.

Otherwise if you're happy with the idea from my example database adapt the code in the cmdPopulateImageList. Start at the line strSourceFolder =...
and change it to the folder path in your hidden textbox. However you don't want this to be a hyperlink

Good luck with your project. Signing out now

__________________
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
Reply

Tags
button , form , hyperlink

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Follow Hyperlink help please ChunkyChats Modules & VBA 6 09-05-2016 06:26 AM
Btn to run query then follow hyperlink? jbphoenix Forms 1 12-12-2007 09:47 AM
Follow Hyperlink to Folder karl05 Modules & VBA 2 08-02-2007 12:10 AM
Using Hyperlink.Follow AccessTest Modules & VBA 9 04-05-2007 07:04 AM
Follow Hyperlink Daryl Modules & VBA 5 01-09-2002 09:52 AM




All times are GMT -8. The time now is 08:02 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