473,322 Members | 1,401 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Date Tranfer from VB to Access

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
4 1449
sashi
1,754 Expert 1GB
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
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
1,754 Expert 1GB
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
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

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

Similar topics

3
by: JC Mugs | last post by:
2- Tables Customer & Invoice Customer has typical ID,Name, street, etc Invoice is special type has about 29 fields and needs to import the id, name, street, etc to this table. Save the total...
11
by: Miikka Hamalainen | last post by:
Hi All, I'm making library db using SQL. I have date when book has been loaned (Date loaned) and date to return the book (Return date), which is 4 weeks. How can I get current date to show...
4
by: Gopal Prabhakaran | last post by:
Dear All, In one solution , I have 2 webapplication, now i want transfer one control form webapplication 1 to webapplication 2. Pls help ASAP Millions of Thanx in advance.
2
by: Bremanand | last post by:
hi... am doing project in vb 6.0 with ms-access... in this i need to tranfer my system date from my dtp to database, for this,i used dtpname.value=now ...
3
by: Jim in Arizona | last post by:
I have a gridview that's being populated from an access db query. The problem I'm having is that the date/time fields in access that are populating the gridview are showing both date and time, when...
2
by: hardik | last post by:
hi friends, i am really surprized the way access behaves in date fields i mean it's all ok when you have us time zone or us servers but if you have diffrent timezone like uk then access creates...
1
by: Jimmy | last post by:
I'm trying to run a query that will show only records where the year in a date field equals the current year: SELECT tblSideJob.SideJobID, tblSideJob.Date FROM tblSideJob WHERE...
3
by: shahla.saeed | last post by:
hi, plzz check my code and let me know where the problem is lying...becuase whenever i try to tansfer the file of 573KB(mp3) it just tranfer few Kb of file(Somtimes 5.2Kb,somtimes 32Kb..every time...
2
by: Dale Harris | last post by:
Hi, I was wondering, is there a difference between Server.Transfer and Response.Redirect? They seem to do the same thing. Or am I mistaken? TIA ** Posted from http://www.teranews.com **
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.