databasedev.co.uk - database solutions and downloads for microsoft access

How to Use the Common Dialog API in a Microsoft Access Database

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:

How to Use the Common Dialog API in a Microsoft Access Database

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:

• Beginning Access 97 VBA Programming
• Beginning Access 2000 VBA
• Access 2002 VBA Handbook
• Access 2003 Vba Programmer's Reference...