<div>
The solution worked, but code was restricted to .xls files. No advice on how to call from a form and catch the filename.
</div>


<div>
Tnx, the proposed &nbsp;solution worked.
</div>


<div>
&lt;The solution worked, but code was restricted to .xls files&gt;<br />
<br />
That was an example ... you'd obviously be expected to provide your own filters and such. Generally, if you find something like this that doesn't work as expected, post back with a comment and can help you figure it out. <br />
<br />
&lt;No advice on how to call from a form and catch the filename.&gt;<br />
<br />
The example shows how to dimension a String variable and call the OpenFile dialog ... after that call, the variable would hold the chosen file. The TestIt function, which is included in that link, is a complete example of how to work with these API calls, but again, if you have trouble working with this code, please feel free to post back here and ask for clarification. If you don't understand how something works, we can usually quickly explain it for you.
</div>


<div>
<div class="content wysiwyg-content">
I have a Ms Access form where I want the user to be able to store a link to a word or excel file in a text box. I need to open the standard file browser so the user can select the file that is to be stored in the text field. Is there any object in Access 2007 VB that can be used for this purpose?<br />
<br />
I know how to poulate a list box with file names from a directory but this has some restrictions when it comes to number of files and maximum no of characters for the rowsource property of a listbox.<br />
<br />
The better way would be to be able to opend the standard file browser in windows.
</div>
</div>


I have a Ms Access form where I want the user to be able to store a link to a word or excel file in a text box. I need to open the standard file browser so the user can select the file that is to be stored in the text field. Is there any object in Access 2007 VB that can be used for this purpose?

I know how to poulate a list box with file names from a directory but this has some restrictions when it comes to number of files and maximum no of characters for the rowsource property of a listbox.

The better way would be to be able to opend the standard file browser in windows.

How to open a browse for a file dialogue from Access 2007 VB

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.