Function is not available in expressions in query expression "Dloo

[Functions will not work in Access 2007 r]

I have a fully functioning database ( actually from microsoft) and it really
does work on the computer that has a full office 2007 installation.

I used the package wizard and installed it on aonther computer. So far, so
good.
When I run the database on the other computer, none of the standard
functions work. These funtions include date() and dlookup ( I assume no other
frunctions work). This other computer has office 2003 ( maybe the problem ?)
and the 2007 runtime. The accdr file runs, it just will not allow standard
functions to work. When you are in the runtime, you can not see the vba
references either. help?

 

[Tom van Stiphout]

On Tue, 26 May 2009 17:58:01 -0700, Functions will not work in Access
2007 r <Functions will not work in Access 2007
(e-mail address removed)> wrote:

It's true you cannot see the references, but nothing prevents you from
adding some code to your startup code to iterate over the references
collection and check for missing ones. I'm sure you can find the
sample code to do so. This code, if written correctly, will work even
when there are broken references, because it will fully qualify its
method calls (e.g. VBA.Left etc)

-Tom.
Microsoft Access MVP

 

[Tom van Stiphout]

On Tue, 26 May 2009 17:58:01 -0700, Functions will not work in Access
2007 r <Functions will not work in Access 2007
(e-mail address removed)> wrote:

It's true you cannot see the references, but nothing prevents you from
adding some code to your startup code to iterate over the references
collection and check for missing ones. I'm sure you can find the
sample code to do so. This code, if written correctly, will work even
when there are broken references, because it will fully qualify its
method calls (e.g. VBA.Left etc)

-Tom.
Microsoft Access MVP