Command "DLookup"

[Lars-Ove Andersson]

I have problem with the command "DLookup" in Access 2000.
The command takes very long time to run.
Have anybody any solution for this.
//LOA

[Trevor Best]

Lars-Ove Andersson wrote:

I have problem with the command "DLookup" in Access 2000.
The command takes very long time to run.
Have anybody any solution for this.
//LOA

This is usually faster than DLookup:
http://easyweb.easynet.co.uk/~trevor.../baslookup.zip

But the underlying problem may remain, depending on what that is, what
you're selecting from, any criteria you're using, what is/is not
indexed, how many records, etc. There are so many variables to determine
the speed at which something will run.
--
This sig left intentionally blank

[PC Datasheet]

First, DLookup is not a command! A stored query based on the same table or
query with the same criteria will run much faster.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Lars-Ove Andersson" <la****************@ikonklippan.se> wrote in message
news:cb**************************@posting.google.c om...

I have problem with the command "DLookup" in Access 2000.
The command takes very long time to run.
Have anybody any solution for this.
//LOA

[Lars-Ove Andersson]

When running "tLookup" the code stop on "inum", do I need any special
DLL-file or something other.
//LOA
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Trevor Best]

Lars-Ove Andersson wrote:

When running "tLookup" the code stop on "inum", do I need any special
DLL-file or something other.

It requires a reference to DAO although there's no "inum" that I know
of, perhaps it stoped in your own code because of a compile error?
(cause by lack of DAO reference)

--
This sig left intentionally blank

[Lars-Ove Andersson]

Sorry!

It should be "ENUM" not "INUM"
I have added reference to DAO, but the program still stop at "ENUM".

//LOA
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Trevor Best]

Lars-Ove Andersson wrote:

Sorry!

It should be "ENUM" not "INUM"
I have added reference to DAO, but the program still stop at "ENUM".

Aha, Sorry your version of Access is not as advanced :-)

Just change the block:

Public Enum tLookupReset
tLookupDoNothing = 0
tLookupRefreshDb = 1
tLookupSetToNothing = 2
End Enum

to:

Public Const tLookupDoNothing = 0
Public Const tLookupRefreshDb = 1
Public Const tLookupSetToNothing = 2

It will still work but you won't get the intellisense combo to choose
those values when you code it although typing "tlookup" then hitting
Ctrl+space will pop them up.

--
This sig left intentionally blank