Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

msoFileDialogFilePicker

Discussion in 'Information Technology' started by Moses, Jul 28, 2006.

  1. Moses

    Moses
    Expand Collapse
    Guest

    am trying to set up a database for an inventory with pictures in
    it. I have experienced significat difficulty getting the pictures to
    appear on the form. I have gone to the extreme of importing the
    "Employees" table and form from the Northwind sample. However,
    everytime I try to load the form I get the compile error indicating
    that "msoFileDialogFilePicker" variable has not been defined. I have
    tried using the search to find out where in Northwind it was defined,
    but cannot locate it. Can someone help me figure out what the
    "msoFileDialogFilePicker" which is part of the "FileDialog(xxxxx)" is
    and where it can be defined?

    I have already tried looking at the following solution.
    Press Alt+F11 to open the VB Editor. In that window, choose menu items
    Tools -> References..., then look down the list for Microsoft Office
    11.0 Object Library (it's 11.0 for Access 2003, 10.0 for Access 2002;
    9.0 for Access 2000, 8.0 for Access 97 -- pick the right one). Put a
    check mark in the box next to that reference, then close the dialog.

    Can someone please help me.

    Moses
     
  2. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    Hi Moses

    And did you find "Microsoft Office xx.0 Object Library" in the list and
    select it? Because that should have solved the problem.

    Does your code compile OK? (from the VB editor window, Debug->Compile <your
    project name>)

    Another way to use the file dialog without the MSO object library is to call
    the Windows dialog directly.
    See here for an example: http://www.mvps.org/access/api/api0001.htm
    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand

    "Moses" <Moses@discussions.microsoft.com> wrote in message
    news:44701218-9AB0-48B8-8858-F2C66783B6ED@microsoft.com...
    > am trying to set up a database for an inventory with pictures in
    > it. I have experienced significat difficulty getting the pictures to
    > appear on the form. I have gone to the extreme of importing the
    > "Employees" table and form from the Northwind sample. However,
    > everytime I try to load the form I get the compile error indicating
    > that "msoFileDialogFilePicker" variable has not been defined. I have
    > tried using the search to find out where in Northwind it was defined,
    > but cannot locate it. Can someone help me figure out what the
    > "msoFileDialogFilePicker" which is part of the "FileDialog(xxxxx)" is
    > and where it can be defined?
    >
    > I have already tried looking at the following solution.
    > Press Alt+F11 to open the VB Editor. In that window, choose menu items
    > Tools -> References..., then look down the list for Microsoft Office
    > 11.0 Object Library (it's 11.0 for Access 2003, 10.0 for Access 2002;
    > 9.0 for Access 2000, 8.0 for Access 97 -- pick the right one). Put a
    > check mark in the box next to that reference, then close the dialog.
    >
    > Can someone please help me.
    >
    > Moses
    >
    >
    >
    >
     
  3. Moses

    Moses
    Expand Collapse
    Guest

    I will look at the information on the hyperlink. Hoewever all of the
    checkboxes that need to be checked off are checked.
    Microsoft Access 10.0 Object library
    Microsoft ActiveX data Objects 2.1 Library

    What else could possibly be missing?


    "Graham Mandeno" wrote:

    > Hi Moses
    >
    > And did you find "Microsoft Office xx.0 Object Library" in the list and
    > select it? Because that should have solved the problem.
    >
    > Does your code compile OK? (from the VB editor window, Debug->Compile <your
    > project name>)
    >
    > Another way to use the file dialog without the MSO object library is to call
    > the Windows dialog directly.
    > See here for an example: http://www.mvps.org/access/api/api0001.htm
    > --
    > Good Luck!
    >
    > Graham Mandeno [Access MVP]
    > Auckland, New Zealand
    >
    > "Moses" <Moses@discussions.microsoft.com> wrote in message
    > news:44701218-9AB0-48B8-8858-F2C66783B6ED@microsoft.com...
    > > am trying to set up a database for an inventory with pictures in
    > > it. I have experienced significat difficulty getting the pictures to
    > > appear on the form. I have gone to the extreme of importing the
    > > "Employees" table and form from the Northwind sample. However,
    > > everytime I try to load the form I get the compile error indicating
    > > that "msoFileDialogFilePicker" variable has not been defined. I have
    > > tried using the search to find out where in Northwind it was defined,
    > > but cannot locate it. Can someone help me figure out what the
    > > "msoFileDialogFilePicker" which is part of the "FileDialog(xxxxx)" is
    > > and where it can be defined?
    > >
    > > I have already tried looking at the following solution.
    > > Press Alt+F11 to open the VB Editor. In that window, choose menu items
    > > Tools -> References..., then look down the list for Microsoft Office
    > > 11.0 Object Library (it's 11.0 for Access 2003, 10.0 for Access 2002;
    > > 9.0 for Access 2000, 8.0 for Access 97 -- pick the right one). Put a
    > > check mark in the box next to that reference, then close the dialog.
    > >
    > > Can someone please help me.
    > >
    > > Moses
    > >
    > >
    > >
    > >

    >
    >
    >
     
  4. Moses

    Moses
    Expand Collapse
    Guest

    Also, when I run the Northwind Sample everything runs right. Just thought I
    would add that bit of information.

    "Graham Mandeno" wrote:

    > Hi Moses
    >
    > And did you find "Microsoft Office xx.0 Object Library" in the list and
    > select it? Because that should have solved the problem.
    >
    > Does your code compile OK? (from the VB editor window, Debug->Compile <your
    > project name>)
    >
    > Another way to use the file dialog without the MSO object library is to call
    > the Windows dialog directly.
    > See here for an example: http://www.mvps.org/access/api/api0001.htm
    > --
    > Good Luck!
    >
    > Graham Mandeno [Access MVP]
    > Auckland, New Zealand
    >
    > "Moses" <Moses@discussions.microsoft.com> wrote in message
    > news:44701218-9AB0-48B8-8858-F2C66783B6ED@microsoft.com...
    > > am trying to set up a database for an inventory with pictures in
    > > it. I have experienced significat difficulty getting the pictures to
    > > appear on the form. I have gone to the extreme of importing the
    > > "Employees" table and form from the Northwind sample. However,
    > > everytime I try to load the form I get the compile error indicating
    > > that "msoFileDialogFilePicker" variable has not been defined. I have
    > > tried using the search to find out where in Northwind it was defined,
    > > but cannot locate it. Can someone help me figure out what the
    > > "msoFileDialogFilePicker" which is part of the "FileDialog(xxxxx)" is
    > > and where it can be defined?
    > >
    > > I have already tried looking at the following solution.
    > > Press Alt+F11 to open the VB Editor. In that window, choose menu items
    > > Tools -> References..., then look down the list for Microsoft Office
    > > 11.0 Object Library (it's 11.0 for Access 2003, 10.0 for Access 2002;
    > > 9.0 for Access 2000, 8.0 for Access 97 -- pick the right one). Put a
    > > check mark in the box next to that reference, then close the dialog.
    > >
    > > Can someone please help me.
    > >
    > > Moses
    > >
    > >
    > >
    > >

    >
    >
    >
     
  5. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    Hi Moses

    The reference you need is Microsoft *Office* 10.0 Object Library.

    Is that one checked?
    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand

    "Moses" <Moses@discussions.microsoft.com> wrote in message
    news:3C0703FE-D0DA-4367-B315-799EDF11CA0D@microsoft.com...
    >I will look at the information on the hyperlink. Hoewever all of the
    > checkboxes that need to be checked off are checked.
    > Microsoft Access 10.0 Object library
    > Microsoft ActiveX data Objects 2.1 Library
    >
    > What else could possibly be missing?
    >
    >
    > "Graham Mandeno" wrote:
    >
    >> Hi Moses
    >>
    >> And did you find "Microsoft Office xx.0 Object Library" in the list and
    >> select it? Because that should have solved the problem.
    >>
    >> Does your code compile OK? (from the VB editor window, Debug->Compile
    >> <your
    >> project name>)
    >>
    >> Another way to use the file dialog without the MSO object library is to
    >> call
    >> the Windows dialog directly.
    >> See here for an example: http://www.mvps.org/access/api/api0001.htm
    >> --
    >> Good Luck!
    >>
    >> Graham Mandeno [Access MVP]
    >> Auckland, New Zealand
    >>
    >> "Moses" <Moses@discussions.microsoft.com> wrote in message
    >> news:44701218-9AB0-48B8-8858-F2C66783B6ED@microsoft.com...
    >> > am trying to set up a database for an inventory with pictures in
    >> > it. I have experienced significat difficulty getting the pictures to
    >> > appear on the form. I have gone to the extreme of importing the
    >> > "Employees" table and form from the Northwind sample. However,
    >> > everytime I try to load the form I get the compile error indicating
    >> > that "msoFileDialogFilePicker" variable has not been defined. I have
    >> > tried using the search to find out where in Northwind it was defined,
    >> > but cannot locate it. Can someone help me figure out what the
    >> > "msoFileDialogFilePicker" which is part of the "FileDialog(xxxxx)" is
    >> > and where it can be defined?
    >> >
    >> > I have already tried looking at the following solution.
    >> > Press Alt+F11 to open the VB Editor. In that window, choose menu items
    >> > Tools -> References..., then look down the list for Microsoft Office
    >> > 11.0 Object Library (it's 11.0 for Access 2003, 10.0 for Access 2002;
    >> > 9.0 for Access 2000, 8.0 for Access 97 -- pick the right one). Put a
    >> > check mark in the box next to that reference, then close the dialog.
    >> >
    >> > Can someone please help me.
    >> >
    >> > Moses
    >> >
    >> >
    >> >
    >> >

    >>
    >>
    >>
     

Share This Page