Search results for query: Filedialog

You simply replace the value from the filedialog for your hardcoded path. Lookup the syntax for FileDialog.

1. Use a DlookUp() or DCount() to determin if the name already exists. 2. Use Filedialog to select the relevant image. Move that to a location of your choosing, then put that path into the required /control of the form or field in the table

I saw the filecopy but it requires a source file to be defined in the code. I am trying to find an option that takes the source file from whatever the user selects in the FileDialog method that appears in the textbox on the form.

Yes, I see it too when using your code - I suppose I have never seen it before since I rarely specify a file name when using the FileDialog (usually just a folder path for InitialFileName). Probably some artefact from before when windows file names were restricted in length!

Haven't you got the old filename in the textbox? The code I posted (*should*) grabs the filename from the path/filename in the textbox.

Options for allowing user to browse and select a folder: FileDialog() https://stackoverflow.com/questions/1091484/show-open-file-dialog File System Object https://stackoverflow.com/questions/50350693/how-to-include-msofiledialogfolderpicker-in-a-userform There is also Shell api but I won't go...

...dlookup DCount ,but i will google it and see how it is working then if face problem sure i will come back and put here. about 2. Use Filedialog to select the relevant image. Move that to a location of your choosing, then put that path into the required /control of the form or field in the...

Not even sure you can do drag and drop? I would probably open Explorer with FileDialog to allow the user to select relevant file, then put it whereever needed.

...have half of my problem solved, I just have no idea how to incorporate the 2nd half. So using a simpletext box, and button I can use the filedialog to select a file which I have done, How do I take that file location that is now appearing in the text box and move that file to a specific...

Which template? I opened George's in post 3 and as far as I can tell, it does not use FileDialog. I am not seeing that library either with George's db. It shows MS Office Object Library available. However, when I open my db, I do see the other library.

Use FileDialog to navigate to a file. This is a common topic. Example: Function GetFile() ' Requires reference to Microsoft Office xx.0 Object Library. Dim fDialog As Office.FileDialog ' Set up the File Dialog. Set fDialog = Application.FileDialog(msoFileDialogFilePicker) With...

Dim SelectedFile As Variant Dim FD As FileDialog Set FD = Application.FileDialog(msoFileDialogFilePicker) With FD .AllowMultiSelect = False .Title = "Select A Backend File" .ButtonName = "Select" .Filters.Clear .Filters.Add "Access Files", "*.accdb", 1 .FilterIndex = 1...

thank you Gasman ! it worked ! just found a solution within the same minute as u posted your message :) it now allows me to select a picture and then i get another error

...for further operations using a normal dialog. I tried this code, but nothing happens, not even an error. Dim FileName As String Dim FD As FileDialog Set FD = Application.FileDialog(msoFileDialogFilePicker) FileName = FD.InitialFileName I have the Microsoft Office 16.0 object library in...

Indeed, this is rather unusual. I don't think I ever tried to do that before. In the specific case of this scenario, it is very likely that the user wants to import the same file again and again. - It's an Excel file that gets updated periodically. - So, I thought it would be convenient for the...

You haven't displayed the dialog. Your code should be more along the lines of: Dim FileName As String Dim FD As FileDialog Set FD = Application.FileDialog(msoFileDialogFilePicker) With FD .InitialFileName = 'C:\Some\Path' .Title = "Choose a file ..." If .Show Then ' <-- This line...

I needed to remove the line with .InitialFileName, then it worked perfectly. Thank you for the help.

If you don't want the file browser window to open, don't use the FileDialog object, just use Dir() in a loop.

Tal vez puedes intentar el FileDialog object. https://learn.microsoft.com/en-us/office/vba/api/Access.Application.FileDialog

Have you looked at the FileDialog object? https://learn.microsoft.com/en-us/office/vba/api/Office.FileDialog