[AccessD] ADO Problem

It would appear that dtToday has been declared but not initialized with value other than its default.


----- Original Message ----
From: Beach Access Software <bchacc at san.rr.com>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Tuesday, November 28, 2006 1:15:13 PM
Subject: [AccessD] ADO Problem


Dear List:

A colleague (who thinks I know ADO) writes in to ask why the following:

   Conn.Execute "INSERT INTO tWeeklyUpdateSent ( DateSent ) " & _
                 "SELECT " & dtToday & ""

Inserts a record into tWeeklyUpdateSent so the conection is OK.  But but the
date is 1/1/1900 instead of today’s date.

I had him check the contents of dtToday and it does indeed have 11/28/2006
in it.

Does anyone see what he's doing wrong here?


MTIA

Rocky


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com