Hyperlink button for each record

[Pinkoto]

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)

 

[GinaWhipp]

I gather you don't have a field for the Hyperlink and you are using a continuous form?

 

[Pinkoto]

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

 

[GinaWhipp]

Is there a field for the Hyperlink? Oh, and how are you *generating* the website address?

 

[Pinkoto]

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.

 

[GinaWhipp]

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...

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

 

[Pinkoto]

where do i enter the code? i guess i have to create a button, but after that where do i enter
Application.FollowHyperlink

 

[GinaWhipp]

In the On_Click of the Button. Oh, you also need to add the Text Box, i.e...

Application.FollowHyperlink Me.YourTextBox

 

[Pinkoto]

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.

 

[GinaWhipp]

Is there a website in there? Is it the entire line or an abbreviated version?

 

[Pinkoto]

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.

 

[GinaWhipp]

Show me any link, even Google, just show me how it's entered in the Table...

http...

OR

www...

 

[Pinkoto]

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

and im doing this on the properties of the button

 

[GinaWhipp]

It has to be entered in the field in the table.

 

[Pinkoto]

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

 

[Pinkoto]

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

 

[GinaWhipp]

Oops , make sure the field in the Table is plain text.

 

[Pinkoto]

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!!

 

[GinaWhipp]

WOW!

Thanks... and glad we worked it out. (It was my fault , I said Hyperlink for field when I forgot it has to be Text.)

 

[GinaWhipp]

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?