Link to home
Avatar of yballan
yballanFlag for United States of America

asked on

VBA and Windows Explorer

Dear Experts,

I am writing a piece of VBA code for my database, and am not sure how to do this.
This is what I would like to do.
When I click on a button, it opens a designated image folder.
When I double-click on a file, it does not open it, but only picks up the file name, which I will retrive and use to put into my database after adding a path.
I can do this  if I create a form, but if I want to use Window Explorer, I am lost.
Please advise.
SOLUTION
Avatar of Hamed Nasr
Hamed Nasr
Flag of Oman image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of yballan

ASKER

thank you,  hnasr and LSMConsulting,
I was able to get it working!!!