Parameter ?_1 has no default value

[Thanasis \(sch\)]

Hi to everyone,

I'm using FP2003 with Access.
Inside my access database i have put a date/time field(article_date).Inside
ms access this field has format (short date) and default value (date())
What i want to achieve is to filter my database using a search form .
I want the user to search the database giving a date.So my search form
contains only one text box
where the user types a date and filters the database.
I have put the search form and the results page inside the same asp page
(search_date.asp).
I have applied the DataBase Results Wizard.
Insert--> DataBase-->Results-->IN STEP 1 i choose ASP and choose my existing
database connection-->IN STEP 2 i choose the record source-->IN STEP 3 i
click on more options > criteria >add>and i choose as field name
(article_date), then i choose as comparison equals and then as value
(article_date) and i set the check box (use this search form field). Then i
click OK 2 times.
In the same STEP 3 there is a button with label Defaults. I don't provide a
default value for article_date field, since i've done it inside ms access(
is it necessary to provide a default value here?).
I go on on STEP 4 then on STEP 5 where i check the check box Add search form
and the wizard is finishing.

However when i open my search_date.asp page i'm always getting the error:

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

I'd like to point out that if i type a date and click on Submit Query i get
the results i expect to.
Only when my page is loaded for the first time i get this error.


Any help would be very much appreciated
thanks
thanasis

 

[Kathleen Anderson [MVP - FrontPage]]

Please don't multi-post. Please pick one group and stick to it, or
cross-post if you must.

Thanks,

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx