Opening Different File Types from Form? 1

[Maillme]

Hi there,

I have some code on my form which i got from this very helpful topic here:

http://www.databasedev.co.uk/open_word_doc.html

However, my requirement is now to open different file types. E.g. there may be a word document in one record (which works fine) and a visio document in my next record (this doesn'twork as it tries to open this in visio.

Can anyone advise on any code changes i can do to allow this? And as simple as you can explain please as I'm no coder!

Many thanks for any help,


Neil

 

[PHV]

What about the Application.FollowHyperlink method ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Maillme]

Hi PHV,

how would i use this on my form?

I have the filepath held in a txt box (file_path).

many thanks,
Neil

 

[PHV]

Like this:

Application.FollowHyperlink Me!file_path

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Maillme]

Oh Deary Me, As simple as that!

Many thanks for your help!!

Neil