Update Or CancelUpdate without AddNew or Edit error

[gmazza via AccessMonster.com]

Hi there,
I keep getting this error after I update a record, then try moving to another
record.
When I debug, it comes up with me setting my modifier date field on the form
to a value in the forms BeforeUpdate event. Is there somewhere else I can set
this date to prevent this error?
Thanks!

 

[Arvin Meyer MVP]

Try the afterupdate event.

 

[gmazza via AccessMonster.com]

Now I get this error when I put it there:
You cancelled the previous operation.
However the error is in my combo box after update with this code in it:
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[MovieID] = " & str(Nz(Me![cboSelectMovie], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark

The error was on the last line.

Try the afterupdate event.

Hi there,
I keep getting this error after I update a record, then try moving to

[quoted text clipped - 6 lines]

this date to prevent this error?
Thanks!

 

[Arvin Meyer MVP]

That is wizard generated code, and has been running correctly on many
millions of machines.

There are several other possibilities, the first of which is a missing
reference. Open any code window and go to Tools >>> References and fix any
marked "MISSING".

You could also have a corrupt database. Try the following:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Now I get this error when I put it there:
You cancelled the previous operation.
However the error is in my combo box after update with this code in it:
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[MovieID] = " & str(Nz(Me![cboSelectMovie], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark

The error was on the last line.

Try the afterupdate event.

Hi there,
I keep getting this error after I update a record, then try moving to

[quoted text clipped - 6 lines]

this date to prevent this error?
Thanks!

 

[gmazza via AccessMonster.com]

I went through setting up a new database and setting up just this form in it
and it still does the same thing.

That is wizard generated code, and has been running correctly on many
millions of machines.

There are several other possibilities, the first of which is a missing
reference. Open any code window and go to Tools >>> References and fix any
marked "MISSING".

You could also have a corrupt database. Try the following:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

Now I get this error when I put it there:
You cancelled the previous operation.

[quoted text clipped - 12 lines]

 

[Arvin Meyer MVP]

Did you build a new form in the new database, or import it?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I went through setting up a new database and setting up just this form in
it
and it still does the same thing.

That is wizard generated code, and has been running correctly on many
millions of machines.

There are several other possibilities, the first of which is a missing
reference. Open any code window and go to Tools >>> References and fix any
marked "MISSING".

You could also have a corrupt database. Try the following:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and
recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of
saving
corrupt databases. Try this URL:

http://www.pksolutions.com

Now I get this error when I put it there:
You cancelled the previous operation.

[quoted text clipped - 12 lines]

this date to prevent this error?
Thanks!

 

[gmazza via AccessMonster.com]

I built in a new db as I have learned importing does not help when the db is
corrupt.

Did you build a new form in the new database, or import it?

I went through setting up a new database and setting up just this form in
it

[quoted text clipped - 47 lines]

 

[Arvin Meyer MVP]

Then you really need to go through the corruption procedures that I outlined
earlier.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I built in a new db as I have learned importing does not help when the db
is
corrupt.

Did you build a new form in the new database, or import it?

I went through setting up a new database and setting up just this form in
it

[quoted text clipped - 47 lines]

this date to prevent this error?
Thanks!