folder picker

D

Dave

put in use of filedialog in an access xp subroutine to find a folder:
Set fd = Application.FileDialog(msoFileDialogFolderPicker)
it works fine on my development machine that has the full office
installation. however when i package it up and take it to a clean machine,
install the access runtime, and try to use the filedialog it crashes with a
runtime error on the above line. i did check that the office10\mso.dll is
on the target machine. is there something else that is needed that the
packaging wizard may have missed??
 
D

Dave

something other than checking the reference box for "microsoft office 10.0
object library" in the project references??? it wouldn't even compile on
the development machine without that of course. with it the development
machine is fine, but the target machine crashes.
 
R

Ron Weiner

Dave

I have had a number of "interesting" experiences deploying the Access
runtime solutions. Some stuff just dosent work, some stuff works
differently, and some stuff causes Kaboom's.

If I were in your position I believe that I would give up on the Access
msoFileDialogFolderPicker and use the API directly. There is a Browse for
Folder Solution at http://www.mvps.org/access/api/api0002.htm and browse for
files solution at http://www.mvps.org/access/api/api0001.htm.

Neither of these solutions requires anything special be installed on the
client machine, as they use the windows OS directly.

Ron W
 
D

Dave

ah, thank you... that is really the folder dialog i wanted, but i forgot how
to get it. i'll have to file that link away somewhere 'safe'.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top