473,903 Members | 6,791 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

2 Access XP/2002 Issues

Hi everyone,

My company recently upgraded from Office 97 to Office XP. As those
who've read my other posts know I have a database with 3 nested
subforms

Main form-->First Subform-->Second Subform

First subform is a subform of Main Form, and Second Subform is a
subform of First Subform.

My first issue is with a message box coded in the GotFocus event of a
control on Second Subform. It should only pop up when I click in this
control. Since the upgrade it's been popping up much more often -
when I click in other forms, from one form to another, or in other
controls on the First or Second Subforms. Our tech support person
defragged my computer and reminded me to empty my recycle bin and
delete cookies. He thought it was a delay in running the code because
of high volume on the disk and memory. Since this was done it doesn't
pop up nearly as much, but it still does when it's not supposed to.
I've been able to re-create this in one case: I click in the control
and the box pops up, click ok to close it, then click Save Record
button, which is on the main form. If I click in the first control of
the First Subform, the message pops up again even though it's not even
in the same form! I don't know how this is possible, unless Access is
randomly running bits of code. This never happened in Access 97.
Does anyone know what this bug is and how to fix it?

My second issue is with the Export function. I had set up a parameter
query to pull accounting data and export it to Excel. The procedure
was to run the query and with it open in datasheet view, export it to
Excel to be sent to Accounting. When I went to do this in Access XP,
the Export function wasn't available with the query open, it was
dimmed. I was upset because I had set up my users with shortcuts to
these queries and they needed to be able to export from an open query.
I found the export function could be used with the query closed, and
it still prompted for parameters, so I could still do the export.

About 10 days later I was getting ready to change my user procedures
when I tried it again and found the export function is now available
with the query open. I've checked every day this week and it has been
available every day. My question is, does the availability of the
export function from an open query come and go randomly? I need to
know so I can tell my users what to expect.

Thanks very much, any help on these things is appreciated.

Julia :-)
Nov 12 '05 #1
7 1691
TC
It's really hard to see this happening.

Is this correct:

- The message in question only comes from a >single place< in the whole
database.

- That place is, the GotFocus event of a control on subform #2.

- The message sometimes appears when you click a control on subform #1.

- There is no code in subform #1 that displays that message.

- There is no code anywhere in subform #1 that calls an external procedure
or function (in any other form, subform or module) that could display that
message.

I know that subforms retain the concept of "current control", independent of
the main form &/or other subforms. So if you move the main form's focus to a
subform >control<, this possibly moves the >subform's< focus to the previous
"current control" of that subform. Perhaps that is something o do with it.

Post the code of your Enter event.

HTH,
TC


"Julia Baresch" <jb******@oldre public.com> wrote in message
news:50******** *************** ***@posting.goo gle.com...
Hi everyone,

My company recently upgraded from Office 97 to Office XP. As those
who've read my other posts know I have a database with 3 nested
subforms

Main form-->First Subform-->Second Subform

First subform is a subform of Main Form, and Second Subform is a
subform of First Subform.

My first issue is with a message box coded in the GotFocus event of a
control on Second Subform. It should only pop up when I click in this
control. Since the upgrade it's been popping up much more often -
when I click in other forms, from one form to another, or in other
controls on the First or Second Subforms. Our tech support person
defragged my computer and reminded me to empty my recycle bin and
delete cookies. He thought it was a delay in running the code because
of high volume on the disk and memory. Since this was done it doesn't
pop up nearly as much, but it still does when it's not supposed to.
I've been able to re-create this in one case: I click in the control
and the box pops up, click ok to close it, then click Save Record
button, which is on the main form. If I click in the first control of
the First Subform, the message pops up again even though it's not even
in the same form! I don't know how this is possible, unless Access is
randomly running bits of code. This never happened in Access 97.
Does anyone know what this bug is and how to fix it?

My second issue is with the Export function (snip)

Nov 12 '05 #2
"TC" <a@b.c.d> wrote in message news:<107060177 2.258086@teutho s>...
It's really hard to see this happening.
Yes, isn't it!
Is this correct:

- The message in question only comes from a >single place< in the whole
database.
Yes
- That place is, the GotFocus event of a control on subform #2.
Yes, that's correct.
- The message sometimes appears when you click a control on subform #1.
Yes, or other controls on subform #2.
- There is no code in subform #1 that displays that message.
Right
- There is no code anywhere in subform #1 that calls an external procedure
or function (in any other form, subform or module) that could display that
message.
Right

