Hi.

I'm looking for a simple simple simple solution that will allow me to add a button to an Access form. When the button is clicked, a File Dialog box should appear allowing me to pick any file to insert into the OLE package.

I've searched every corner of the web and have found a lot of suggestions that are close, but most are either too complex (using API) or are focused on something specific (like inserting .xls files only).

Can anyone help?

Much appreciated!

The answer is using the API. Sorry, but there is no simple way. If you use the Code here:
API: Call the standard Windows File Open/Save dialog box

You can do this (its what I use). Its not that difficult. The code behind your button would look like this:

strInputFileName = ahtCommonFileOpenSave(InitialDir:="K:\Transcar", _
Filter:=strFilter, OpenFile:=True, Flags:=ahtOFN_HIDEREADONLY, _
DialogTitle:="Select File for Input...")

This opens the File>Open dialog to the folder K:\Transcar. You can leave out the Filter argument if you want to show all files.