folder picker

Discussion in 'VBA Developer' started by Dave, Jan 18, 2005.

  1. Dave

    Dave Guest

    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??
    Dave, Jan 18, 2005
    #1
    1. Advertising

  2. Dave

    Guest Guest

    You must specifically make a reference to mso10.dll


    >-----Original Message-----
    >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, Jan 21, 2005
    #2
    1. Advertising

  3. Dave

    Dave Guest

    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.

    <> wrote in message
    news:144801c4ff88$a994e880$...
    > You must specifically make a reference to mso10.dll
    >
    >
    > >-----Original Message-----
    > >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??
    > >
    > >
    > >
    > >.
    > >
    Dave, Jan 21, 2005
    #3
  4. Dave

    Ron Weiner Guest

    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" <> wrote in message
    news:ulmVHW7$...
    > 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.
    >
    > <> wrote in message
    > news:144801c4ff88$a994e880$...
    > > You must specifically make a reference to mso10.dll
    > >
    > >
    > > >-----Original Message-----
    > > >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??
    > > >
    > > >
    > > >
    > > >.
    > > >

    >
    >
    >
    Ron Weiner, Jan 21, 2005
    #4
  5. Dave

    Dave Guest

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

    "Ron Weiner" <> wrote in message
    news:emn9J67$...
    > 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" <> wrote in message
    > news:ulmVHW7$...
    > > 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.
    > >
    > > <> wrote in message
    > > news:144801c4ff88$a994e880$...
    > > > You must specifically make a reference to mso10.dll
    > > >
    > > >
    > > > >-----Original Message-----
    > > > >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??
    > > > >
    > > > >
    > > > >
    > > > >.
    > > > >

    > >
    > >
    > >

    >
    >
    Dave, Jan 21, 2005
    #5
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Joe Delphi

    Folder Picker Control?

    Joe Delphi, Jul 17, 2005, in forum: Access General
    Replies:
    1
    Views:
    34
    Rick Brandt
    Jul 17, 2005
  2. aspear
    Replies:
    5
    Views:
    214
    aspear
    Jun 23, 2009
  3. pk

    Folder picker: default to network share?

    pk, Oct 11, 2003, in forum: Excel Programming
    Replies:
    0
    Views:
    58
  4. pk

    Folder picker default - second attempt...

    pk, Oct 13, 2003, in forum: Excel Programming
    Replies:
    4
    Views:
    44
    John Redmayne
    Oct 13, 2003
  5. KeriM
    Replies:
    2
    Views:
    80
    KeriM
    Nov 2, 2012
Loading...

Share This Page