Opening explorer and capturing file location into access form

[phil-007]

Hi All,

We have a DB that's used for logging work into our department, on the form thats used for logging a new job I want to put a field that you can store a file path from win explorer.

Is there a way to get use a command button to open explorer then once you've navigated to your file and selected it, it saves the path in the field?

P.S I only have limited Access/VBA skills so you may need to explain things slowly!

Thanks

Phil

 

[Joe4]

See: design - Adding a file browser button to a MS Access form - Stack Overflow

 

[phil-007]

See: design - Adding a file browser button to a MS Access form - Stack Overflow

Thanks Joe4, I've got that working however it returns the folder path (which reading the code is what its desinged to do), what I really want is a file location so you pick up an excel file or word file etc.

Do you know if the existing code can be tinkered with to pick up a file rather than folder, or is it a different set of code completely?

Thanks

Phil

 

[alansidman]

This will open Windows Explorer from a command button

Private Sub Command35_Click()
Shell "explorer.exe /root,c:\aaa", vbNormalFocus
End Sub

 

[HiTechCoach]

I have created an example that does exactly what you need:

Document Links 2

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.

 

[HiTechCoach]

If the above link does not work try this new one:

Document Links 2