A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Help: I want a "browse for folder" dialog, but with a few extras...



 
 
Thread Tools Display Modes
  #1  
Old April 9th, 2009, 12:50 AM posted to microsoft.public.access
AC[_2_]
external usenet poster
 
Posts: 20
Default Help: I want a "browse for folder" dialog, but with a few extras...

Hi

I need code to open some sort of browse for folder dialog. Currently
I use what most people seem to recommend:

Private Declare Function SHBrowseForFolder Lib "shell32.dll" Alias _
"SHBrowseForFolderA" (lpBrowseInfo As BROWSEINFO) _
As Long


I would like 2 "extras" however.

1. I would like to be able to set the initial directory the browse
folder dialog opens to. This needs to still allow the user to
navigate up to higher folders in the tree than the initial dir [I saw
a suggestion on the net but it did not allow to navigate above the
initial dir]

2. I would like the user to be able to Add a new folder if they want
to while navigating the dialog. You often see this on saveAs dialogs
as a button showing a folder icon with a small star in the top corner.


A v.good example of this dialog turns up if you open an Outlook email
with multiple attachments, and click File--SaveAttachments -- and
then select all the attachments.


Is there something out there which I can use?

Thanks
AndyC
  #2  
Old April 9th, 2009, 01:09 AM posted to microsoft.public.access
Albert D. Kallal
external usenet poster
 
Posts: 2,874
Default I want a "browse for folder" dialog, but with a few extras...

Stephan's example has the ability to set the starting folder...

http://www.lebans.com/callbackbrowser.htm



--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada



  #3  
Old April 9th, 2009, 01:14 AM posted to microsoft.public.access
AC[_2_]
external usenet poster
 
Posts: 20
Default I want a "browse for folder" dialog, but with a few extras...

On Apr 9, 12:09*pm, "Albert D. Kallal"
wrote:
Stephan's example has the ability to set the starting folder...

http://www.lebans.com/callbackbrowser.htm

--
Albert D. Kallal * *(Access MVP)
Edmonton, Alberta Canada


Thanks, I found that one. Unfortunately it misses out on wish list
item (2)

As a note for anyone else who uses the above link, he suppiles a
sample Access app which contains a form to demo it in action. Behind
this form is the code which invokes the dialog, and it makes a VERY
IMPORTANT NOTE that the code has to in the form itself rather than in
a standalone module or you get random GPFs.

Cheers
AndyC
  #4  
Old April 9th, 2009, 01:48 AM posted to microsoft.public.access
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default I want a "browse for folder" dialog, but with a few extras...

Check what Randy Birch has at
http://vbnet.mvps.org/index.html?cod.../browseadv.htm

Obligatory warning: Randy's site is aimed at VB programmers. Because there
are some significant differences between the controls available for forms in
VB and in Access, his samples often won't port directly into Access. In this
particular case, all of his references to the .Text property of text boxes
have to be removed (or changed to .Value). The .Text property is only
available in Access when the text box has focus.

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



"AC" wrote in message
...
On Apr 9, 12:09 pm, "Albert D. Kallal"
wrote:
Stephan's example has the ability to set the starting folder...

http://www.lebans.com/callbackbrowser.htm

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada


Thanks, I found that one. Unfortunately it misses out on wish list
item (2)

As a note for anyone else who uses the above link, he suppiles a
sample Access app which contains a form to demo it in action. Behind
this form is the code which invokes the dialog, and it makes a VERY
IMPORTANT NOTE that the code has to in the form itself rather than in
a standalone module or you get random GPFs.

Cheers
AndyC

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.