Using the Microsoft Office File Dialog in MS Access

Display the Office File Dialog in MS Access

**The full code listing to the VBA shown in this video can be found at:

When you need your users to be able to select a file or folder for processing, or you need them to supply you with a location and new file name, you can do this via the Microsoft Office File Dialog object.

The File Dialog object is very easy to use and only requires the coding of a few properties and methods.

In this video we will discuss the Visual Basic for Applications (VBA) that is needed to use the File Dialog object.

All of my videos organized by topic and other blog topics:

[JohnSmith-thzw]

Excellent video and explination of the code. I am using it with the folder picker. Is there a way to save the last folder picked until the user selects another location?

[dbaker]

Great Video but I get an error on the "Dim fDialog As Office.FileDialog" line "User-defined type not defined", how can I correct this?

[redwarrior]

Thank you, definitely learnt something.

[wiseprince]

this video is excellent but how can I save those file path linking a table to it for multiple selection and saving?

[johndavy]

Excellent! Just what I needed. You are a great instructor. Thanks so much

[simonepaterson]

Hi Access Jitsu,

Great Video!
I'm getting a Type mismatch (Error 13) when I click the button on my form any ideas?

Thanks, Simone.

[jimturner]

I get an error also and I'm sensing it may be related to later versions of Access? I'm not sure.
The error highlights this line:
Call .Filters.Add(Description:=Split(varEntry, ", ")(0), _
Extensions:=Split(varEntry, ", ")(1))

[theaussiegeek]

I need to find a file picker option where different Office versions are being used on different PCs using the same database front end. The DB is being used on different PCs with different Office versions with the tables linking back to a single data source. I tried this option (as per video) and i had major reference errors on PCs not using the same office version as picked.

[johndavy]

I have error msg "Method or data member not found" It is on Me.ControlName.Picture = varFile" and "Me.FieldName = VarFile" Can you help?

[baharmohmand]

Hi there,

My DB has a filed that specifies an imagepath which is then displayed in an imagecontrol (control source is set to the imagepath field).

I used the above filedialog to update the imagepath field. Unfortunately for some reason the image didn't get updated after I choose a new path with the filedialog.

What could I be doing wrong?

Everyone's suggestions are welcome

[oliverhansen]

Hi, first off, great tutorials mate!

I have a question though; Is the Microsoft Office 16.0 Object Library sufficient for reference?

Regards, Oliver.

[theaussiegeek]

ok at 10.33 you click on a button on the menu to comment out all the selected text. Where the hell is that in the button in the menus / options .... i must have that button.

[tughanozsezer]

+Access Jitsu Hello Thank you very much sharing your knowladge and experiences ... btw you have great name "Access Jitsu " ... thumbs up... :D