Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / December 2004

Tip: Looking for answers? Try searching our database.

Unkowng function error 3320

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
hermie - 14 Dec 2004 12:44 GMT
Hello

In my datefield name Date_actual I want to put the default value with ( )
now. When I put ( ) now in the field I cannot save the database and get this
error message: unkown function name intable-level validation expression?
My table has only 5 fields
PK ID_BARRERA_TRABAJO    autonumber
     CODIGO_BARRERAS          text
      SEG_SOC_PART                  text
      DATE_GESTION                 date/time
      DATE_ACTUAL                    date/time

Why can I not save the database?
Hope someone have a solution

Herman
Nikos Yannacopoulos - 14 Dec 2004 13:18 GMT
Did you mean to use the function:
Now()
by any chance?

Nikos

> Hello
>
[quoted text clipped - 12 lines]
>
> Herman
hermie - 14 Dec 2004 13:24 GMT
Hi Nikos

Yes i want to put now() as default value in the field date actual and get
this message when want to save the database.

Herman

> Did you mean to use the function:
> Now()
[quoted text clipped - 18 lines]
> >
> > Herman
 
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.