473,836 Members | 1,558 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

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
6 22456
On Tue, 18 May 2004 16:42:34 +1200, "WindAndWav es" <ac****@ngaru.c om>
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
Thank you perfect. Really appreciate it. Hopefully I can help someone else
next time.
"Tom van Stiphout" <to*****@no.spa m.cox.net> wrote in message
news:kg******** *************** *********@4ax.c om...
On Tue, 18 May 2004 16:42:34 +1200, "WindAndWav es" <ac****@ngaru.c om>
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
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
>
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
Nov 12 '05 #5
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.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...


Nov 12 '05 #6
"Albert D. Kallal" <Pl************ *******@msn.com > wrote in message
news:Ohrqc.4942 72$Pk3.224589@p d7tw1no...

Example

This example displays the Save As dialog box.

Dim dlgSaveAs As FileDialog

Set dlgSaveAs = Application.Fil eDialog( _
FileDialogType: =msoFileDialogS aveAs)

dlgSaveAs.Show


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

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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
5759
by: Wayne Aprato | last post by:
I have a client who is running several Access 97 databases that I have written for them. They are about to upgrade to Access 2003. Is the default file format of Access 2003 still Access 2000 the same as it was in Access 2002? I am running Access 2002 at the moment. Is there any reason for testing purposes etc, for me to purchase Access 2003 if I am going to recompile the Access 97 mdb files into Access 2000 format mde files which...
4
4033
by: pw | last post by:
Hi, I converted (actually, imported) my Access 97 application into Access 2003. I selected "Create MDE" and it prompts me for the mde file to create. However, what A2003 really does is create a MDB called db1.mdb, then locks up!! It looks like that menu pick is actually compacting the database, NOT creating an MDE!
10
5473
by: Daven Thrice | last post by:
If I create an mdb in Access 2003, in 2003 format, and go to a computer that has Access 2002 on it, will I be able to open and edit all of the objects? Thanks, dt
5
4751
by: kathyk | last post by:
Hi All, We are moving to Access 2003 in a month or so, so i started testing my data base files in v2003. When The mdb open I get 3 warning messagase about blocking unsafe expressions. Security Warning Unsafe excpressions are not blocked. Do you want to? Yes/No Security Warning Unsafe expressions are not blocked. You must have MS jet 4.0 Service pack 8 must be installed to block unsafe expressions. Do
3
2532
by: KEMDignam | last post by:
I have upgraded my computer to Access 2003, but I have not converted my databases since all of my clients still use Access 2000. I need to create a new MDB, but Access is telling me that I will have to convert the database to 2003 before it will make an MDB. What are my options? If I convert the database, I assume that Access 2000 and A2k runtime will no longer be able to read the MDE. Can I re-install A2k on my machine? Is there...
0
1357
by: Karl Irvin | last post by:
I have a QuickBooks xsd file (XML definitions) that I'm trying to import. On import Acess suffers a fatal error and has to close. I updated Access/Office and it still does this. Any thoughts on how to fix this would be appreciated.
5
1350
by: 205210864 | last post by:
how do i create a file by a click of a button on an access form. the file i need to create is a text file with a heading and column names.
4
2165
by: ramaswamynanda | last post by:
Hello All, I created an application using Ms Access 2000. My client has Access 2003. When I shipped him the code, this problem occured. He took the following actions - 1. double click on mdb file 2. the startup form opens - close it 3. convert the file to Access - 2003 4. cose and re-open mdb file 5. Try to create mde file
2
4991
by: laurasesma18 | last post by:
Hi, I have a program in Access 2003 and written in Visual Basic. At some point I would like to open an Excel file automatly from Access 2003. So that the user can do some changes in this file and then close it. I don't want any connection with the program, only that it open the file on its own. If you have an idea of how I can do that It would be great.
0
9827
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10560
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10262
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7798
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6986
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5662
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5838
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4468
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4033
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.