S
SpookiePower
I have a form that is connected to one table, and the data from
this table is displayed in textboxes on the form.
I then added this code -
http://msdn.microsoft.com/library/d.../en-us/vbaac11/html/acproDirty_HV05187175.asp
which can undo the changes I have made if I regret the changes.
All this works just perfect.
Then today I made another table and made a relation between the two
tables and added these new fields from the new table onto the form.
When I tested the Undo-button on my form, I get this error message -
Operation is not supported for this type of object. (Error 3251)
You were attempting to execute a method or assign a value to a property
that is usually valid for the object, but is not supported in this
specific instance. For example, the Edit method is generally valid for
Recordset objects, but not for a snapshot-type Recordset. This error
could also occur in cases where the operation is not permitted due to
the type or status of the object - as when trying to use the
MovePrevious method on a forward-only - type Recordset. Some
operations are also not supported, depending on if you are accessing a
Microsoft Jet or an ODBC data source.
I can't find the error, but I'm not sure that I understand the error
correct.
www.photo.activewebsite.dk
this table is displayed in textboxes on the form.
I then added this code -
http://msdn.microsoft.com/library/d.../en-us/vbaac11/html/acproDirty_HV05187175.asp
which can undo the changes I have made if I regret the changes.
All this works just perfect.
Then today I made another table and made a relation between the two
tables and added these new fields from the new table onto the form.
When I tested the Undo-button on my form, I get this error message -
Operation is not supported for this type of object. (Error 3251)
You were attempting to execute a method or assign a value to a property
that is usually valid for the object, but is not supported in this
specific instance. For example, the Edit method is generally valid for
Recordset objects, but not for a snapshot-type Recordset. This error
could also occur in cases where the operation is not permitted due to
the type or status of the object - as when trying to use the
MovePrevious method on a forward-only - type Recordset. Some
operations are also not supported, depending on if you are accessing a
Microsoft Jet or an ODBC data source.
I can't find the error, but I'm not sure that I understand the error
correct.
www.photo.activewebsite.dk