Search results for query: Filedialog

I found https://bytes.com/topic/access/insights/916710-select-file-folder-using-filedialog-object but it doesn;t work (as supplied) lngType:=msoFileDialogFolderPicker msomsoFileDialogFolderPicker is a undefined variable. Is there anything else ?> Thanks.

...Public Function fChooseFile() ' Requires reference to Microsoft Office 11.0 Object Library. Dim fDialog As Office.FileDialog Dim varFile As Variant ' Set up the File Dialog. Set fDialog = Application.FileDialog(msoFileDialogFilePicker) With fDialog ' Allow...

...Dim rsExisting As DAO.Recordset Dim rsImported As DAO.Recordset Dim strSQL As String Dim fld As DAO.Field Dim fd As FileDialog Dim selectedFile As String ' Open the file dialog Set fd = Application.FileDialog(msoFileDialogFilePicker) With fd...

...is your code formatted and between code tags. Private Sub btnFusionTbl_Click() 'référence : Microsoft Office xx.x Object Library pour FileDialog On Error GoTo ErrorHandler Dim dbsInt As DAO.Database, dbsExt As DAO.Database Dim tdfInt As DAO.TableDef, tdfExt As DAO.TableDef...

Have you tried using the FileDialog as you did in the Similar Thread post? Here's a link/sample without fileDialog.

...even so, the imported data remains in first column. Public Sub ImporterFichier() ' Open Dialog box to select a file Dim fd As FileDialog Set fd = Application.FileDialog(msoFileDialogFilePicker) fd.Title = "Sélectionner le fichier à importer" fd.InitialFileName = ""...

It clearly states A single object is necessary. To implement this facility you use the FileDialog object from the MS Office Object library. This requires that the library is included as a reference of the project. If you don't find it already selected in the Tools \ References list (in the VBA...

...Option Explicit Public Function fChooseFile() ' Requires reference to Microsoft Office 11.0 Object Library. Dim fDialog As Office.FileDialog Dim varFile As Variant ' Set up the File Dialog. Set fDialog = Application.FileDialog(msoFileDialogFilePicker) With fDialog...

Hi, yes i tried. that is why i said i got this 2046 error. Actually i would like to select only ten tables only, but i dont find how to write it.

I don't think you should have a space before the .FileDialog

So I've implemented everything and it works well. The only issue is, my attachments are showing up for every record in the main form despite each attachment having an ID equal to only one record (i.e. propertyID in your example). I made the tblAttachments table have a many to one relationship...

Use the built in FileDialog to do that: https://software-solutions-online.com/vba-save-file-dialog-filedialogmsofiledialogsaveas/ Cheers,

For those interested Private RS As DAO.Recordset Public Function GetFile() As String ' Set up the File Dialog. Dim fdialog As FileDialog Set fdialog = Application.FileDialog(msoFileDialogFilePicker) With fdialog ' Allow user to make multiple selections in dialog box...

If you need code to search for and open a pdf file, then you can use this: Public Function SelectPDF() ChDir CurrentProject.Path Dim ImportFileDialog As FileDialog Set ImportFileDialog = Application.FileDialog(msoFileDialogFilePicker) Dim SelectedFile As Variant Dim db As DAO.Database Set db =...

...Resume Exit_Proc Resume End Select End Function Public Function fChooseDirectory() 'Declare a variable as a FileDialog object. Dim fd As FileDialog 'Create a FileDialog object as a File Picker dialog box. Set fd =...

...but I don't get it. You'll find my code here under Public Sub ImporterFichier() ' Open Dialog box to select a file Dim fd As FileDialog Set fd = Application.FileDialog(msoFileDialogFilePicker) fd.Title = "Sélectionner le fichier à importer" fd.InitialFileName = ""...

...me that would be awesome! thanks Option Explicit Private Sub btnFusionTbl_Click() 'référence : Microsoft Office xx.x Object Library pour FileDialog On Error GoTo ErrorHandler Dim dbsInt As DAO.Database, dbsExt As DAO.Database Dim tdfInt As DAO.TableDef, tdfExt As DAO.TableDef Dim fdg As...

...the destination name argument is blank. If you want combobox value, can't use this dialog. Must provide file path/name argument. As I said, if you want user to pick a location, use FileSystemObject FolderPicker. Here is one reference...

Hi @Krayna , thanks for the help, it was my mistake, reference should have been added.

https://www.google.com/search?q=prepopulate+filename+filedialog+saveas&rlz=1C1CHWL_enGB942GB942&oq=prepopulate+filename+filedialog+saveas&aqs=chrome..69i57j33i10i160.15609j0j4&sourceid=chrome&ie=UTF-8