Awesome, thanks for sharing we appreciate, I want to ask you about the difference between the Class Module and the regulars Module, I don't know you have a video about that or no? Thanks again.
Hi Sean! After double-clicking txtPath, the folders are opened, but the files are not visible in these folders. So, it is impossible to select files of different formats. How can this be fixed? How can I get a file name in txtName that can be saved in tblAttFile without changing it?
Some people say never use the attachment type instead use a hyperlink with the directory path. The attachment type take to much space. I am not so skilled in Access so not sure 8f this is true
Good question; I do talk about that in the video and in the description. I would agree that the best long term solution is to link to files that are managed by the filesystem. However, in some use-cases this is not practical and it makes more sense to store some files in the database. Two different ways to do it 🛠
There is one thing that I seriously think you have ommitted... Creating an image field that is poputated by the path... Change records, it updates... Please don't get me wrong, I very much appreciate what you do.
Awesome, thanks for sharing we appreciate, I want to ask you about the difference between the Class Module and the regulars Module, I don't know you have a video about that or no? Thanks again.
That's actually a great topic - I'll put it on my list!
Hi Sean! After double-clicking txtPath, the folders are opened, but the files are not visible in these folders. So, it is impossible to select files of different formats. How can this be fixed?
How can I get a file name in txtName that can be saved in tblAttFile without changing it?
Maybe you chose the Folder picker instead of the file picker. It should start like msoFileDialog..
What kind of files are you choosing?
Great video, so helpful. Does anybody know how to set it optionally to store a document?
You can store any type of file using this method. Give it a try!
Some people say never use the attachment type instead use a hyperlink with the directory path. The
attachment type take to much space. I am not so skilled in Access so not sure 8f this is true
Good question; I do talk about that in the video and in the description. I would agree that the best long term solution is to link to files that are managed by the filesystem. However, in some use-cases this is not practical and it makes more sense to store some files in the database. Two different ways to do it 🛠
@wimschiphorst8541 Agreed... the backend gets bloated especially on a large DB.
There is one thing that I seriously think you have ommitted... Creating an image field that is poputated by the path... Change records, it updates... Please don't get me wrong, I very much appreciate what you do.
That is a good suggestion - I'll cover that too in another video. This video is more about storing all kinds of files.
√√√
🛠