Everytime I learn something new it pushes some old stuff out of my brain! Help! Advanced Search VBForums Visual Basic Visual Basic 6 and Earlier [RESOLVED]Data control Runtime Error 3426 If this is your first visit, be sure to check out the FAQ by clicking the All rights reserved.
Any thoughts? 0 LVL 14 Overall: Level 14 Visual Basic Classic 12 Message Assisted Solution by:Matti2007-12-24 Hi! Then i just change the combobox's .text property on form load to equal the recordsets first item and it looks like it is exactly the same as before (except it works) but somehow Acc then recognite this like an emptyString or something like that so I can't save the record. If you want to get involved, click one of these buttons!
When i run the program it give a 'Run time error 3426 - the action was canceled by an associated object'. Find all posts by Chris J Locke #5 04-02-2003, 11:45 PM peter67 Centurion Join Date: Jan 2003 Location: Slovenia, Ljubljana Posts: 116 You wrote: ... I think I got what you mean (I'm on day 4 with databases) and you want me to write Data1.RecordSet.UpdateData1.RecordSet.AddNewWhen I write that I get an error saying I need to
HowTo: Execute an ad hoc query using ADO and display the results in a grid. As to how to unset it, that depends on how your program is structured. How hard could it possibly be to shove the first record on a database?: : ----: : : : : : Hi!: : It's seems impossible, not hard, right?: : You Here is an easy way in VB6 using ADO to remove duplicate row… Visual Basic Classic Using the VB6 Debugger Article by: Martin The debugging module of the VB 6 IDE
Forgotten your password? Join Date Mar 2004 Location on the poop deck Posts 5,592 Re: Data control Runtime Error 3426 or: VB Code: Data1.Recordset.FindFirst CStr("ItemNumber = '" & Item & "'") Also double check Help if you can... Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More...
Join Now For immediate help use Live now! Thanks for posting! In addition, we can call the functions that are part of the Windows operating system. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature.
So,Data1.RecordSet.UpdateData1.RecordSet.AddNewThis won't work:Data1.RecordSet.UpdateData1.RecordSet.AddNewbecause you have to update after you add. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old. - Increase transparency - Onboard new hires faster - Access from mobile/offline Try I guess, for Access 2003, you need to use ADO's datacontrol.. Join for free You are Here: Home > Forums >< Entertainment >< Technology and computers >< Webmaster, coding and software dev Vb 6 Problem, adding a record to database - error
My help file is missing for this error so im not sure where the coding has gone wrong. Reply With Quote May 30th, 2006,01:12 AM #7 bushmobile View Profile View Forum Posts Oi, fat-rag! Despite body and mind, my youth will never die! And of course thanks for tips up to now.
Connect with top rated Experts 16 Experts available now in Live! Ive sorted the problem now, i was using the .MoveLast before i used the .AddNew and it was causing an error when i added the first record as there was no Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free!
Enable ActiveX object in your components and ActiveX Objects Library 2.8( i think) in your references Use this code: VB6 coding for an OLEDB connection to a Microsoft access database using We can point you to examples if you like. HowTo: Use ADO to insert records into a database. Red Flag This Post Please let us know here why this post is inappropriate.
I don't know why. My help file is missing for this error so im not sure where the coding has gone wrong. Are you aComputer / IT professional?Join Tek-Tips Forums! Rob Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...
Why don't you try to update the recordset before searching for a new one? 0 Message Active 3 days ago Author Closing Comment by:ttobin3332007-12-24 Thanks for your input, gentlemen! Then you just delete that vale in certain field and it if OK. Even if one of them were true skipping the update procedure would be unacceptable anyway. First 50 to have their say get a £5 Amazon voucher! 30-10-2016 Start new discussion Reply Hanax Follow 0 followers 0 badges Thread Starter Offline 0 ReputationRep: Follow 1 16-04-2006
RESOLUTIONCheck the underlying recordset to see if either the BOF or EOF properties are True before allowing an implicit save to occur.