Hyperlink button for each record

Pinkoto

Registered User.
Local time
Yesterday, 20:54
Joined
Jun 25, 2014
Messages
73
Hello,
I'm a new user of access and i stumbled on a problem. I created a table about films and i made a form so i can see each movie in a different record. I wanted to create a button which generates a link to the movie's internet website. But when i create a button i cant put a different hyperlink for each record of the form.
My idea is the button to have a logo of the site so that is why i cant just put a link in a text box. I also tried embedding a hyperlink to a picture but again i had the same problem.. there was only one hyperlink for all the records :(.
I will be happy to receive any advise and help :)

PS: please have in mind I'm a recent user (2 days ago)
 
I gather you don't have a field for the Hyperlink and you are using a continuous form?
 
I gather you don't have a field for the Hyperlink and you are using a continuous form?
im using a normal form. i dont want it to be continuous
 
Is there a field for the Hyperlink? Oh, and how are you *generating* the website address?
 
i just go to "build hyperlink" and type the address there. then when i click on the button or the picture i go to the site. but i want to add different links for the other records.
 
Okay, that is not going to work. The button is the same on all the Forms. You could have a Field in the Table that holds the website address and then use...

Code:
Application.FollowHyperlink

However, no seperate pictures, so one picture for the button.

As a beginner in Access, these links might be useful on your journey...

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page...
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials

UtterAccess Newcomer's Reading List
http://www.utteraccess.com/forum/Newcomer-s-Reading-List-t1998783.html

Sample data models...
http://www.databasedev.co.uk/table-of-contents.html
http://www.databaseanswers.org/data_models/

Naming Conventions…
http://www.access-diva.com/d1.html

Other helpful tips…

Setting up a Model Database
http://www.access-diva.com/d11.html

My Database Standards...
http://regina-whipp.com/blog/?p=102
 
where do i enter the code? i guess i have to create a button, but after that where do i enter
Application.FollowHyperlink
 
In the On_Click of the Button. Oh, you also need to add the Text Box, i.e...

Code:
Application.FollowHyperlink Me.YourTextBox
 
I made a field in the table named Field1 which has the link for the website. i put it in the form. after that i made a button and in on_click i entered

Private Sub Command93_Click()
Application.FollowHyperlink Me.Field1
End Sub

after that i click on the button and a error appears.
run time error 7971:
Microsoft Access cannot follow the hyperlink to '#thewebsite.
 
Is there a website in there? Is it the entire line or an abbreviated version?
 
it shows the link correctly '#thecorectlink#1'.

I'm sorry that i don't give the link but i don't have permission the post links.
 
Show me any link, even Google, just show me how it's entered in the Table...

http...

OR

www...
 
and my link begins with httc:// , i've entered the entire link

and im doing this on the properties of the button
 
i did it on another record only with www and it showed me the same error but it showed me two links mine with www and another with http

ps: in my last post i entered httc but it was a mistake in the table its correct http
 
no i mean i enter the code you gave me in the properties of the button and the link i put in the table field1
 
Oops :o, make sure the field in the Table is plain text.
 
yeeeeee IT WORKED!!!!!!!!!!!!!!!!!!!!!!!!! THANK YOU SO MUCH :)))))))))))))))))))))))))))) YOU MADE MY DAY! i made the field as hyperlink in the table that's why it didn't work before!!!! thank you for your patience and fast replies!!! I wouldn't have done it without you!!
 
WOW! :eek:

Thanks... and glad we worked it out. (It was my fault :o, I said Hyperlink for field when I forgot it has to be Text.)
 
Okay... I got a notification that you posted but I don't see anything added, did it fall into a black hole or did you delete it?
 

Users who are viewing this thread

Back
Top Bottom