ELookUp / DLookUp

Da der ikke er nogen response må jeg formode der ikke er nogen der kender  ELookUp

Hvordan udtrækker man så hurtigt en enkelt værdi , hvorefter DB lukkes

Reason why there was no response from is that it didn't want to get involved in why "din max størrelse af åbne filer er nået" and still dont ;-)

And also, what are you going to do with the value you get from e/dlookup after the dB is closed, you dont mention that in your question.

If I just answered your question, I could suggest using dlookup, or even open a recordset to get the value, which is really only what elookup is doing. And once you have the value use DoCmd.Quit to oclose dB.

I may be missing something but I dont see elookup closing dB??

Hvis den den heller ikke er hurtigere så er det jo ikke rigtigt som
den er opreklameret til.

Hej Terry
Du skriver lukke DB med DoCmd.Quit

Hvordan vil du f.eks lukke Db imellem hver af disse Selecter (Jeg har mange efter hinanden)

Me.[Linie].SetFocus
Me.[Linie].RowSource = SELECT FirmaNavn FROM Firma WHERE FirmaId= " &
FirmaIde
Me.[Linie].Requery
.
.    (Hvordan lukkes DB her?)
.
Me.[Linie2].SetFocus
Me.[Linie2].RowSource = SELECT FirmaNavn FROM Firma WHERE FirmaId= " &
FirmaIde2
Me.[Linie2].Requery

"Reason why there was no response from is that it didn't want to get involved in why "din max størrelse af åbne filer er nået" and still dont ;-)"

If its necessary to close the dB between  select statements then there is something very wrong which I cant help with. And I dont see how elookup cant help either.

I think you should consider  redesigning the dB.