It doesn't start popping up until I've clicked in the field once.
Then it pops up as it's supposed to, but after I close it and move on
to other fields and forms, it keeps popping up.
I know that subforms retain the concept of "current control", independent of
the main form &/or other subforms. So if you move the main form's focus to a
subform >control<, this possibly moves the >subform's< focus to the previous
"current control" of that subform. Perhaps that is something o do with it.
I'm going to research event order to check that out.
Post the code of your Enter event.
Do you mean the GotFocus event? Here it is:
---------------------------------------------------
Private Sub LetterNumber_Go tFocus()

Dim LetterNumberMes sage As String
Dim Title As String
Dim MyReturn

MyReturn = Chr(10)

LetterNumberMes sage = "...Instruction s for entering accounting
code..."

Title = "Letter Number Field"

If MsgBox(LetterNu mberMessage, , Title) = vbOK Then

Exit Sub

End If

End Sub
------------------------------------------------------

Thanks very much!
Julia

Nov 12 '05 #3
TC
Ok, seems weird. Are you sure that this is actually your GotFocus event?
Private Sub LetterNumber_Go tFocus()
Dim LetterNumberMes sage As String
Dim Title As String
Dim MyReturn
MyReturn = Chr(10)
LetterNumberMes sage = "...Instruction s for entering accounting code..."
Title = "Letter Number Field"
If MsgBox(LetterNu mberMessage, , Title) = vbOK Then
Exit Sub
End If
End Sub
If so, you could simplify the code, like this. (MyReturn seems not to be
used, and the if-check has no apparent purpose.)
Private Sub LetterNumber_Go tFocus()
Dim LetterNumberMes sage As String
Dim Title As String
LetterNumberMes sage = "...Instruction s for entering accounting code..."
Title = "Letter Number Field"
MsgBox LetterNumberMes sage, , Title
End Sub
HTH,
TC
"Julia Baresch" <jb******@oldre public.com> wrote in message
news:50******** *************** ***@posting.goo gle.com... "TC" <a@b.c.d> wrote in message news:<107060177 2.258086@teutho s>...
It's really hard to see this happening.
Yes, isn't it!

Is this correct:

- The message in question only comes from a >single place< in the whole
database.

Yes
- That place is, the GotFocus event of a control on subform #2.


Yes, that's correct.

- The message sometimes appears when you click a control on subform #1.


Yes, or other controls on subform #2.

- There is no code in subform #1 that displays that message.

Right
- There is no code anywhere in subform #1 that calls an external procedure or function (in any other form, subform or module) that could display that message.


Right

It doesn't start popping up until I've clicked in the field once.
Then it pops up as it's supposed to, but after I close it and move on
to other fields and forms, it keeps popping up.

I know that subforms retain the concept of "current control", independent of the main form &/or other subforms. So if you move the main form's focus to a subform >control<, this possibly moves the >subform's< focus to the previous "current control" of that subform. Perhaps that is something o do with

it.
I'm going to research event order to check that out.

Post the code of your Enter event.

Do you mean the GotFocus event? Here it is:
---------------------------------------------------
Private Sub LetterNumber_Go tFocus()

Dim LetterNumberMes sage As String
Dim Title As String
Dim MyReturn

MyReturn = Chr(10)

LetterNumberMes sage = "...Instruction s for entering accounting
code..."

Title = "Letter Number Field"

If MsgBox(LetterNu mberMessage, , Title) = vbOK Then

Exit Sub

End If

End Sub
------------------------------------------------------

Thanks very much!
Julia

Nov 12 '05 #4
"TC" <a@b.c.d> wrote in message news:<107068869 4.399965@teutho s>...
Ok, seems weird. Are you sure that this is actually your GotFocus event?
Well, it says it is... But is also shows in the code under Form
Properties, which might explain part of the problem. The changes I
made today in the Control Properties code show in the form code. I
don't know why. Is there a way to change this?
Private Sub LetterNumber_Go tFocus()
Dim LetterNumberMes sage As String
Dim Title As String
Dim MyReturn
MyReturn = Chr(10)
LetterNumberMes sage = "...Instruction s for entering accounting code..."
Title = "Letter Number Field"
If MsgBox(LetterNu mberMessage, , Title) = vbOK Then
Exit Sub
End If
End Sub


