FrontPage-Data Results

[Howard LeCover]

Why, when I publish a page created in the Database
Results wizard which asks users to enter a number to
search an Access table, do I get the error message

"Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver]
Extra ) in query expression '(number = )'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide
default values for all form fields that are used in the
query.

This appears when the page is first accessed. How do I
fix this problem?

 

[Jim Buyens]

-----Original Message-----

Why, when I publish a page created in the Database
Results wizard which asks users to enter a number to
search an Access table, do I get the error message

"Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver]
Extra ) in query expression '(number = )'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide
default values for all form fields that are used in the
query.

This appears when the page is first accessed. How do I
fix this problem?

On page 3 of the DRW, click the More Options button and
then the Defaults button. Then, set up a default value
for each form field you're using as a criteria.

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*