Hyperlink on Form

[benwo]

Hi

I've got a a table that contain URL's. On the form i'm displaying the URL as a hyperlink but when i click on the link it does not open a browser.

Any ideas?

Ben

 

[whatever]

EDIT See next post, apologies for total lack of cursor control

 

[whatever]

I've tried this a few ways but the easiest is to:

1. Have the hyperlink in a text box
2. Add a command button to the form.
3. In the forms 'On current' event set the button's hyperlink property to be
the value of the text box.

This seems to work OK but gives little control of how the document is opened but my be Ok for your requirements.

HTH


Kevin

 

[Banaticus]

Create a label. Put whatever text you want in it.
Right click it and choose "Properties"
Third line down, under the ALL tag, is the "hyperlink address" field.
Put a DLookUp there that references the right spot in the table.

 

[ghudson]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

Help with Hyperlinking Please

 

[ansentry]

Have a look at the attached db sample, I think that this does what you want.

 

[benwo]

Thanks, i downloaded your zip file which works but if i go to a different record it throws up a run time error 490

 

[benwo]

Hi again

I've tried all of these ideas but i've not had any joy yet. the zip file works for the first record in the DB but when i go to the next one it kicks out an error. i have about 3000 records in the DB, each with individual URL's. i need to be able to go from record to record and access the URL. Of course i could copy and paste but i really dont want that!

Any more idea?

Thanks

Ben

 

[ansentry]

What do you mean by;

the zip file works for the first record in the DB

Did you extract the zip file to your desktop or some other folder before you tried it?

If you did and that is when you are getting the errors;

Which form are you in when this happens?

When you reply it help if you give as much descriptive information as you can.

 

[benwo]

check out this attachment, this should be clearer. there are 3 records in there. double click the url in the first record and it open fine but in the second and third it contains an error

 

[ansentry]

You didn't say it was your db that was not working. When you reply let the poster know what is happening. I thought it was my db that was giving you trouble and I am tring to find the fault.

Yours is now working, you had Google enter as;

www.google.co.uk

It should have been;

http://www.google.co.uk

I have make a couple of changes, and as I have given it another name it will not over write your when you unzip it.

The changes are:

Your hyperlinks are blue and underlined.
When you double click the hyperlink the record is saved before it tries to open the link.
The form will maximize when opened.

You can just ignore them if you wish.

Good luck with your project

 

[benwo]

Hi John

Thanks v.much - You've just saved my a$$

Cheers

Ben

 

[ansentry]

Glad to help