If so, you could simplify the code, like this. (MyReturn seems not to be
used, and the if-check has no apparent purpose.)


MyReturn is used, there are 4 lines of instructions in the box. I
didn't include them for simplicity and confidentiality . When I was
coding this it took me a while to realize I had to assign the return
to a variable, that wasn't in the instructions.
Private Sub LetterNumber_Go tFocus()
Dim LetterNumberMes sage As String
Dim Title As String
LetterNumberMes sage = "...Instruction s for entering accounting code..."
Title = "Letter Number Field"
MsgBox LetterNumberMes sage, , Title
End Sub


When I coded this in Access 97 the only way I could get it to work was
by making it an if-check. I tried the change you suggest and it
works, but it still pops up when it's not supposed to like before.

Also last week I tried moving the code to the Enter event of the
control, but this just made it worse: in addition to the other times
it also popped up when I used Find in the Main Form to go to a record.
This morning I put it back in GotFocus.

Thanks very much for your help so far. Let's keep trying - I don't
want to give in to an upgrade unless I have to!

Cheers,
Julia
Nov 12 '05 #5
TC
Hi Julia. I'm not sure where to go from here. You say you don't want to
"give in to an upgrade", but I don't think an upgrade will solve your
problem. It is almost certainly a coding problem. But without seeing the
code, it's hard to find the error from a distance. Do you have access to a
more experienced Access programmer who could check it out "on site"?

HTH,
TC
"Julia Baresch" <jb******@oldre public.com> wrote in message
news:50******** *************** ***@posting.goo gle.com...
"TC" <a@b.c.d> wrote in message news:<107068869 4.399965@teutho s>...
Ok, seems weird. Are you sure that this is actually your GotFocus event?


Well, it says it is... But is also shows in the code under Form
Properties, which might explain part of the problem. The changes I
made today in the Control Properties code show in the form code. I
don't know why. Is there a way to change this?
Private Sub LetterNumber_Go tFocus()
Dim LetterNumberMes sage As String
Dim Title As String
Dim MyReturn
MyReturn = Chr(10)
LetterNumberMes sage = "...Instruction s for entering accounting code..." Title = "Letter Number Field"
If MsgBox(LetterNu mberMessage, , Title) = vbOK Then
Exit Sub
End If
End Sub


If so, you could simplify the code, like this. (MyReturn seems not to be
used, and the if-check has no apparent purpose.)


MyReturn is used, there are 4 lines of instructions in the box. I
didn't include them for simplicity and confidentiality . When I was
coding this it took me a while to realize I had to assign the return
to a variable, that wasn't in the instructions.
Private Sub LetterNumber_Go tFocus()
Dim LetterNumberMes sage As String
Dim Title As String
LetterNumberMes sage = "...Instruction s for entering accounting code..." Title = "Letter Number Field"
MsgBox LetterNumberMes sage, , Title
End Sub


When I coded this in Access 97 the only way I could get it to work was
by making it an if-check. I tried the change you suggest and it
works, but it still pops up when it's not supposed to like before.

Also last week I tried moving the code to the Enter event of the
control, but this just made it worse: in addition to the other times
it also popped up when I used Find in the Main Form to go to a record.
This morning I put it back in GotFocus.

Thanks very much for your help so far. Let's keep trying - I don't
want to give in to an upgrade unless I have to!

Cheers,
Julia

Nov 12 '05 #6
This all started with the upgrade to Office XP. It never happened
before in Access 97. Never! It's not the code that changed, it's the
version...... I guess I'll play around with the different events and
orders and see if I can make it work, but if not for the upgrade none
of this would be necessary. I might think of ways to work around it,
for example putting the instructions on a button instead, but I don't
want to change my program because of Microsoft's bugs. :p

Julia

"TC" <a@b.c.d> wrote in message news:<107093191 5.965708@teutho s>...
Hi Julia. I'm not sure where to go from here. You say you don't want to
"give in to an upgrade", but I don't think an upgrade will solve your
problem. It is almost certainly a coding problem. But without seeing the
code, it's hard to find the error from a distance. Do you have access to a
more experienced Access programmer who could check it out "on site"?

HTH,
TC

Nov 12 '05 #7
TC
It's probably not a Microsoft bug. It's probably a coding error that
previous versions of Access handled differently to current version(s).
Otherwise, hundreds of other databases would not be working now, & thousands
of other people would be complaining of the same problem!

