Unreal. Without even knowing it this is exactly what i cab use in a Db i am making to track orders and finances for my wife's upcoming business. It's a fantastic way of my keeping the size of the Db down and making it easy for her to grab the images she wants to link to. Brilliant. Brilliant.
This is really a good concept for file browser/manager. I had incorporated this function into my database which enables me to upload the link for all the documents related to my client (contract, lpo, work order, etc)
Great Video!!! Very helpful! Is there a way to extend this operation by having the ability to additionally copy the selected file to another folder of our choice? Thank you in advance!
You can parse it out something like: strFile = .SelectedItems(1) arFile = Split(strFile, "\") strFile = arFile(UBound(arFile)) strFile will just be the selected file name.
@@seanmackenziedataengineering HI and thank you. In the meantime, I found another way, using the Dir function. So, Me!txtFile = Dir(.SelectedItems(1)) does the job. Dir returns just the filename without the path. I also noticed that exiting without selecting a file returned an error. I added in an If Then End If.
This is a great feature, thank you. How would you get the UNC filepath when selecting a file from a network drive. At the moment I just get the mapped drive letter.
You can use Application.FollowHyperlink strFilepath in order to open the file you found in file dialog. If Filepath has spaces in it, you may need to put quotes around it, using double double quotes or Chr(34). ie. Application.FollowHyperlink Chr(34) & strFilePath & Chr(34)
Great tutorial on Access programming. Could you pls consider uploading a similar video on backing up the backend DB from within frontend ACCESS APPLICATION to a selected drive, folder and so on..Thanks
Using file dialog, you will get the file name. Then you can use FileCopy command to copy from your Dialog selected location to your project file location.
if click the button "Get File" and close the window without selecting a folder, then the error message "The expression you entered has an invalid reference to the Parent property" will appear. How to fix this error?
You can trap the error by putting error handling on the procedure. Determine which error number it is, then either disregard it or give a custom message: ruclips.net/video/13aFUK7tmus/видео.html
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
Excellent explanation! RUclips needs to promote more of this content.
Much appreciated!
Unreal. Without even knowing it this is exactly what i cab use in a Db i am making to track orders and finances for my wife's upcoming business. It's a fantastic way of my keeping the size of the Db down and making it easy for her to grab the images she wants to link to. Brilliant. Brilliant.
Awesome! Glad that will work for you 👍
This is really a good concept for file browser/manager. I had incorporated this function into my database which enables me to upload the link for all the documents related to my client (contract, lpo, work order, etc)
Nice! That's a great use for this function. Once you get it, it can automate so many things.
Truly brilliant! Just what I wanted to achieve. Thank you.
Awesome! Glad that worked :-)
Simple and clear explanations. Thanks for sharing!
Glad it was helpful!
Thanks
Many thanks!
Excellent tutorial. Thank you for Sharing your knowledge.
My pleasure!
Very valuable topic, thanks Sean
Much appreciated!
Great Video!!! Very helpful! Is there a way to extend this operation by having the ability to additionally copy the selected file to another folder of our choice? Thank you in advance!
Thanks for the feedback! Yes, you can, by using the FileCopy statement after selection, ie:
FileCopy sourcefilepath, destinationfilepath
Excellent! Could you please explain how to get just the filename without the path to put in a field? Thank you.
You can parse it out something like:
strFile = .SelectedItems(1)
arFile = Split(strFile, "\")
strFile = arFile(UBound(arFile))
strFile will just be the selected file name.
@@seanmackenziedataengineering HI and thank you. In the meantime, I found another way, using the Dir function. So, Me!txtFile = Dir(.SelectedItems(1)) does the job. Dir returns just the filename without the path. I also noticed that exiting without selecting a file returned an error. I added in an If Then End If.
This is a great feature, thank you. How would you get the UNC filepath when selecting a file from a network drive. At the moment I just get the mapped drive letter.
No problem! When you open the Dialog, try browsing to the file using the Network location instead of the drive letter.
Nice video, well paced. I've been using SHBrowseForFolder and my bugabear is setting an initial directory.
Glad it helped!
How would I open the file I am picking from the above...using the path stored in the text file?
You can use Application.FollowHyperlink strFilepath in order to open the file you found in file dialog. If Filepath has spaces in it, you may need to put quotes around it, using double double quotes or Chr(34). ie.
Application.FollowHyperlink Chr(34) & strFilePath & Chr(34)
Great tutorial on Access programming. Could you pls consider uploading a similar video on backing up the backend DB from within frontend ACCESS APPLICATION to a selected drive, folder and so on..Thanks
Thanks, I'll add that to my list!
Great video!!!!!
Thanks!!
Thank you Sir.
Welcome!
Sir how can i transfer my selected file to current project folder.. Plz do a video so we can learn more. Thanks you.
Using file dialog, you will get the file name. Then you can use FileCopy command to copy from your Dialog selected location to your project file location.
Hi Sean, Why can I see only orders but not files?
When you open the File Dialog?
Where can we view the upload documents?
The file dialog only returns the selected document. Only after you copy from one place to another do you see the upload.
if click the button "Get File" and close the window without selecting a folder, then the error message "The expression you entered has an invalid reference to the Parent property" will appear. How to fix this error?
You can trap the error by putting error handling on the procedure. Determine which error number it is, then either disregard it or give a custom message: ruclips.net/video/13aFUK7tmus/видео.html
@@seanmackenziedataengineering Thank you very much. it helped))
thanks Mr
No problem!
Dear Sir I want to learn Copy File Folder from one destination to another Destination in Access. please help to teach with this lesson Copy File
You can use FileCopy command in VBA. In a VBA Sub just type FileCopy then space and the IDE will tell you the options - Source file, Destination etc.
@@seanmackenziedataengineering Thank you Sir, Could you please 🥺 Teach by Creat Videos Step by Step for FileCopy Lesson ☺️
@@MaraingMuong168 I’ll put it on my list!
10/10
thanks!
great
thanks!