Hi all,

i found out that using DLOOKUP i can bypass the database object
declaration
is it suffiecent or there are some disadvantage in this function,is
there a better function for this use?
any comments on this

hi,

thread wrote:
> i found out that using DLOOKUP i can bypass the database object
> declaration
> is it suffiecent or there are some disadvantage in this function,is
> there a better function for this use?
If you are using it seldomly, then you may use it, but it is slower then
using an DAO.Recordset.

http://www.mvps.org/access/modules/mdl0012.htm

> any comments on this
If you need multiple lookups, e.g. in a loop, then try to aviod it.


mfG
--> stefan <--

DAO is depecrated, who gives a **** what you think about DAO

go and **** yourself, newbie DAO crackhead loser




On May 21, 1:49 am, Stefan Hoffmann <stefan.hoffm...@explido.de>
wrote:
> hi,
>
> thread wrote:
> > i found out that using DLOOKUP i can bypass the database object
> > declaration
> > is it suffiecent or there are some disadvantage in this function,is
> > there a better function for this use?
>
> If you are using it seldomly, then you may use it, but it is slower then
> using an DAO.Recordset.
>
> http://www.mvps.org/access/modules/mdl0012.htm
>
> > any comments on this
>
> If you need multiple lookups, e.g. in a loop, then try to aviod it.
>
> mfG
> --> stefan <--

"Susie DBA [MSFT]" <s u s i ed b a @ ho t mail.com> wrote:

>DAO is depecrated, who gives a **** what you think about DAO
>
>go and **** yourself, newbie DAO crackhead loser

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/