Witango-Talk: Inserting time into Access :-(

2004-01-14 Thread Ben Johansen
Ok, I used to know, how to do this, and I have searched the list and I can't find it. I guess I got Mid-ziehemers. I am trying to insert a time into an access table. Can someone please smack me up-side-the-head ;-) Ben Johansen - http://www.pcforge.com Authorized Witango MDaemon Reseller

RE: Witango-Talk: Inserting time into Access :-(

2004-01-14 Thread Tom Ferguson
- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 10:17 AM To: 'WiTango List' Subject: Witango-Talk: Inserting time into Access :-( Ok, I used to know, how to do this, and I have searched the list and I can't find it. I guess I got Mid-ziehemers. I am

Re: Witango-Talk: Inserting time into Access :-(

2004-01-14 Thread Eric Weidl
Hi, Access doesn't have a dedicated time data/column type. You need to use the Date/Time data type which records a timestamp (Date + Time). Since you don't want or need the date information, when setting the data to store in the field, you can use any date, but you do have to specify one.

RE: Witango-Talk: Inserting time into Access :-(

2004-01-14 Thread Ben Johansen
To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Inserting time into Access :-( Hi, Access doesn't have a dedicated time data/column type. You need to use the Date/Time data type which records a timestamp (Date + Time). Since you don't want or need the date information, when setting the data to store