Hyper link open folder

[psamu]

I have a hyperlink field. In my form I added a text box. Now for adding a link user has to right click and add in order to add a file path. How do I add click event opens a folder when user can select the folder and file name to add he/she wants . Thanks

 

[Micron]

You can call the file picker or file folder dialog with your own function or a macro. See if this helps, or research MS Access file picker VBA or MS Access folder picker VBA. Which one you choose depends on whether you want to drill down to a folder or file. You don't need to consider solutions for MSDN applications. It's quite easy, actually. Here's a couple of references to get you started.
How to show "Open File" Dialog in Access 2007 VBA? - Stack Overflow

[url]http://bytes.com/topic/access/insights/916710-select-file-folder-using-filedialog-object
[/URL]

 

[psamu]

Thanks. I have in my table Hyperlink field. Every time user click file folder open and click on a file to create a link and it should update in the field. This works, but it is jus for a link, does not update to the field.

 

[HiTechCoach]

I would avoid using the hyperlink data type for this (or at all). It makes thing very difficult.

Here are some working examples I created to do what you:

Document Links (Click Here)

This is a basic example of how to store the path to a file and also be able to view the file. You can browse using the standards windows common dialog to select the file. You can view the file using the application defined with the Windows File Associations. It uses the ShelExec API to open the file. It does not use the .Followhyperlink method.

This example is a continuous form that could easily be used as a sub form to attach multiple documents to a record.

Document Links 2 (Click Here)

This is an update to the basic example of how to store the path to a file and also be able to view the file. You can browse using the standards windows common dialog to select the file. You can view the file using the application defined with the Windows File Associations. It uses the ShelExec API to open the file. It does not use the .Followhyperlink method.
This example is a continuous form that could easily be used as a sub form to attach multiple documents to a record.
***** Because it doesn't use the hyperlink data type, this new version stores the path in a way that allows the folder to be easily moved.