DLOOKUP as a sufficient function for making a dynamic database

T

thread

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
 
S

Stefan Hoffmann

hi,
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?
Click to expand...
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
Click to expand...
If you need multiple lookups, e.g. in a loop, then try to aviod it.


mfG
--> stefan <--
 
S

Susie DBA [MSFT]

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

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

Tony Toews [MVP]

Susie DBA said:
DAO is depecrated, who gives a **** what you think about DAO

go and **** yourself, newbie DAO crackhead loser
Click to expand...

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/
 
Top