Link a data file to a control in an access form

[KiaKia]

Hi everyone,
How can I make a link to a datafile and open the file by clicking the link from my access form?

Any comment is appreciated,
Kia

 

[Remou]

Create a field to store the path to your data file and use FollowHyperlink in the double-click event, rather than the click event, it is less irritating that way.

 

[KiaKia]

Hi Remou,
Thanks for your advice.
Would you please let me know if I can open a windows browser from the Onclick event of that field to make it easy for the user to choose the path to the file.

 

[nim180]

Hey KiaKia,

Take a look at this thread about halfway down, the code should let you browse your computer.

thread702-1467575

Hope that helps,
Nim

 

[Remou]

This is from MVPS.org:

http://www.mvps.org/access/api/api0001.htm

 

[KiaKia]

nim180,
Thanks it was very helpful.
I got the job done.

I recommend it to others too.

Kia

 

[TheAceMan1]

How are ya How are ya KiaKia . . .

Do have a look at one of the links at the bottom of my post. They both deal with etiquette here in the forums.

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886