Hey,
have another interesting problem, we have a field that is calculated with =Format(Currdate,"YYYY-MM-DD") with CurrDate being a text box with a date (selected using a date picker).

This works fine on almost every machine we have installed on. However i have a machine at a clients office that instead of generating the formated date in the text field, fails and displays a #name even though the field is not tied to a data field of any description (This field is used to get a formated date to attach to the front of files that are generated).

Anyone have an idea why this one machine would be doing this?

It does have another quirk in that our .net based launcher does not display correctly and simply cuts to the end of the code to launch the .accdr without actualy checking for downloads. Thinking of re installing .net (Although i have already re installed access run time twice (once back to the same version of 2007 and once updating to 2010)).

As always your help is apriciated.