Access does not reconize Date() function! 2

[Robertd]

Hi All,<br><br>i have come accross a situation where access does not reconize its Date() function even as a default value for for a field in a table?<br><br>the situation is a converted Access 97 database running on access 2000, says unknown function Date() in module.<br>and the field displays #error.<br><br>you can manually enter a date in the text field or use the Now() function (which works!) but this is ugly for the user!<br>as well i need to remove the time portion with code.<br><br>any ideas??<br><br>RobertD<br><br><br>

 

[PaulF]

you might check for a missing Library.&nbsp;&nbsp;Open a Code module in design view, select TOOLS - REFERENCES from the Menu.&nbsp;&nbsp;Look for an entry that states &quot;MISSING&quot;, if you find one, &quot;Click&quot; on the checkbox to its value to True.<br><br><br>PaulF<br>

 

[rkumar]

On a related note, sometimes the same bizarre thing happens with some of the most instrinsic functions in Access such as the Format function even with all the references set in the libraries. This has happened to me on several occasions. Our discussions with Microsoft have revealed that this could be a bug. The workaround is to create an user defined function in a module and have that function call the built-in function.<br><br>If your problem still persists after you try PaulF's suggestion, you may want to try this solution. <br><br>Good Luck <p>ramesh<br><a href=mailto:rkumar@fullerton.edu>rkumar@fullerton.edu</a><br><a href=

http://www.fullerton.edu>University

Home Page</a><br>

 

[Robertd]

Hi Paul and Remish,<br><br>Yep that was the problem, but a litle bizare the missing reference was to <br>c:\winnt\system\mscomct2.ocx<br><br>now i run a couple of nt4 box's and a couple of win 95 box's and tested the code before sending it on one of the win95 box's it worked fine. but not on the clients pc?<br><br>the give away was also some errors re other built in functions when atempting to compile the code module!<br><br>all fixed and client is happier, and i have one less headache.<br><br>thanks Guy's<br><br>see ya<br>RobertD<br>