By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,403 Members | 880 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,403 IT Pros & Developers. It's quick & easy.

how do I create a folder/file browser in Access 2003???

P: n/a
Hi guys

Thank you for all your previous answers. My new question is as follows: how
do I create a folder/file browser in access 2003. That is, I would like the
user to locate several files (the back-end, logo, etc...) and save the path.

Cheers

Nic.
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
On Tue, 18 May 2004 16:42:34 +1200, "WindAndWaves" <ac****@ngaru.com>
wrote:

Same as in previous versions:
http://www.mvps.org/access/api/api0002.htm

-Tom.

Hi guys

Thank you for all your previous answers. My new question is as follows: how
do I create a folder/file browser in access 2003. That is, I would like the
user to locate several files (the back-end, logo, etc...) and save the path.

Cheers

Nic.
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004


Nov 12 '05 #2

P: n/a
Thank you perfect. Really appreciate it. Hopefully I can help someone else
next time.
"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:kg********************************@4ax.com...
On Tue, 18 May 2004 16:42:34 +1200, "WindAndWaves" <ac****@ngaru.com>
wrote:

Same as in previous versions:
http://www.mvps.org/access/api/api0002.htm

-Tom.

Hi guys

Thank you for all your previous answers. My new question is as follows: howdo I create a folder/file browser in access 2003. That is, I would like theuser to locate several files (the back-end, logo, etc...) and save the path.
Cheers

Nic.
---
Please immediately let us know (by phone or return email) if (a) this emailcontains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004

---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004
Nov 12 '05 #3

P: n/a
WindAndWaves wrote:
Thank you perfect. Really appreciate it. Hopefully I can help someone else
next time.


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.
Nov 12 '05 #4

P: n/a
>
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
Nov 12 '05 #5

P: n/a
Albert D. Kallal wrote:
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:


Thanks Albert. I haven't installed my A2003 yet and I have removed by
A2K. Glad to see they incorporated it.

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...


Nov 12 '05 #6

P: n/a
"Albert D. Kallal" <Pl*******************@msn.com> wrote in message
news:Ohrqc.494272$Pk3.224589@pd7tw1no...

Example

This example displays the Save As dialog box.

Dim dlgSaveAs As FileDialog

Set dlgSaveAs = Application.FileDialog( _
FileDialogType:=msoFileDialogSaveAs)

dlgSaveAs.Show


Doesn't work in Access 2002
http://support.microsoft.com/?id=282335

--
Joan Wild
Microsoft Access MVP
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.