I run this code below. It gives me an error on trying to convert the date
characters to datetime.
snip ........
PayDate = rst3!Date
sQ = "select * from gl_trans_hdr where cast('" & PayDate & "' as
datetime)<= t_date and t_crln= " & "'" & BLoanNo & "'"
rs0.Open sQ, CurrentProject.Connection, adOpenStatic, adLockReadOnly
snip ........
While using Access2K it runs alright. But when I run on a machine with
runtime version it gives me the error.
What better function can I use to overcome this?
If you long to know the mind of God, You must learn to use your own
------------------------------------------------------------>>
A faith that's truly mature requires a mind that's well - informed.
___________________________________________________________
To help you stay safe and secure online, we've developed the all new Yahoo!
Security Centre. http://uk.security.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> 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/
