Re: msoFileDialogFilePicker

#1 (**permalink**) 28-Jul-2006, 08:41 AM

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

Dirk Goldgar wrote:
> *"TOMK" 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13934-re-msofiledialogfilepicker.html
> > 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13934
> > 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