Mike,
See previous post, you can use
DateValue("06/26/2006") & " " & TimeValue("11:30AM")
or use them independently if you wish
Brett
At 13:25 01/07/06, you wrote:
>Gang -
>
>I'm generating date and time variables from scanned forms. Currently,
>the date and time values are as follows: 06/26/2006 and 11:30 AM. I've
>written VBA code to combine them into a single string. The resulting
>variable - datetime - is exported automatically to Access. When it
>get's there it looks like "06/26/2006 11:30 AM". Problem is, it is a
>string. If I set up the database before it is populated with records
>and set the datetime variable to date/time format, it throws an error -
>saying invalid data type. Clearly the ":" and perhaps the "AM" are
>text and the only way I can get the data into Access is as a string.
>That's no good. My question for the group is - what does the data have
>to look like so that Access sees it as a valid date/time format?
>
>Any help at all on this would be greatly appreciated.
>
>Regards,
>
>Mike
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>--
>Internal Virus Database is out-of-date.
>Checked by AVG Anti-Virus.
>Version: 7.1.394 / Virus Database: 268.8.4/364 - Release Date: 14/06/06
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.8.4/364 - Release Date: 14/06/06
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
