Using the Microsoft Office File Dialog in MS Access
ฝัง
- เผยแพร่เมื่อ 22 ก.ค. 2024
- Display the Office File Dialog in MS Access
**The full code listing to the VBA shown in this video can be found at:
accessjitsu.com/2015/09/13/cod...
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:
accessjitsu.com/
Excellent! Just what I needed. You are a great instructor. Thanks so much
Thank you, definitely learnt something.
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?
+Access Jitsu Hello Thank you very much sharing your knowladge and experiences ... btw you have great name "Access Jitsu " ... thumbs up... :D
this video is excellent but how can I save those file path linking a table to it for multiple selection and saving?
I have error msg "Method or data member not found" It is on Me.ControlName.Picture = varFile" and "Me.FieldName = VarFile" Can you help?
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?
Me too....
Same here
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))
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.
Did you select the microsoft office reference?
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
+Bahar Mohmand Do you need to requery the form?
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.
Using late binding will allow you to use the file dialog without the office object library reference. Use this dimension instead:
Dim fDialog As Object
Then you need to replace the msoFileDialogFilePicker constant (or whichever you are using), with the actual value, since without the reference, Access won't know what the constant is. The values are:
msoFileDialogFilePicker = 3
msoFileDialogFolderPicker = 4
msoFileDialogOpen = 1
msoFileDialogSaveAs = 2
for example: Set fDialog = Application.FileDialog(3)
Hi, first off, great tutorials mate!
I have a question though; Is the Microsoft Office 16.0 Object Library sufficient for reference?
Regards, Oliver.
You've no doubt figured this out by now but yes, whatever version of the Object Library you have will work.
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.
never mind found it
Volume too low