Date function failing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access ADP application that connects to a SQL Server database. One field on the form, an unbound field, has as its default value the current date. In the data tab, default value, I have the following, "=Date()"

On most machines the field display's the current date as the default value. However, on several other machines I get the unknown value (#?name or whatever it defaults to)

Any ideas

Bill
 
Likely to be the References Error.

See Douglas J. Steele's article:

<http://members.rogers.com/douglas.j.steele/AccessReference
Errors.html>

HTH
Van T. Dinh
MVP (Access)



-----Original Message-----
I have an Access ADP application that connects to a SQL
Click to expand...
Server database. One field on the form, an unbound field,
has as its default value the current date. In the data
tab, default value, I have the following, "=Date()".
On most machines the field display's the current date as
Click to expand...
the default value. However, on several other machines I
get the unknown value (#?name or whatever it defaults to).
 
Back
Top