"Date()"..problem w/access97 version 1

[microtoolmaker]

in Access 97-<br>
&quot;=Date()&quot; is being used as a default value in a text box in a form. When the form is open there is an error msg. &quot;#name&quot;<br>
<br>
2000 version takes this and shows it fine...anyone know what might be wrong?

 

[DougP]

No but this will work in both<br>
=format(Now,&quot;mm/dd/yy&quot<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[elizabeth]

I've seen this message in several places referenceing the #name error:<br>
<br>
&quot;...Search for Msowcf.dll on your computer.&quot;

 

[jgarnick]

I had the same problem. I just created a new database and imported all the objects into the new one and it fixed it......?? <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>

 

[rhicks]

First thing I would check would be missing library references.<br>
I also have seen in Access 2000, there would be no &quot;Is Missing&quot; attached to any of the libraries. You could uncheck one of the references, close the module, reopen the module and recheck the reference you had just uncheck and it would re-initialize the libraries and solve the problem<br>
<br>
Good Luck,<br>
RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>

 

[ISS]

What's the proper query syntax that will retrieve for me all records created since the beginning of last month?