Cheers,
TC
"Julia Baresch" <jb******@oldre public.com> wrote in message
news:50******** *************** ***@posting.goo gle.com...
This all started with the upgrade to Office XP. It never happened
before in Access 97. Never! It's not the code that changed, it's the
version...... I guess I'll play around with the different events and
orders and see if I can make it work, but if not for the upgrade none
of this would be necessary. I might think of ways to work around it,
for example putting the instructions on a button instead, but I don't
want to change my program because of Microsoft's bugs. :p

Julia

"TC" <a@b.c.d> wrote in message news:<107093191 5.965708@teutho s>...
Hi Julia. I'm not sure where to go from here. You say you don't want to
"give in to an upgrade", but I don't think an upgrade will solve your
problem. It is almost certainly a coding problem. But without seeing the
code, it's hard to find the error from a distance. Do you have access to a more experienced Access programmer who could check it out "on site"?

HTH,
TC

Nov 12 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

20
4663
by: John | last post by:
Hi, I've recently upgraded from Access 97 to Access 2002 & the performance basically stinks. I have tried the following items listed below but it has only had a minor impact: 1) Upgraded Jet 4 to Service Pack 7 2) Set Subdatasheet Name to from 3) Shortened the file name of the .MDB file 4) Made sure the Track name AutoCorrect info is off
0
1567
by: Colin Chudyk | last post by:
Hi, Here is my situation. Can anyone provide insight? I have developed a database in Access 2002. I am planning to distribute it as a split MDE (front) / MDB (back) to be used by the Access runtime and also full-version. Some of the client workstations will have Access 2002 installed. Most of them will have the runtime installed. However, I can't find the Office 2002 Developer Edition anywhere! Nobody has
3
2515
by: Colin Chudyk | last post by:
Hi, Here is my situation. Can anyone provide insight? I have developed a database in Access 2002. I am planning to distribute it as a split MDE (front) / MDB (back) to be used by the Access runtime and also full-version. Some of the client workstations will have Access 2002 installed. Most of them will have the runtime installed. However, I can't find the Office 2002 Developer Edition anywhere! Nobody has
0
1418
by: Miguelito Bain | last post by:
hi everybody- i've got a conundrum... i inherited some old databases, and i'm trying to convert them. i run office xp with access 2002, and all of the databases i manage are either in 97 format or 2000 format. i have a list box that works in access 97 but not 2000. here's my situation...
9
2890
by: Rob | last post by:
Scenario: O/S: Win XP Professional Back-end: Access 2002 on network server I have an Access 97 application, in production on our network, that takes appoximately 5 minutes to process monthly data. I find this tolerable. The Access 2002 test version, on the network, takes approximately 50
8
1697
by: pw | last post by:
Hi, I'd like to have each client record have a picture of themselves. Any ideas on what the best way to do this in my Access 97 application? Thanks, -pw
3
1652
by: Richard Cleaveland | last post by:
A client has just successfully upgraded from Access 97 to 2000. I don't have Access 2000, but I do have Office XP. Can I successfully use my Access on their database? They kind of did this behind my back, and I'm responsible for the application maintenance...! Dick
4
1950
by: brooks | last post by:
I have an Access 97 app and the ADT and am considering selling it to the public. Is this viable? What issues might I have? I also have Access 2000 and could use that if it would be better. I don't have the "ADT" for 2000. Is it called ODE or ODT? Can you still buy that? Would there be any advantage in moving up to and distributing using
52
10031
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server 2005, and, since he already has licenses for Office Pro 2002, he wants to upgrade to that. I've been saying that we need to upgrade to Access 2003, not 2002, even if Office is kept at 2002. We are also looking to do a fair amount of...
1
2198
by: kihsore | last post by:
Hi All, I have a question on compatibility and conversion issues with Access 2007. My question is will a Runtime created on an early versions of Access 2007 (ie;Access 97,2000,2002,2003) run on a system with Access 2007 and any compatibility or conversion issues with Access 2007.... Please,let me know if any one could find me an answer... Please help me in this issue
0
9848
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,...
0
11284
Oralloy
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...
0
10501
tracyyun
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...
0
9687
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8049
isladogs
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...
0
5894
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...
0
6094
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4727
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
3
3324
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.