Dlookup not working in Access 2002

[Lasse T]

Hello !!

Can someone see what could be wrong here. This works in Acess 2000 but not
in Acess 2002 and not in Access 2000 Runtime. I get #Error.

=Dlookup("[sumejfakt]";"[antalejfakt]")
Antalejfakt is a sum query

Thanks in advance.

Lasse T
--------------

 

[Geoege]

-----Original Message-----
Hello !!

Can someone see what could be wrong here. This works in Acess 2000 but not
in Acess 2002 and not in Access 2000 Runtime. I get #Error.

=Dlookup("[sumejfakt]";"[antalejfakt]")
Antalejfakt is a sum query

Thanks in advance.

Lasse T

Have you tried:-

=Dlookup("[sumejfakt]","antalejfakt")

 

[Lasse T]

-----Original Message-----
Hello !!

Can someone see what could be wrong here. This works in Acess 2000 but not
in Acess 2002 and not in Access 2000 Runtime. I get #Error.

=Dlookup("[sumejfakt]";"[antalejfakt]")
Antalejfakt is a sum query

Thanks in advance.

Lasse T

Have you tried:-

=Dlookup("[sumejfakt]","antalejfakt")

Yes. No difference

 

[Lasse T]

Hello !!

Can someone see what could be wrong here. This works in Acess 2000 but not
in Acess 2002 and not in Access 2000 Runtime. I get #Error.

=Dlookup("[sumejfakt]";"[antalejfakt]")
Antalejfakt is a sum query

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
.DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

Thanks for your answer.
The problem is: How do I do that in Access runtime? I installed Access 2000
runtime in a computer with no Office installed to test the application. I
did a serarch in the "runtime" computer for all the files that is checked in
the references in the other computer and all the filse exisits. I also tried
the app. in two different Access 2002 computers but I did not check the
references there. My goal is to make this work in a runtime enviroment. I do
not yet have the Developer edition. I will buy it but I need to know if I
can make it work first. It´s a lot of money to spend.

Lasse T
-------------