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
<*> 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/
