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?
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 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
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)
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.
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?
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
this video is excellent but how can I save those file path linking a table to it for multiple selection and saving?
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))
Excellent! Just what I needed. You are a great instructor. Thanks so much
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?
I have error msg "Method or data member not found" It is on Me.ControlName.Picture = varFile" and "Me.FieldName = VarFile" Can you help?
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)
Thank you, definitely learnt something.
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
+Access Jitsu Hello Thank you very much sharing your knowladge and experiences ... btw you have great name "Access Jitsu " ... thumbs up... :D
Volume too low