DLookup value not visible until clicked

#11

"Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in
news:MdqdnZxJQqtlBs3RnZ2dnUVZ8mOdnZ2d (AT) brightview (DOT) co.uk:

Quote:

I always use Elookup instead of Dlookup as well as EMax, EMin etc.
I tried to test the difference in speed in AK2 some time ago and
found very little difference. Almost certainly wrong, but could
this be a myth?

In A97, the domain lookup and domain aggregate functions were much
slower on linked tables, but that was fixed starting in A2000. The
hand-rolled replacement functions for them (such as Trevor Best's
t-functions, the versions I've always used, and have extended myself
in ways that make them more versatile than the built-in Access
functions, though they are no faster now) are really no longer
necessary for performance reasons.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#12

Owen <google (AT) healthbase (DOT) com.au> wrote in
news:c156bf09-e4c1-48b8-91a6-52e319b90b00 (AT) z30g2000prg (DOT) googlegroups.co
m:

Quote:

David - using the lookup value in the recordsource renders the
form data uneditable.

What if you use the DISTINCTROW predicate?

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#13

John Spencer <JSPENCER (AT) Hilltop (DOT) umbc> wrote in
news:i2rr3h$rte$1 (AT) news (DOT) eternal-september.org:

Quote:

The domain functions (DLookup, DMax, DMin, etc.) are relatively
slow, but you only notice the "slowness" when you are calling them
multiple times in a loop of some kind. Or if you are calling them
in a query and returning a lot of records or are filtering on the
result of the function call.

As I said in another answer, in A97, they were notably slow on
linked tables, so everybody rolled their own to get the speed back.
A2000 fixed the problem but many of us kept using them out of
intertia and because we'd extend them to offer other features (such
as being able to use a database other than the current one).

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DLookup value not visible until clicked

comp.databases.ms-access comp.databases.ms-access

Re: DLookup value not visible until clicked - 07-29-2010 , 05:21 PM

Re: DLookup value not visible until clicked - 07-29-2010 , 05:21 PM

Re: DLookup value not visible until clicked - 07-29-2010 , 05:22 PM