open a folder from a form

#1

Hi,

i'm hoping someone would be able to help with this.

what i need to do is to be able to open a set folder from a access form. at present i have to go into windows explorer and find the folder that way.

i'm hoping that i can open this folder by clicking an icon on a form that takes me straight there.

many thanks
Lee-Anne

--
Message posted via http://www.accessmonster.com

#2

What do you mean by "open a set folder"? Are you saying you want to see a
list of what files are in it so that you can select one? If so, take a look
at http://www.mvps.org/access/api/api0001.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Lee-Anne Waters via AccessMonster.com" <forum (AT) AccessMonster (DOT) com> wrote in
message news:1b758490b45e48e491fcebfa84b1010e (AT) AccessMonster (DOT) com...

Quote:

Hi,

i'm hoping someone would be able to help with this.

what i need to do is to be able to open a set folder from a access form.
at present i have to go into windows explorer and find the folder that
way.

i'm hoping that i can open this folder by clicking an icon on a form that
takes me straight there.

many thanks
Lee-Anne

--
Message posted via http://www.accessmonster.com

#3

Thank you very much..

this is exactly what i am after....

--
Message posted via http://www.accessmonster.com

#4

try this...
Dim RetVal As Double
RetVal = Shell("explorer " & FolderPath, vbMaximizedFocus)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

open a folder from a form

comp.databases.ms-access comp.databases.ms-access

open a folder from a form - 01-06-2005 , 07:15 PM

Re: open a folder from a form - 01-06-2005 , 07:30 PM

Re: open a folder from a form - 01-06-2005 , 07:44 PM

Re: open a folder from a form - 01-07-2005 , 01:56 PM