>
It is AMAZING to me that MS has never provided a File/Open in any of its
versions in Access. I am sure many man years have been consumed on this
question and in the installation of it if we multiply the number of
developers that have spent time on this single question. I do believe
it exists in VB as a standard function via CommonDialog. If it exists
in a "developer" product like VB and does not exist in an "end-user"
product like Access I should think the oversight could be corrected.
Heck, even FoxPro for DOS has a FileOpen with the GetFile() function.
From the access help files:
FileDialog Property
Returns a FileDialog object which represents a single instance of a file
dialog box.
expression.File Dialog(dialogTy pe)
dialogType Required MsoFileDialogTy pe. The type of file dialog box.
MsoFileDialog Type can be one of these MsoFileDialogTy pe constants.
msoFileDialogFi lePicker
msoFileDialogFo lderPicker
msoFileDialogOp en
msoFileDialogSa veAs
Example
This example displays the Save As dialog box.
Dim dlgSaveAs As FileDialog
Set dlgSaveAs = Application.Fil eDialog( _
FileDialogType: =msoFileDialogS aveAs)
dlgSaveAs.Show
This example displays the Open dialog box and allows a user to select
multiple files to open.
Dim dlgOpen As FileDialog
Set dlgOpen = Application.Fil eDialog( _
FileDialogType: =msoFileDialogO pen)
With dlgOpen
.AllowMultiSele ct = True
.Show
End With
The above text is right from the a2003 help files. As far as I know..that
last 2 versions of ms-access has this feature...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com http://www.attcanada.net/~kallal.msn