Button to Open File on My Form?

[Maillme]

Hi there,

I have a field that has my full file location - what code would i need to attached ot a button next to this field to open the file from my form? (it will be a .doc or .xls)

many thanks,
Neil

 

[RivetHed]

Have a look at the followhyperlink method.

 

[Maillme]

Many thanks.

I found thise usefull article also:

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

thanks,
Neil

 

[RivetHed]

That's the way to do it if you want to manipulate Word\Excel once you've opened it up but if you just want to open the file then followhyperlink is a lot less hassle.