"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message news:<40e38074$0$24741$5a62ac22@per-qv1-newsreader-01.iinet.net.au>...[color=blue]
> This is a known issue with Office XP SP3.
>
> Just add error handling to the routine to ignore error 3021.
> The delete works, and it sorts itself out after this event is over.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users -
http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Sebastian C." <sebastic@xnet.ro> wrote in message
> news:9959a732.0406301138.c6da24d@posting.google.co m...[color=green]
> > Hello everybody
> >
> > Since I upgraded my Office XP Professional to SP3 I got strange
> > behaviour.
> > Pieces of code which works for 3 years now are suddenly stop to work
> > properly.
> > I have Office XP Developer (SP3 for Office, SP1 for developer,
> > JET40SP8) on Windows XP Home Edition (SP1). The same behaviour occurs
> > on Windows 98 too.
> >
> > 1. The DoMenuItem don`t work anymore as it works until a couple a
> > weeks. When I try to delete a record using following code
> > (DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
> > DoCmd.DoMenuItem acFormBar, acEditMenu, 6, ,
> > acMenuVer70 )
> > I got the error message 3021 "No current record". This code works fine
> > in Access 97 and in Access 2000 ( I have them installed on the same
> > box with Access XP) but it stops working properly in Access XP.
> > 2 . Also when I`m trying to delete a record, error message 3709 "The
> > search key was not found in any record" appears.
> >
> > Does anyone know why this strange behaviour occurs and if there is a
> > solution to these problems?
> >
> > Thank you very much for your time!
> >
> > Sebastian C.[/color][/color]
Is the same issue with Office XP SP3 regarding the error:
"3709. The search key was not found in any record." also when I try to
delete a record?
Thank you very much!
Sebastian C.
