Check Help for Application.FollowHyperlink -- there must be a COM-enabled
program registered for the file type. That is, if you want to open an Excel
file, you must have some software that automatically is used with Excel
files (one logical candidate would be MS Excel, of course).
Larry Linson
Microsoft Access MVP
"Dave" <no.spam.for.???@my.email.is.invalidwrote in message
news:Bgeii.20005$3j1.9589@newsfe6-gui.ntli.net...
Quote:
It's just a link if you like, so when the user clicks on it, it then opens
an excel file for example.
>
"DavidB" <jebva@yahoo.comwrote in message
news:1183401425.065385.17740@n2g2000hse.googlegrou ps.com...
Quote:
>On Jul 2, 2:13 pm, "Dave" <no.spam.for....@my.email.is.invalidwrote:
Quote:
>>I have a simple little database with name data. I want the user when
>>they
>>double click the name in the database, for a file to open up
>>automatically
>>which is stored in the C Drive say, I don't want Access to close though,
>>I
>>want it running in the background along with the newly opened file. I'm
>>a
>>novice at coding with events so I have no clue at all where to start
>>with
>>this. Any ideas techs?
>>
>What kind of file?
>Is there a different file for each user?
>WIll it be a static or dynamic path/filename?
>>
>
>