Home All Groups Group Topic Archive Search About

can use code to reference mde file?

Author
22 Sep 2006 8:16 PM
Jay
Does anyonw know how to use vba code from mdb to add or replace a reference
to an mde file?
Thanks in advance
--
Jay

Author
23 Sep 2006 12:46 PM
Lynn Trapp
Open the VBE window. Select Tools > References. Click the Browse button to
find your .mde file.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Show quoteHide quote
"Jay" <gunderj@ommunity.nospam> wrote in message
news:2C0C94EA-1121-483E-B0E0-2DE869027D95@microsoft.com...
> Does anyonw know how to use vba code from mdb to add or replace a
> reference
> to an mde file?
> Thanks in advance
> --
> Jay
Author
23 Sep 2006 12:55 PM
Douglas J. Steele
Or, to use vba (as requested <g>), look at the AddFromFile method of the
References collection.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


Show quoteHide quote
"Lynn Trapp" <NOltrapp@SPAMltcomputerdesigns.com> wrote in message
news:%23mzFd5w3GHA.1568@TK2MSFTNGP03.phx.gbl...
> Open the VBE window. Select Tools > References. Click the Browse button to
> find your .mde file.
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
>
>
> "Jay" <gunderj@ommunity.nospam> wrote in message
> news:2C0C94EA-1121-483E-B0E0-2DE869027D95@microsoft.com...
>> Does anyonw know how to use vba code from mdb to add or replace a
>> reference
>> to an mde file?
>> Thanks in advance
>> --
>> Jay
>
>
Author
23 Sep 2006 4:00 PM
Lynn Trapp
<snicker> <grin> You must have noticed that I'm very sleepy this morning...

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Show quoteHide quote
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:eWHrh$w3GHA.1608@TK2MSFTNGP04.phx.gbl...
> Or, to use vba (as requested <g>), look at the AddFromFile method of the
> References collection.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Lynn Trapp" <NOltrapp@SPAMltcomputerdesigns.com> wrote in message
> news:%23mzFd5w3GHA.1568@TK2MSFTNGP03.phx.gbl...
>> Open the VBE window. Select Tools > References. Click the Browse button
>> to find your .mde file.
>>
>> --
>> Lynn Trapp
>> MS Access MVP
>> www.ltcomputerdesigns.com
>> Access Security: www.ltcomputerdesigns.com/Security.htm
>>
>>
>> "Jay" <gunderj@ommunity.nospam> wrote in message
>> news:2C0C94EA-1121-483E-B0E0-2DE869027D95@microsoft.com...
>>> Does anyonw know how to use vba code from mdb to add or replace a
>>> reference
>>> to an mde file?
>>> Thanks in advance
>>> --
>>> Jay
>>
>>
>
>
Author
23 Sep 2006 1:01 PM
Jay
Thanks Lynn,
But my question was how to do this with vba code.
Any ideas?
--
Jay


Show quoteHide quote
"Lynn Trapp" wrote:

> Open the VBE window. Select Tools > References. Click the Browse button to
> find your .mde file.
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
>
>
> "Jay" <gunderj@ommunity.nospam> wrote in message
> news:2C0C94EA-1121-483E-B0E0-2DE869027D95@microsoft.com...
> > Does anyonw know how to use vba code from mdb to add or replace a
> > reference
> > to an mde file?
> > Thanks in advance
> > --
> > Jay
>
>
>
Author
23 Sep 2006 4:01 PM
Lynn Trapp
Jay,
See Doug Steele's comment. I was sleeping.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Show quoteHide quote
"Jay" <gunderj@ommunity.nospam> wrote in message
news:25D5539E-8EEE-431E-84C2-AA4C318C725F@microsoft.com...
> Thanks Lynn,
> But my question was how to do this with vba code.
> Any ideas?
> --
> Jay
>
>
> "Lynn Trapp" wrote:
>
>> Open the VBE window. Select Tools > References. Click the Browse button
>> to
>> find your .mde file.
>>
>> --
>> Lynn Trapp
>> MS Access MVP
>> www.ltcomputerdesigns.com
>> Access Security: www.ltcomputerdesigns.com/Security.htm
>>
>>
>> "Jay" <gunderj@ommunity.nospam> wrote in message
>> news:2C0C94EA-1121-483E-B0E0-2DE869027D95@microsoft.com...
>> > Does anyonw know how to use vba code from mdb to add or replace a
>> > reference
>> > to an mde file?
>> > Thanks in advance
>> > --
>> > Jay
>>
>>
>>