Hyperlink functions

[Pieter]

Hi,

I want to add a function to a hyperlink field. The program
should automaticly fill in the following :

http://myaddress/+"field"+.html

where field is another field, for example with the
name 'firm', in the database of the type text.

I think you can let Access do this but how ?

Suggestions and help are very welcome.

 

[Dirk Goldgar]

Hi,

I want to add a function to a hyperlink field. The program
should automaticly fill in the following :

http://myaddress/+"field"+.html

where field is another field, for example with the
name 'firm', in the database of the type text.

I think you can let Access do this but how ?

Suggestions and help are very welcome.

Something like

Application.FollowHyperlink _
"http://" & "myaddress/" & Me.[FieldName] & ".html"

if I understand you correctly. Note: I had to break the literal prefix
of the address into two pieces to keep the newsreader from
re-interpreting it. That's not really necessary in your code, but I'm
not even sure how it's going to display when your newsreader sees this
message.