Run-Time error 3021

Posted by Mickie on June 16, 2009, 7:16 pm

Please log in for more thread options

Since Monday, I am getting an error in POS (I am running 1.3 RMS)

RUNTIME error 3021.
Either BOF or EOF, or the current record has been deleted. Requested
operation requires a current record.

This happens when I open POS, select NEW CUSTOMER, and then click OK.
Popup asks if I want to assign a new account number, I say OK.
ERROR message
POS shuts down.

The new customer record is actually made. So when I re-open POS to
continue the order entry, I just select that customer.

It is onl;y happening on my computer and not any of the others so a
database problem doesn't seem likely.

Just in case, I ran a database SHRINK and re-index.

CLUES?

Thanks,

Mickie

Posted by Jeff @ Check Point Software on June 19, 2009, 3:05 pm

Please log in for more thread options

: quoted-printable

http://tinyurl.com/kp67t5

--=20

Jeff=20
Check Point Software

Search this newsgroup -- http://tinyurl.com/2lmk4w   (Stolen from DRS)
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s).  If you are not using a reader, =
follow
the link below to setup Outlook Express.  Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

  Since Monday, I am getting an error in POS (I am running 1.3 RMS)

  RUNTIME error 3021.
  Either BOF or EOF, or the current record has been deleted. Requested=20
  operation requires a current record.

  This happens when I open POS, select NEW CUSTOMER, and then click OK.
  Popup asks if I want to assign a new account number, I say OK.
  ERROR message
  POS shuts down.

  The new customer record is actually made. So when I re-open POS to=20
  continue the order entry, I just select that customer.

  It is onl;y happening on my computer and not any of the others so a=20
  database problem doesn't seem likely.

  Just in case, I ran a database SHRINK and re-index.

  CLUES?

  Thanks,

  Mickie
------=_NextPart_000_00AD_01C9F0D6.3A084D60
Content-Type: text/html;
    charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18783"></HEAD>
<BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: =
15px"=20
id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 =
CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT color=3D#008000><A=20
title=3D"http://tinyurl.com/kp67t5
CTRL  + Click to follow link"=20
href=3D"http://tinyurl.com/kp67t5">http://tinyurl.com/kp67t5</A></FONT></=
DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV> </DIV>
<DIV>Search this newsgroup -- <A=20
href=3D"http://tinyurl.com/2lmk4w">http://tinyurl.com/2lmk4w</A>   (Stolen=20
from =
DRS)<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type of=20
newsgroup reader to<BR>see and download the file attachment(s).  If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express. =20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #008000 2px solid; PADDING-LEFT: 5px; =
PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
  <DIV>"Mickie" <<A=20
  =
lehollowoutdoorsREMOVE.com</A>>=20
  wrote in message <A=20
  =
@TK2MSFTNGP04.phx.gbl</A>...</DIV>Since=20
  Monday, I am getting an error in POS (I am running 1.3 =
RMS)<BR><BR>RUNTIME=20
  error 3021.<BR>Either BOF or EOF, or the current record has been =
deleted.=20
  Requested <BR>operation requires a current record.<BR><BR>This happens =
when I=20
  open POS, select NEW CUSTOMER, and then click OK.<BR>Popup asks if I =
want to=20
  assign a new account number, I say OK.<BR>ERROR message<BR>POS shuts=20
  down.<BR><BR>The new customer record is actually made. So when I =
re-open POS=20
  to <BR>continue the order entry, I just select that =
customer.<BR><BR>It is=20
  onl;y happening on my computer and not any of the others so a =
<BR>database=20
  problem doesn't seem likely.<BR><BR>Just in case, I ran a database =
SHRINK and=20
  =
re-index.<BR><BR>CLUES?<BR><BR>Thanks,<BR><BR>Mickie</BLOCKQUOTE></BODY><=
/HTML>

------=

Posted by Mickie on June 22, 2009, 12:33 pm

Please log in for more thread options

Thanks Jeff,

Worked like a charm.
As usual, you save the day again!
I wonder why I couldn't find this article. I guess I wasn;t using the
correct language.

Thanks!!

Mickie

Jeff @ Check Point Software wrote: