|
| |
|
|
markjlawrence
Posts: 119
From: Belfast Northern Ireland
Status: offline
 |
Update query doesn't like empty fields - 4/19/2001 15:31:00
Hi,I have created database results using the DRW. The fields are displayed as text boxes. The results are withing a form posting to a query which updates the database with the new values. However, if any of the fields are left empty, the query fails with an error saying that I must include a value. Is there a way round this? Mark.
|
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Update query doesn't like empty fields - 4/19/2001 16:37:00
In Access, design view, ensure all the text fields "allow zero length"------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
