I would set this in Access...set the default field value to Now()... then
there is no need to have the hidden field in your form and less is handled
by CF... Access will handle this much more efficiently and faster than CF
would.
Jay
> -----Original Message-----
> From: Jamie Symonds [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 21, 2000 11: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/[email protected]/
> 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/[email protected]/
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.
