Connecting Tech Pros Worldwide Forums | Help | Site Map

Double click event

Dave
Guest
 
Posts: n/a
#1: Jul 2 '07
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?



DavidB
Guest
 
Posts: n/a
#2: Jul 2 '07

re: Double click event


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?

Dave
Guest
 
Posts: n/a
#3: Jul 2 '07

re: Double click event


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?
>

Larry Linson
Guest
 
Posts: n/a
#4: Jul 3 '07

re: Double click event


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?
>>
>
>

Closed Thread