By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,384 Members | 845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,384 IT Pros & Developers. It's quick & easy.

Access XP strange behaviour

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
"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.
Nov 13 '05 #3

P: n/a
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.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.