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
4 1449
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..
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
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.
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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.
|
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
...
|
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...
|
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...
|
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...
|
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...
|
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 **
|
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...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
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....
|
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...
| |