Select a folder for input

[Chris Mills]

Ah... yes and no ?

Most people avoid the ocx control Microsoft provided for the purpose, because
it is reported to be just so much crap as to compatibility.

Instead, the advice is to use direct system calls. GetOpenFileName in C++ will
demonstrate what you want. Microsoft does not make it easy.

OTOH, someone else might be able to give a link to a vba equivalent. I hope
the code they provide is compatible with all versions of Access.

Chris

 

[giannis]

Is there any code in Vb that open a window
for the user so he select from the list of all folders
in the disk a folder ?
(I want replace the Inputbox() with this window)

 

[Larry Daugherty]

Go to http://mvps.org/access and search on API. You'll be able to find the
Common Dialogue equivalents. While you're there look into "netiquette",
particularly as it relates to massively cross-posting. I'd already typed
the first sentence of this before I noticed the list of newsgroups. I
rarely respond to anything with more than 3.

hth

 

[John Nurick]

http://www.mvps.org/access/api/api0002.htm

Gianni, it's never necessary to cross post to so many groups.

Follow-ups trimmed to microsoft.public.access &
microsoft.public.access.externaldata

Is there any code in Vb that open a window
for the user so he select from the list of all folders
in the disk a folder ?
(I want replace the Inputbox() with this window)

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.