I have created an access data base in access
2007
I have created a .accde file and packaged
using
packaging wizard included access runtime 2007
Installed on test machine.
Test machine has no office software installed
Database opens but when i try to access a
form
based on a query which uses the Date()
function
to calculate one of the fields i get the
following error message
“Function is not available in expressions in
query expression
IIF(PaymentDue>=Date(),Price=10,Price = 0)
Actions so far: –
Checked references – this was difficult
because
i cant open VBA in access runtime to check if
any references have been broken. So i have
manually checked all reference files exist on
test machine
I think that the test machine dosnt like the
Date() function and would prefer the just
Date
which is used in the VBA environment but will
not work in the access query
Thanks Paul
