Welcome to SPN

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

Sign Up Now!

Re: msoFileDialogFilePicker

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

  1. BrooksC

    BrooksC
    Expand Collapse
    Guest

    Thanks very much. YOu help was so straight forward and helpful.

    Dirk Goldgar wrote:
    > *"TOMK" <TOMK@discussions.microsoft.com> wrote in message
    > news:9241482D-E0BA-4948-AC20-1AF24B440834@microsoft.com
    > > I 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?
    > >
    > > Any assistance would be appreciated.
    > > PS as you probably figured out I am pretty much of a novice.

    >
    > 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.
    >
    > Now the "mso..." constants should be defined, and your code can use
    > them.
    >
    > --
    > Dirk Goldgar, MS Access MVP
    > www.datagnostics.com
    >
    > (please reply to the newsgroup) *




    --
    BrooksC
    ------------------------------------------------------------------------
    Posted via http://www.mcse.ms
    ------------------------------------------------------------------------
    View this thread: http://www.mcse.ms/message908935.html
     

Share This Page