Date default field shows "#Name?"

[weavind]

HI,

I have a table that I have a date field with "Date()" as the default value. The tables sits on a linux server. The frontend is copied to each workstation. The forms that access this table works perfectly fine on my computer (Win7) and notebook (WinXP), but on some workstations, the field shows as #Name?. I have updated the links on the tables as well as checked the regional settings ont he computers, however I still can't understand it . Any ideas?

Thanks in advance.

 

[The_Doc_Man]

If it works some places and not others, the issue could very well still be references.

One factor that is not often fully appreciated is the the order of reference appearance is important. Find one workstation where it works and one where it doesn't. Open up the reference lists on both and compare their order. You can click on a reference and use the up/down buttons on the reference dialog box to change the order of reference visits. See if that helps.

If not, then I'd have to think about it some more.

 

[weavind]

Thanks Doc Man. With your help, I found the problem. It is the references that is the problem, however it is to do with Office 2003 and 2007. I compiled the database on my notebook which has Office 2003 and 2007. The main users only have Office 2003. When I compiled the database, it looks for the Excel 12.0 object library which is part of Office 2007. This needs to be changed to Excel 11.0 object library for the database to work. I just compiled the database on another machine with only Office 2003 installed (lazy fix which works, for now).