Launch File Dialogue

[Jim]

Hello,

Thank you very much for helping.

I am looking for two things in an Access 2000 application:

1. I need to be able to launch a "File Dialogue" (just
as if you hit file/open in Word, for example) in that
will load the folder path into a variable. For example,
if my users select the "Program Files" folder, the
variable would be loaded with "C:\Program Files"

2. I need to do the same thing that would include the a
file name in the path. For example, if I selected,
MSACCESS.EXE it would load the variable with: "C:\Program
Files\Microsoft Office\Office10\MSACCESS.EXE"

Any help would be greatly appreciated. Have a great day.

Jim

 

[HSalim]

Jim,
You will need the Developer version of Access to be able to use
Microsoft's Common Dialog Controls.
if you do, you can use the same features that are built into windows such as
Browse for folder, open file dialog, save file dialog.
Search on google for common dialog for sample scripts.
HS

 

[Jim]

Thank you for helping.

I have the developer Version of the XP version of Access,
but not Access 2000. Is there a way I can use the Common
Dialog Controls in the 2000 application by using the XP
developer version (without packaging the application)?

Thx,

Jim

 

[Douglas J. Steele]

Only partially true. While the Common Dialog control comes with the
Developer version, most of us do not recommend using it, since it's
extremely prone to versioning problems. Instead, make the API calls
directly. See http://www.mvps.org/access/api/api0001.htm at "The Access Web"
for sample code.

And for the Select Folder dialogue, see
http://www.mvps.org/access/api/api0002.htm

 

[Jim]

Thank you very much for your helpful imput.

Jim

-----Original Message-----
Only partially true. While the Common Dialog control comes with the
Developer version, most of us do not recommend using it, since it's
extremely prone to versioning problems. Instead, make the API calls
directly. See http://www.mvps.org/access/api/api0001.htm at "The Access Web"
for sample code.

And for the Select Folder dialogue, see
http://www.mvps.org/access/api/api0002.htm

--
Doug Steele, Microsoft Access MVP



built into windows such
as


.

 

[Jim]

Thank you very much for your helpful imput.

Jim

-----Original Message-----
The code found at the following links will do that for you and will avoid
the occurrence of licensing and versioning problems related to the use of
the CommonDialog ocx.

File Open/Save:
http://www.mvps.org/access/api/api0001.htm

Browse Folder:
http://www.mvps.org/access/api/api0002.htm

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX




.