By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,632 Members | 1,499 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,632 IT Pros & Developers. It's quick & easy.

Date Tranfer from VB to Access

P: 12
I'm trying to transfer a date from VB6 to MS Access but keep getting "Runtime Error 424: Object Required" All the other data transfers fine, just the date gives me problems. As Access not reading the format
Nov 29 '06 #1
Share this Question
Share on Google+
4 Replies


sashi
Expert 100+
P: 1,754
I'm trying to transfer a date from VB6 to MS Access but keep getting "Runtime Error 424: Object Required" All the other data transfers fine, just the date gives me problems. As Access not reading the format
Hi there,

"Runtime Error 424: Object Required" is related to controls on your form, please check control names to make sure it's spelled correctly, hope it helps. Good luck & Take care.

p.s/ control :: textbox, label, command button..
Nov 29 '06 #2

P: 12
Hi there,

"Runtime Error 424: Object Required" is related to controls on your form, please check control names to make sure it's spelled correctly, hope it helps. Good luck & Take care.

p.s/ control :: textbox, label, command button..
That's what I thought, but when I commented out the date transfer the program worked fine
Nov 29 '06 #3

sashi
Expert 100+
P: 1,754
That's what I thought, but when I commented out the date transfer the program worked fine
Hi there,

Could you please post your code segment on your next post? Will be helpful to debug your code. Take care.
Nov 29 '06 #4

P: 12
Hi there,

Could you please post your code segment on your next post? Will be helpful to debug your code. Take care.
strTempDate = nodeClient.selectSingleNode"clnt_RecAddDate").node TypedValue
dteRecAddDate = CDate(Left(strTempDate, InStr(1, strTempDate, "T", vbTextCompare) - 1))
rs!clnt_RecAddDate = dteRecAddDate

It doesn't throw the error until it hits the update statement.
Nov 29 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.