Help : Runtime error 3426 
Author Message
 Help : Runtime error 3426

I am a newbie at VB4. While using data control, and the commands
data1.recordset.addnew and data1.recordset.update, I ran into the above
runtime error 3426 : The command was cancelled by an associated object.
Other commands such as data1.recordset.move.... and ...find work fine. Can
anyone help ?



Mon, 27 Sep 1999 03:00:00 GMT  
 Help : Runtime error 3426

Are you putting the data from the control in a bound grid or some other
object and then changing the data?



Quote:
> I am a newbie at VB4. While using data control, and the commands
> data1.recordset.addnew and data1.recordset.update, I ran into the above
> runtime error 3426 : The command was cancelled by an associated object.
> Other commands such as data1.recordset.move.... and ...find work fine.
Can
> anyone help ?



Mon, 27 Sep 1999 03:00:00 GMT  
 Help : Runtime error 3426

3426 is a four-letter word.  It means that something has failed to pass
a validation of some sort and been rejected.  Sometimes it was right to
fail; sometimes the failure is itself in error.  It's so obscure that
it's hard to get specific help - all the causes seem to be particular to
an individual user.

I suggest you eliminate one data item after another until the problem
goes away (tedious but it works) and then examine verrrrry carefully the
bit which, when removed, makes the program work.  Sometimes you have to
do odd things - I fixed one of these by changing the field from fixed to
variable length!



Quote:

>I am a newbie at VB4. While using data control, and the commands
>data1.recordset.addnew and data1.recordset.update, I ran into the above
>runtime error 3426 : The command was cancelled by an associated object.
>Other commands such as data1.recordset.move.... and ...find work fine. Can
>anyone help ?


Manchester, England


Fri, 01 Oct 1999 03:00:00 GMT  
 Help : Runtime error 3426

Quote:


> I am a newbie at VB4. While using data control, and the commands
> data1.recordset.addnew and data1.recordset.update, I ran into the above
> runtime error 3426 : The command was cancelled by an associated object.
> Other commands such as data1.recordset.move.... and ...find work fine. Can
> anyone help ?

If you are trying to do an update in a validate event you will get
this.  In your validate event do this
Sub Data1_Validate
ValidateFlag=True
"Validate junk here
ValidateFlag=False
end sub

In your other subs change
Data1.Edit
Data1.whatever
data.update
change to
If ValidateFlag=False then
  Data1.edit
  data1.whatever
  data1.update
end if

This will make sure that you don't accidently call an update during a
validate event.



Sat, 02 Oct 1999 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Help - Runtime Error 3426

2. Help - Runtime Error 3426

3. runtime error 3426

4. Runtime error 3426 - This action was cancelled by an associated object

5. Runtime error 3426 (recordset problem?)

6. Runtime Error 3426

7. Runtime Error 3426??

8. VB4: runtime error 3426

9. RunTime Error 3426

10. Runtime error 3426

11. Runtime Error 3426??

12. VB5 Professional: Access database runtime error 3426

 

 
Powered by phpBB® Forum Software