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.DoMenuIt em acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuIte m 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.
3  4862 
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.goog le.com... 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.DoMenuIt em acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuIte m 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" <Al*********@Se eSig.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.goog le.com... 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.DoMenuIt em acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuIte m 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.
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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Paul Drummond |
last post by:
Hi all,
I am developing software for Linux Redhat9 and I have noticed some very
strange behaviour when throwing exceptions within a shared library.
All our exceptions are derived from std::exception. We have a base
class which all processes derive from which is always instantiated in
main surrounded by a try/catch(std::exception) which catches all
exceptions that have not be handled at a higher level. The catch block
cleans up and...
|
by: Mark Barinstein |
last post by:
Hello.
W2K, db2 v7, fp11.
Given:
create table pays (
acode integer not null,
packno smallint not null,
sum decimal(15, 2) not null
|
by: Steve Strik |
last post by:
My Problem:
I have created a database here at work that is exhibiting some very
strange behaviour.
Essentially the database is structured in a manner where one table is
a master record table (tbl_MainRegister) providing a unique identifier
for documents and a means for identifying the docuement type. There
are then 4 additional tables (tbl_Meetings, tbl_Documents,
tbl_Project, tbl_Correspondence) which store the document details.
|
by: john |
last post by:
Rich Text Box in Access form
Hello:
For example i have to tables in access: PERSON and ADDRESS in a one to
many relation.
And now i want to have a main PERSON form with a subform ADDRESS on
it.
No problem till now.
But if i place an ActiveX
Rich Text Box control (6.0 SP4) on a subform (even unbound) a strange
thing happen.
|
by: Paolo |
last post by:
Hi to all,
I have an error that drove me crazy. Try the following page that should only
allow to upload a file:
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
| | |
by: nome |
last post by:
Hello
Hoping someone can help explain the following behaviour.
I have an application that does a series of redirects before hitting
in a login page.
If I insert this application hyperlink to any MS office 2003 product,
say MS Access and click on it I get strange browser session behaviour
with both IE7 and Firefox 2.0.
|
by: Dox33 |
last post by:
I ran into a very strange behaviour of raw_input().
I hope somebody can tell me how to fix this.
(Or is this a problem in the python source?)
I will explain the problem by using 3 examples. (Sorry, long email)
The first two examples are behaving normal, the thirth is
strange.......
I wrote the following flabbergasting code:
#-------------------------------------------------------------
|
by: Pilcrow |
last post by:
This behavior seems very strange to me, but I imagine that someone will
be able to 'explain' it in terms of the famous C standard.
-------------------- code -----------------------------------
#include <stdio.h>
int main (void)
{
char xx="abcd";
char * p1 = xx;
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
