Jamie,
I had a similar question with Access and I solved the problem by setting the
feild to date/time and the default value to Now(). Worked like a charm for
me and I can retrieve the date time stamp of the record in other forms.
Good Luck
-----Original Message-----
From: Jamie Symonds [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 22 August 2000 12:47 AM
To: [EMAIL PROTECTED]
Subject: date/time, access mdb
This is a multi-part message in MIME format.
--------------5C6A9BCB36B81CBF5001173F
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I'm looking to include a date/time with a form submission to
an access db. I have a field called "datetime" in my db,
and want this value = to Now() when the form is initially
submitted. I will use a field, type="hidden", and
value="xxx" for submitting the date? From my understanding
thus far, I know that I will use a
#CreateODBCDateTime(datetime)# to properly display the
date/time when I view the record at a later date. All
replies appreciated!
Jamie
--------------5C6A9BCB36B81CBF5001173F
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Symonds, Jamie
Content-Disposition: attachment; filename="vcard.vcf"
begin: vcard
fn: Jamie Symonds
n: Symonds;Jamie
adr: Box 780;;St. F.X.U.;Antigonish;Nova Scotia;B2G 2X1;Canada
email;internet: [EMAIL PROTECTED]
title: Bachelor of Information Systems, Major (student)
x-mozilla-cpt: ;0
x-mozilla-html: TRUE
version: 2.1
end: vcard
--------------5C6A9BCB36B81CBF5001173F--
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.