t into x (y)
values (GetDate())
Duane Boudreau
CFExperts.Com
-Original Message-
From: Fred T. Sanders [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 29, 2000 2:44 PM
To: [EMAIL PROTECTED]
Subject: Re: Inserting the Date in Access
They might want to change the format to short date
DATE (like maybe
>"DateEntered"). Then it will work.
>
>Fred
>
>- Original Message -
>From: "Brian Ingram" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Saturday, April 29, 2000 11:43 AM
>Subject: Inserting the Date in Acc
They might want to change the format to short date, otherwise it also show's
the time.
- Original Message -
From: "Oblio Leitch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 29, 2000 1:31 PM
Subject: Re: Inserting the Date in Access
The best solution I can think of:
If all you want to do is record the date an entry into the database was
made is set the "default value" of the field to "Now()".
-Step-By-Step-
1. Open the database in Access
2. "design" the table (highlight the table; click "design" on the left)
3. select the
gt;
> - Original Message -
> From: "Brian Ingram" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, April 29, 2000 11:43 AM
> Subject: Inserting the Date in Access
>
>
> > I've been having problems inserting the CurrentDa
: <[EMAIL PROTECTED]>
Sent: Saturday, April 29, 2000 11:43 AM
Subject: Inserting the Date in Access
> I've been having problems inserting the CurrentDate in Access as well.
I've tried setting the data type up as a text and as a date/time, but
neither work.
>
> What is the bes
Using date as part of a form variable name,
for example MyVar_date, will also
create a hard to find error with CF
best, paul
At 01:02 PM 4/29/00 -0400, you wrote:
>First off date is an Access reserve word.
--
Archives:
where the data
type is number or date/time.
INSERT INTO Review (DTE)
VALUES (#CurrDate#)
- Original Message -
From: Brian Ingram <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 29, 2000 12:43 PM
Subject: Inserting the Date in Access
> I've
ssage-
From: Brian Ingram <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Saturday, April 29, 2000 10:43 AM
Subject: Inserting the Date in Access
>I've been having problems inserting the CurrentDate in Access as well. I've
tried setting the d
>I've been having problems inserting the CurrentDate in Access as well. I've
tried setting the data type up as a text and as a date/time, but neither
work.
>
>What is the best way to do it?
The best way is NOT to insert it. Instead, set the default value of the
field (in Access) to Now() or D
I've been having problems inserting the CurrentDate in Access as well. I've tried
setting the data type up as a text and as a date/time, but neither work.
What is the best way to do it?
When i try to insert the date i get this error:
===
ODBC Error Code = 37000 (Syntax
11 matches
Mail list logo