Computer Forums

Member Login

Remember Me? Sign Up! | Forgot Password
 
Slogan
 
Closed Thread
Old 04-28-2004, 01:04 PM   #1 (permalink)
 
Newb Techie

Join Date: Mar 2004

Posts: 36

DKasler

Send a message via AIM to DKasler Send a message via Yahoo to DKasler
Default Runtime error '3426'



I get this error when I run this code... Any idea why, and what I can do about it?

Code:
Private Sub mnuFileSave_Click()
    Data1.Recordset.Update
    Frame1.Enabled = False
    Frame2.Enabled = False
End Sub
Runtime error '3426'

This action was cancelled by an associated object
Attached Images
 
DKasler is offline  
Old 04-28-2004, 02:37 PM   #2 (permalink)
 
Banned

Join Date: May 2003

Posts: 105

imported_Jack

Default

Not knowing that is going on in the rest of your program I woudl guess it would be becasue you are not on a valid record.

Do you test for bof and eof if your are changing existing data or call addnew if you are inserting new data.
imported_Jack is offline  
Old 04-28-2004, 04:01 PM   #3 (permalink)
 
Newb Techie

Join Date: Mar 2004

Posts: 36

DKasler

Send a message via AIM to DKasler Send a message via Yahoo to DKasler
Default

I found the problem and a work around...

Problem: It does not perform an implicit Edit method when the Data control moves to a new record.



Work Around:

If Data1.Recordset.EditMode = dbEditNone Then
Data1.Recordset.Edit
End If
Data1.Recordset.Update


DKasler is offline  
 
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On