Question » How do I put a button on a Microsoft Access form which will allow the user to look up a file. I want to be able to lookup and insert a image file. I need to be able to press the button and look for a file either with windows explorer or the Microsoft Office file lookup window?
Answer » You can find an article relating to using the Common Dialog API at the Microsoft Knowledge Base:
You can also download an example file in Microsoft Access 2000, that uses the above routine from the Microsoft Access Database Downloads page of this website or from the Microsoft Access Modules & VBA page.
Below shows some screenshots of this example:
Clicking on the Add buttons will open up the common dialog API
Displaying the common dialog API where we can select a file.
Why not check out the following for much more information on using VBA in Microsoft Access: