How to Use a File Dialog in MS Access to Allow Users to Pick a File or Folder

In this episode, we'll take a look at how to let users choose a file or folder in their file system in order to get the path so that we can use it in our application. This example will show how to allow for single or multiple file selections, and we'll put the file paths into a text file and show them in a message box.

Related Videos:
How to Use a File Dialog in MS Access to Allow Users to Pick a File or Folder
You are watching this video now!
How to Write a Custom Text File Using MS Access VBA
How to Integrate Machine Learning into Microsoft Access Applications
How to Use Base64 in Microsoft Access
How to Use Sleep to Pause VBA in MS Access
How to Open Excel from Access Using VBA
How to Use vbScript to Open and Work with Data in Access accdb Files - Late Binding Example

Interested in transforming your career or finding your next gig?

Needing to hire technical resources for your project? Get the best:

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

Demo of my BZ RDP Cloaker:

Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

#msaccess #vba

[interestingamerican]

Excellent explanation! YouTube needs to promote more of this content.

[petewarby]

Unreal. Without even knowing it this is exactly what i cab use in a Db i am making to track orders and finances for my wife's upcoming business. It's a fantastic way of my keeping the size of the Db down and making it easy for her to grab the images she wants to link to. Brilliant. Brilliant.

[GunnerEshzurale-phbc]

This is really a good concept for file browser/manager. I had incorporated this function into my database which enables me to upload the link for all the documents related to my client (contract, lpo, work order, etc)

[colinmiles]

Truly brilliant! Just what I wanted to achieve. Thank you.

[felipescherer]

Simple and clear explanations. Thanks for sharing!

[josemariavicentetascon]

Excellent tutorial. Thank you for Sharing your knowledge.

[Craigybabes]

This is a great feature, thank you. How would you get the UNC filepath when selecting a file from a network drive. At the moment I just get the mapped drive letter.

[AReelLife]

Nice video, well paced. I've been using SHBrowseForFolder and my bugabear is setting an initial directory.

[stampap]

Great Video!!! Very helpful! Is there a way to extend this operation by having the ability to additionally copy the selected file to another folder of our choice? Thank you in advance!

[pathtolightbd]

Great tutorial on Access programming. Could you pls consider uploading a similar video on backing up the backend DB from within frontend ACCESS APPLICATION to a selected drive, folder and so on..Thanks

[JCBrownVideos]

Excellent! Could you please explain how to get just the filename without the path to put in a field? Thank you.

[valeryoni]

Hi Sean, Why can I see only orders but not files?

[menkiz]

How would I open the file I am picking from the above...using the path stored in the text file?

[RAVICHANDRANR-du]

Where can we view the upload documents?

[Ziahasan]

Sir how can i transfer my selected file to current project folder.. Plz do a video so we can learn more. Thanks you.

[andriyos_]

if click the button "Get File" and close the window without selecting a folder, then the error message "The expression you entered has an invalid reference to the Parent property" will appear. How to fix this error?

[MaraingMuong]

Dear Sir I want to learn Copy File Folder from one destination to another Destination in Access. please help to teach with this lesson Copy File