folder picker

[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??

 

[Guest]

You must specifically make a reference to mso10.dll

 

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

 

[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

 

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