Access XP strange behaviour

[Sebastian C.]

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.

[Allen Browne]

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." <se******@xnet.ro> wrote in message
news:99*************************@posting.google.co m...

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.

[Sebastian C.]

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<40***********************@per-qv1-newsreader-01.iinet.net.au>...

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." <se******@xnet.ro> wrote in message
news:99*************************@posting.google.co m...

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.

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.

[Allen Browne]

Haven't seen Err 3709 caused by SP3. That message may indicate a corruption
in the database.

You might also check if this knowledgebase article applies:

http://support.microsoft.com/default...roduct=acc2002

--
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.

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.