timing problem in Access

[Daniel]

Hi all.
Good afternoon from Sydney.
I need help with a problem here.
We have an access database supporting the work in the office. there are
several reports, forms and querys generated.
It is located on our server and accessable by all the desktops.
And all the functions worked fine.
Last week we got 2 new dell desktops and i installed Office 2003 on both of
them.
when i try to open a January report from a form. the date chosen field is
blank
and then i try to open the query which the report comes from. it give error
msg "function is not available in expression of query ......" and i notice
all query relaied to the Date() is not available.
all of these functions works fine on old desktops with the same version of
Office
I tried to change the language settings to australia date which is dd/mm/yyyy
but still does not work.
Any one can help me with the trouble shoting
thanks a lot

 

[Allen Browne]

Suggestions

1. In Access 2003, go to Macro on the Tools menu.
Choose Security on the flyout, and set it to Low.
For more info on how to turn sandbox mode off, see:
http://support.microsoft.com/kb/294698/en-us

2. If the new laptops come with Office 2003 Service Pack 3, they will have
many problems until you apply this hotfix:
http://support.microsoft.com/?id=840656

3. Try logging in as a local computer administrator.

4. Check your library references are okay:
http://allenbrowne.com/ser-38.html

 

[Daniel]

thanks Allen, I've tried all of your suggestion above just now.
but still doesn't work.
and all other querys not relate to Date() is fine ...

 

[Allen Browne]

If you are certain that sandbox mode is off, and the other issues are
correct, it has to be a problem with references, or bad code.

What references are you using?
(Tools | References, in the code window.)
Try deselecting all but the first 2 (Access and VBA.)
Close Access.
Re-register the others (DAO or whatever) as shown in the article.
Then open the database and select the references you need.
And compile the code to ensure it works.

Also, make sure Name AutoCorrect is off. Compact. Decompile. Compact.
Compile.