Empty date field

Results 1 to 2 of 2

Thread: Empty date field

  1. #1
    Join Date
    Dec 1969

    Default Empty date field

    I have a problem inserting date into database(Access).When the date is filled on the form and submitted everithing is OK.<BR>When is left blank I have a message : <BR>"Data type mismatch in criteria expression"<BR>Any help appreciated,<BR>Lyn<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Empty date field

    Well test to see if they have entered a date, and if they havn&#039;t then don&#039;t use that field in your SQL statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts