By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,222 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,222 IT Pros & Developers. It's quick & easy.

How to mimic a doubleclick in VBA

P: n/a
Hello all,
I am making a database for my employer to be able to put in an archive of
all letters recieved. The letters are scanned and stored in a certain
directory as *.jpg, or *.pdf.
What I want to do is make a form to lookup a certain letter and once found,
give the user the ability to click on a button so that the image file opens.
What I want to know is the following: is there a way to mimic a doubleclick
on this file, so that whatever association the user has on his computer, the
file will open, be it in Window fax viewer, be it in Photoshop or whatever
.... so imagine that the file name is : 2004_1046.jpg
If this is at all possible, what would be the syntax then?
Thanks in advance!
Ronny Sigo
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Use FollowHyperlink, e.g.:
Application.FollowHyperlink "C:\2004_1046.jpg"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ronny Sigo" <ro********@skynet.be> wrote in message
news:41**********************@feed0.news.be.easyne t.net...
Hello all,
I am making a database for my employer to be able to put in an archive of
all letters recieved. The letters are scanned and stored in a certain
directory as *.jpg, or *.pdf.
What I want to do is make a form to lookup a certain letter and once
found,
give the user the ability to click on a button so that the image file
opens.
What I want to know is the following: is there a way to mimic a
doubleclick
on this file, so that whatever association the user has on his computer,
the
file will open, be it in Window fax viewer, be it in Photoshop or whatever
... so imagine that the file name is : 2004_1046.jpg
If this is at all possible, what would be the syntax then?
Thanks in advance!
Ronny Sigo

Nov 13 '05 #2

P: n/a
Thank you Allen, works great!
Ronny Sigo
"Allen Browne" <Al*********@SeeSig.Invalid> schreef in bericht
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
Use FollowHyperlink, e.g.:
Application.FollowHyperlink "C:\2004_1046.jpg"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ronny Sigo" <ro********@skynet.be> wrote in message
news:41**********************@feed0.news.be.easyne t.net...
Hello all,
I am making a database for my employer to be able to put in an archive of all letters recieved. The letters are scanned and stored in a certain
directory as *.jpg, or *.pdf.
What I want to do is make a form to lookup a certain letter and once
found,
give the user the ability to click on a button so that the image file
opens.
What I want to know is the following: is there a way to mimic a
doubleclick
on this file, so that whatever association the user has on his computer,
the
file will open, be it in Window fax viewer, be it in Photoshop or whatever ... so imagine that the file name is : 2004_1046.jpg
If this is at all possible, what would be the syntax then?
Thanks in advance!
Ronny Sigo


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.