msoFileDialogFilePicker

[kirkm]

I'm using Application.FileDialog(msoFileDialogFilePicker) to pick a folder as it will remember the last item it selects.

Is there any way to filter or limit the output to Folders only ?


Or a better object exists ? I prefer an older "BrowseFolder" routine but it will not remember or allow a default path.


Thanks for any assistance. Using Access 2019.

 

[theDBguy]

Hmm, instead of msoFileDialogFilePicker, have you tried using msoFileDialogFolderPicker?

 

[kirkm]

LOL thanks... I just got there 30 secs before seeing your message. Very obvious now.

 

[theDBguy]

LOL thanks... I just got there 30 secs before seeing your message. Very obvious now.

Hi. As long you were able to, in the end. Good luck with your project.