Hyperlinks HELP please

[smithers_steven]

Being new to Access I do not know much about hyperlinks.
But what ai need to do is this:

1) I have a table with about 1000 lines of data . One
field of each line is a hyperlink to another file on my c
drive.
2) I have to type in each link seperately ever time I
enter new data. However the address is always the same
except for the ending file name
For example : c:\damage files\123456
c:\damage files\123457
c:\damage files\123458 etc etc ...
3)My data in the Hyperlink field is the "file name" 123456
or 123457 or 123458 etc .......

does any one have any Ideas????

 

[Albert D. Kallal]

First, there is not a need to use hyper link fields anyway. I find them a
bit of a hassle, and for importing, or export the hyper link fields, they
are a pain.

It is just best to use a regular field,a and place a button right beside the
field to launch the file. The code behind the button can be:

Application.FollowHyperLink me!AppName

As for those files on drive c:, I would assume that you plan to send, or
generate a list of those file (you not going to type them...as you really
don't have to).

I would make a another field with the path name, and set the default to the
current path name. That way, you only enter the file name. What is great
about this approach is if you ever decide to change the path name or dir
where all the files are, then you just do a replace on the path name field,
and you are done. Thus, you can easily manage where the files go.

So, I would in fact not have used hyper link fields, but just two standard
text fields.

So, if you use two fields, then the above code would become:

Application.FollowHyperLink me!PathName & "\" & "me!AppName

As mentioned, you could even write code to pop up the browse window, browse
to a dir, and then have that list of files from that dir sucked into the
access table. This whole process can be automated. Regardless, I would not
play with, or even bother with hyper link fields. Using standard fields as
above is not only more manageable, but you can even export, or even import
lists from Excel etc. Trying to export hyperlink fields to excel is not very
good for example.

 

[Guest]

How that sound easier than what I am doing! however I
really am a self taught person. and I think that is a bit
confusing. I am not familiar with the terms you are using .

Question 1) How can i put a button in a table

and I do have many others, any good suggestions where to
and how to understand more of this stuff


steven

 

[Arvin Meyer]

How that sound easier than what I am doing! however I
really am a self taught person. and I think that is a bit
confusing. I am not familiar with the terms you are using .

Question 1) How can i put a button in a table

You cannot put a button in a table. But then you should not be adding or
editing records in a table anyway. Tables are for storage and to control
data integrity. You can add a button to a row of data in a continuous form.
You can also put a button on the header or footer of a continuous form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Dirk Goldgar]

Being new to Access I do not know much about hyperlinks.
But what ai need to do is this:

1) I have a table with about 1000 lines of data . One
field of each line is a hyperlink to another file on my c
drive.
2) I have to type in each link seperately ever time I
enter new data. However the address is always the same
except for the ending file name
For example : c:\damage files\123456
c:\damage files\123457
c:\damage files\123458 etc etc ...
3)My data in the Hyperlink field is the "file name" 123456
or 123457 or 123458 etc .......

does any one have any Ideas????

Although I agree with Albert Kallal about generally not using hyperllink
fields, but using Application.FollowHyperlink to "follow" text
hyperlinks instead, your problem may be resolved by setting the
database's HyperlinkBase property. Search for "hyperlink base" in the
online help for more information. All you do is click File -> Database
Properties... and enter the common path in the "Hyperlink base" box of
the properties dialog.