date/time default value

[Thanasis \(sch\)]

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

 

[Van T. Dinh]

Why would you want to default a birthdate, anyway?

The default value is only useful if it is correct most of the times which
cannot happen for birthdates.

In _pure_ Access, you should be able to use Date() but you are doing it
through the FrontPage interface so you are only using JET which may _not_
recognise Date() by itself since Date() is a VBA function. There may be
restriction in the FrontPage as well.

I would suggest you post the question in one of the FrontPage newsgroups
also since there may be other people who has experience using JET (_not_
Access) through the FrontPage interface.