date/time field default value

Hi to everyone,

i am building a database application using FrontPage 2003 + Access 2000.
I have a date/time field inside my database(birthdate).
I use a wizard inside FrontPage to filter my database.
At some step the wizard asks me to assign a default value to birthdate.
What value should i assign?
now(),=now(),date,=date() ....?

Whatever i have tried i am always getting the same error:

Database Results Wizard Error
Description: Parameter ?_1 has no default value.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine


Thanks
Thanasis

Re: date/time field default value

Do it inside Access itself, FP is a load of cr_p

Load up the DB > open it in Design view, select the field, change the data
type and enter a default value (will even help you ;o)).

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"Thanasis (sch)" wrote in message
news:uMuHzEn#EHA.2552@TK2MSFTNGP09.phx.gbl...
> Hi to everyone,
>
> i am building a database application using FrontPage 2003 + Access 2000.
> I have a date/time field inside my database(birthdate).
> I use a wizard inside FrontPage to filter my database.
> At some step the wizard asks me to assign a default value to birthdate.
> What value should i assign?
> now(),=now(),date,=date() ....?
>
> Whatever i have tried i am always getting the same error:
>
> Database Results Wizard Error
> Description: Parameter ?_1 has no default value.
> Number: -2147217904 (0x80040E10)
> Source: Microsoft JET Database Engine
>
>
> Thanks
> Thanasis
>
>
>