Database Interface Wizard

[Guest]

After using the wizard to create a database interface with an already
existing table I get the following error message when trying to use the edit
function. Sometimes it will tell me one or more fields are empty and
sometimes it will not. No fields are empty.
Any ideas?

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

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

 

[Kevin Spencer]

In a Database, a column can allow or not allow null (Nothing) values. In the
case of text columns, it doesn't matter, as a form field left blank will
insert or update a blank string. Of course, in Access, you can also disallow
a blank string. But in the case of numerical columns, dates, and one or 2
others, a blank value in a form can only be interpreted as a null value. If
the column does not allow nulls, you must provide a default value for the
column in cases where the form fields are left empty by the user, or use
client-side form validation to ensure that the form is submitted with all
the required data in it.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Chicken Salad Alchemist

What You Seek Is What You Get.

 

[Guest]

Thank you Kevin.
The database fields are all text except for the date entered which is the
system default date. I have made sure to put data in every field and the
error still pops up when saved. Any ideas?
Kyleq

 

[Thomas A. Rowe]

Make sure the date field is not named date

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================