 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / April 2006Date function not recognised in Access
I hope some people out there might be able to help me. I have an Access 2002 database with various tables in it. If I go in to design view of any table which has a date field in it and then modify the table design and save and close the table it gives an error "This function is not Recognised". I go to the date field and my default value for that field is set to : =Date() and it doesnt recognise this function at all for some reason. This error hapens on certain machines and on some it does not happen. Check the References (open a code module, click Tools|References). It sounds like one's gone MISSING. Uncheck it, close, reopen the References, re-check it, and recompile.  SignatureRegards Jeff Boyce Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ > I hope some people out there might be able to help me. I have an Access 2002 > database with various tables in it. If I go in to design view of any table [quoted text clipped - 3 lines] > doesnt recognise this function at all for some reason. This error hapens on > certain machines and on some it does not happen. Thanks, but this is not an application written in the database, this is purely a database with tables in it. and this error happens on the tables level when I view a table in design mode. Then the error Occurs on a field that has a data type of date/time and the default value is set to =date(). It states that it does not recognise that function. Any help will be greatly appreciated.. > I hope some people out there might be able to help me. I have an Access 2002 > database with various tables in it. If I go in to design view of any table [quoted text clipped - 3 lines] > doesnt recognise this function at all for some reason. This error hapens on > certain machines and on some it does not happen. Jeff's comment still applies. You might have a missing reference. Just create an empty code module, so you can get to the Tools:References command, to check for that. HTH, TC (MVP Access) http://tc2.atspace.com It makes sense to me that it can be the references and dll's that access use, but what if the user only has access runtime installed on their machine? What steps need to be taken to rectify this problem then? > Jeff's comment still applies. You might have a missing reference. Just > create an empty code module, so you can get to the Tools:References [quoted text clipped - 3 lines] > TC (MVP Access) > http://tc2.atspace.com If Access runtime is installed, the VBA dll is also installed on the PC. SignatureHTH Van T. Dinh MVP (Access) > It makes sense to me that it can be the references and dll's that access > use, > but what if the user only has access runtime installed on their machine? > What > steps need to be taken to rectify this problem then? It may not be the cause but I normally use Date() *without the equal sign in the DefaultValue Property of the Field in Table DesignView. SignatureHTH Van T. Dinh MVP (Access) >I hope some people out there might be able to help me. I have an Access >2002 [quoted text clipped - 7 lines] > on > certain machines and on some it does not happen. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.