Function gives error in WinXP but in Win2k works fine in Access2003 (Ungent)

[deependrapathak]

Hi All,

I am currently facing a crutial problem in Access2003 in Windows XP on just 3 PCs, the Application throws some of the errors specified below :

1. Error Number : 3075 Function is not available in expressions in query expression 'Format([Field_Name],"$#,##0.00")' .

2. On Click Error : The expression you entered refers to an object that is closed or doesn't exist.

3. On Click Error : Function is not available in expressions in query expression
'First(IIf(Ucase$([Field_Name)="A",1,2))'

I have already checked for the following points:

1. Installed and Re-installed the Setup.
2. Check for all OCX & DLL are there at location.
3. No Missing Reference exists.
4. Latest version of MDAC is already installed.
5. Jet Engine is already Updated.
6. XP SP2 is installed.

Also checked the system having same configuration with the working one.

As per my observation the error is in the Functions used in the Query called on the click event.

What could be the more causes for the error.

Please help its urgent.

Thanks in adavnce
Deependra

[ADezii]

Hi All,

I am currently facing a crutial problem in Access2003 in Windows XP on just 3 PCs, the Application throws some of the errors specified below :

1. Error Number : 3075 Function is not available in expressions in query expression 'Format([Field_Name],"$#,##0.00")' .

2. On Click Error : The expression you entered refers to an object that is closed or doesn't exist.

3. On Click Error : Function is not available in expressions in query expression
'First(IIf(Ucase$([Field_Name)="A",1,2))'

I have already checked for the following points:

1. Installed and Re-installed the Setup.
2. Check for all OCX & DLL are there at location.
3. No Missing Reference exists.
4. Latest version of MDAC is already installed.
5. Jet Engine is already Updated.
6. XP SP2 is installed.

Also checked the system having same configuration with the working one.

As per my observation the error is in the Functions used in the Query called on the click event.

What could be the more causes for the error.

Please help its urgent.

Thanks in adavnce
Deependra

Kindly post the actual code.

[NeoPa]

I suspect the SQL for the query that calls the function may prove helpful too. Can you include that in your post too please.