Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 16th, 2005, 03:14 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default Links to web pages

I need to be able to setup a listbox with hyperlinks in it and when the user clicks the hyperlink is diverts to the web pages

I am using the following code but does not work

m_ctlhyperlink.hyperlink.follow

Thanks
Brendan

Brendan Bartley
__________________
Brendan Bartley
 
Old September 16th, 2005, 04:48 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Brendan,

I created a table with a ID, and Textbox for the hyperlink. It's important that the hyperlink is text.
I then created a listbox on my form with the hyperlinks in the listbox.

In the onclick event for the listbox here's the code:

   Application.FollowHyperlink Me.List8.Column(1), , True

Since I was pulling 2 columns (ID, Hyperlink) I had to point at the second column. If your listbox is 1 column only, eliminate the .column(1)

Hope this works!

Kevin

dartcoach
 
Old September 16th, 2005, 05:21 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Kevin
I am getting a run time error 7971 when I use you're code

IT helpdesk can't follow the hyperlink to #http//intranet/helpdesk/Templates/invanscanner.asp#

Brendan Bartley
 
Old September 16th, 2005, 05:25 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Brendan,

try taking the # signs out of the address. Plus, it looks like you're missing the : afer http. For this code to work, it has to be straight text:

http://intranet/helpdesk/templates/invanscanner.asp

Kevin

dartcoach
 
Old September 16th, 2005, 05:51 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Brendan,

Is this a data page or an Access form?

Kevin

dartcoach
 
Old September 16th, 2005, 05:54 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Kevin this is a access form and I am using the web address http://intranet/helpdesk/Templates/invanfault2.asp

Thanks
Brendan

Brendan Bartley
 
Old September 16th, 2005, 05:58 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Brendan,

Did taking out the #'s work? I've got it working on my form with no problems.

I can send you a small .mdb with the list box and table if that would help.

Kevin

dartcoach
 
Old September 16th, 2005, 06:06 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes Kevin send that it does not work for me

Brendan Bartley





Similar Threads
Thread Thread Starter Forum Replies Last Post
Web Page links snufse ASP.NET 2.0 Basics 1 April 10th, 2008 11:57 PM
Web site links Groundhog1248 HTML Code Clinic 4 January 6th, 2005 01:09 PM
Web pages constructing: I-mode(mobile) pages karib Dreamweaver (all versions) 3 June 6th, 2004 09:48 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.