Prev: opening access2003 from access97
Next: A2010. Can be accessed by phone?
From: Owen on 28 Jul 2010 21:32
Thanks for all the responses.

Salad - Nz() makes no difference.
Requery makes no difference.

Ron - moving DLookup to the Current event worked. Thanks.
Thanks for the eLookup tip.

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

Phil - thanks, I'll look at using eLookup in future.

I'm still mystified as to why the calc field would not display the
value, since it is there when you click the field. But I'll go with
Ron's method to get around it.

Thanks all.
Owen
From: Phil on 29 Jul 2010 04:26
On 29/07/2010 02:32:21, Owen wrote:
> Thanks for all the responses.
>
> Salad - Nz() makes no difference.
> Requery makes no difference.
>
> Ron - moving DLookup to the Current event worked. Thanks.
> Thanks for the eLookup tip.
>
> David - using the lookup value in the recordsource renders the form
> data uneditable.
>
> Phil - thanks, I'll look at using eLookup in future.
>
> I'm still mystified as to why the calc field would not display the
> value, since it is there when you click the field. But I'll go with
> Ron's method to get around it.
>
> Thanks all.
> Owen
>

I,m having problems with the structure of your Lookups_UserT table. Do you
have 2 fields Category and details both text? You alst refer to both
'Provider number' and 'ProviderNumber' , presumably on the form. What sort of
data are they - text or numeric?

Phil
From: John Spencer on 29 Jul 2010 08:10
RESPONDING TO "...could this be a myth?"

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.

For one record I doubt that you could detect much difference (if any) between
Allen Browne's functions and the built-in functions. The enhanced abilities
of Allen's functions are of real benefit and the use of the enhanced abilities
might (I've not tested this) actually make them a bit slower.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

> 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?
>
> Phil
From: paii, Ron on 29 Jul 2010 08:17

"John Spencer" <JSPENCER(a)Hilltop.umbc> wrote in message
news:i2rr3h$rte$1(a)news.eternal-september.org...
> RESPONDING TO "...could this be a myth?"
>
> 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.
>
> For one record I doubt that you could detect much difference (if any)
between
> Allen Browne's functions and the built-in functions. The enhanced
abilities
> of Allen's functions are of real benefit and the use of the enhanced
abilities
> might (I've not tested this) actually make them a bit slower.
>
> John Spencer
> Access MVP 2002-2005, 2007-2010
> The Hilltop Institute
> University of Maryland Baltimore County
>
> > 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?
> >
> > Phil

In this case the OP appears to be calling the dlookup function for each
record on the form. elookup will show a noticeable improvement in displaying
the next record.


From: paii, Ron on 29 Jul 2010 08:21

"Owen" <google(a)healthbase.com.au> wrote in message
news:c156bf09-e4c1-48b8-91a6-52e319b90b00(a)z30g2000prg.googlegroups.com...
> Thanks for all the responses.
>
> Salad - Nz() makes no difference.
> Requery makes no difference.
>
> Ron - moving DLookup to the Current event worked. Thanks.
> Thanks for the eLookup tip.
>
> David - using the lookup value in the recordsource renders the form
> data uneditable.
>
> Phil - thanks, I'll look at using eLookup in future.
>
> I'm still mystified as to why the calc field would not display the
> value, since it is there when you click the field. But I'll go with
> Ron's method to get around it.
>
> Thanks all.
> Owen

I think Access attempts to save time by only refreshing controls it thinks
changed. In your case the row source being a function appears to Access as
static.


First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: opening access2003 from access97
Next: A2010. Can be accessed by phone?