>
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.FileDialog(dialogType)
dialogType Required MsoFileDialogType. The type of file dialog box.
MsoFileDialog Type can be one of these MsoFileDialogType constants.
msoFileDialogFilePicker
msoFileDialogFolderPicker
msoFileDialogOpen
msoFileDialogSaveAs
Example
This example displays the Save As dialog box.
Dim dlgSaveAs As FileDialog
Set dlgSaveAs = Application.FileDialog( _
FileDialogType:=msoFileDialogSaveAs)
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.FileDialog( _
FileDialogType:=msoFileDialogOpen)
With dlgOpen
.AllowMultiSelect = 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