My version of a form works perfectly. A text box for a date field in a new record with default of Date() shows today's date, as it should.



I sent an ACCDE version of the file to someone in the US (I'm in Autralia) - might be relevant given different date conventions.

When the form opens, she gets this message:
Function is not available in expressions in query expression 'Date('
and she gets #Name? in the text box.

When she uses the little calandar to enter a date, she initially gets this message:

Function is not available in expressions in table-level validation expression.

When she clicks ok on that, and tries the little calendar again, it works.
She sent her file back to me and no such problems at my end at all.

Given a previous post, I went to Visual Basic, opened Tools, References, and these have a tick next to them, the rest don't:

Visual Basic for Applications
Microsoft 12.0 Object Library
OLE automation
Microsoft ActiveX Objects 2.1 Library
Microsoft Office XP Web components
VSDataIO OLE Control Module
Microsoft Visual Basic for Applications Extensibility 5.3

Hers only has these ticked (and none marked as missing)
Visual Basic for Aplications
Microsoft 12.0 Object Library
OLE automation

she also has this one ticked, but I don't:
Microsoft Office 12.0 Access Engine Database Object

I'm relatively new to Access but have written some code in Visual Basic rather than relying on queries and macros, so I'd cope with something in that direction ok (probably).

From scrounging around, I gather that it's a referencing/library problem, but how do I get around it?