Type Conversion Error & Format function not working correctly

[jackpot]

One of the Query is formatting date in this way
Format([EFF DATE],"mm/dd/yyyy&quot AS Effdate
For the same database a person in one location can run the query correctly but another person in another location gets #Error in that column. Can any body suggest any solution.
Format function used that way on other table works fine.

 

[Databaseguy]

Check the short and long date/time properties in the control panel/regional settings and make sure they are the same on both machines Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[jackpot]

Both M/c have same setting for long date & short in regional settings. I just checked it.

To continue with it most function seems to give problem. I am also using Left$ , Right$, Format and all give problem.

Yet on another database on same m/c it works fine.
If I apply the mask thru format tab then output is correct.
Then what is going wrong by directly using the functions.

 

[jebry]

Hi!

Check the references in a VBA window. If one is marked missing, recheck it. It is possible that you may need to re-install Access on the machine in question.

hth
Jeff Bridgham