473,323 Members | 1,574 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Closeing form problem

I have an A97 MDB that I converted to A2003 yesterday. My MainMenu
calls ARInfoForm. I hit the Exit button in ARInfoForm and it closes and
displays/activates the MainMenu just fine.

The ARInfoForm has a complicated recordsource that makes reference to a
couple of checkboxes on the ARInfoForm. Like
Forms!ARInfoForm!CheckBox = True

In A2003, when I open the form ARInfoForm and close it via the Exit
button it appears to close, displays/activates the MainMenu and then it
pops up behind the MainMenu and I am prompted to enter the value for the
parameter
Forms!ARInfoForm!CheckBox

Do you have any idea why it appears to execute a call to the
recordsource of ARInfoForm when it closes...like it's doing a requery on
a closed form? My Exit button is simply
Docmd.Close acForm, Me.Name

There's no Unload event and in the OnClose event I simply check to see
if another form open and if so close it. There's no Before/After update
event for ARInfoForm.

Jul 31 '08 #1
4 1374
Hi,

Salad wrote:
I have an A97 MDB that I converted to A2003 yesterday. My MainMenu
calls ARInfoForm. I hit the Exit button in ARInfoForm and it closes
and displays/activates the MainMenu just fine.

The ARInfoForm has a complicated recordsource that makes reference to
a couple of checkboxes on the ARInfoForm. Like
Forms!ARInfoForm!CheckBox = True

In A2003, when I open the form ARInfoForm and close it via the Exit
button it appears to close, displays/activates the MainMenu and then
it pops up behind the MainMenu and I am prompted to enter the value
for the parameter
Forms!ARInfoForm!CheckBox

Do you have any idea why it appears to execute a call to the
recordsource of ARInfoForm when it closes...like it's doing a requery
on a closed form? My Exit button is simply
Docmd.Close acForm, Me.Name

There's no Unload event and in the OnClose event I simply check to see
if another form open and if so close it. There's no Before/After
update event for ARInfoForm.
Sounds like the behavior described here :

http://support.microsoft.com/kb/811860/en-us

Regards
Jens

Jul 31 '08 #2
Jens Schilling wrote:
Hi,

Salad wrote:
>>I have an A97 MDB that I converted to A2003 yesterday. My MainMenu
calls ARInfoForm. I hit the Exit button in ARInfoForm and it closes
and displays/activates the MainMenu just fine.

The ARInfoForm has a complicated recordsource that makes reference to
a couple of checkboxes on the ARInfoForm. Like
Forms!ARInfoForm!CheckBox = True

In A2003, when I open the form ARInfoForm and close it via the Exit
button it appears to close, displays/activates the MainMenu and then
it pops up behind the MainMenu and I am prompted to enter the value
for the parameter
Forms!ARInfoForm!CheckBox

Do you have any idea why it appears to execute a call to the
recordsource of ARInfoForm when it closes...like it's doing a requery
on a closed form? My Exit button is simply
Docmd.Close acForm, Me.Name

There's no Unload event and in the OnClose event I simply check to see
if another form open and if so close it. There's no Before/After
update event for ARInfoForm.


Sounds like the behavior described here :

http://support.microsoft.com/kb/811860/en-us

Regards
Jens
Thanks Jens. I was excited thinking I had a solution.

It's worked forever with A97. I called up someone, after reading your
solution, who has WinXP and the app in A2003 and it closes without a
parameter value and no mods to the app.

The person's computer I am testing this on uses Win2000. The KB article
mentioned the bug as a problem with WinXP. So I tested it on his
machine. If I use the Docmd.Echo solution I still get the parameter
box. If I remove the Docmd.Echo and then use the X button to close, it
freezes up on me...I see a couple of flashes and movements in the form
(I guess the main menu form attempting selection then it dies).

I've thus determined A97 works fine no matter what the OS (Win2000/XP),
works fine on WinXP/A2003, and fails on Win2000/A2003. Argggg!


Jul 31 '08 #3
Hi,

Salad wrote:
Jens Schilling wrote:
>Salad wrote:
>>I have an A97 MDB that I converted to A2003 yesterday. My MainMenu
calls ARInfoForm. I hit the Exit button in ARInfoForm and it closes
and displays/activates the MainMenu just fine.

The ARInfoForm has a complicated recordsource that makes reference
to a couple of checkboxes on the ARInfoForm. Like
Forms!ARInfoForm!CheckBox = True

In A2003, when I open the form ARInfoForm and close it via the Exit
button it appears to close, displays/activates the MainMenu and then
it pops up behind the MainMenu and I am prompted to enter the value
for the parameter
Forms!ARInfoForm!CheckBox

Do you have any idea why it appears to execute a call to the
recordsource of ARInfoForm when it closes...like it's doing a
requery on a closed form? My Exit button is simply
Docmd.Close acForm, Me.Name

There's no Unload event and in the OnClose event I simply check to
see if another form open and if so close it. There's no
Before/After update event for ARInfoForm.


Sounds like the behavior described here :

http://support.microsoft.com/kb/811860/en-us

Regards
Jens

Thanks Jens. I was excited thinking I had a solution.

It's worked forever with A97. I called up someone, after reading your
solution, who has WinXP and the app in A2003 and it closes without a
parameter value and no mods to the app.

The person's computer I am testing this on uses Win2000. The KB
article mentioned the bug as a problem with WinXP. So I tested it on
his machine. If I use the Docmd.Echo solution I still get the
parameter box. If I remove the Docmd.Echo and then use the X button
to close, it freezes up on me...I see a couple of flashes and
movements in the form (I guess the main menu form attempting
selection then it dies).
I've thus determined A97 works fine no matter what the OS
(Win2000/XP), works fine on WinXP/A2003, and fails on Win2000/A2003.
Argggg!
I'm not right sure, but I guess to remember a situation where I had to
delete further parameters from the docmd-command.
Did you give a try just with Docmd.Close ( as in the KB )?

But I've never had to handle the combination of W2000/A03, so there's no
idea left....

Regards
Jens


Jul 31 '08 #4
You have put a break point at Docmd.Close acForm, Me.Name and then
stepped through the following code with <F8>?
On Jul 31, 8:29*am, Salad <o...@vinegar.comwrote:
I have an A97 MDB that I converted to A2003 yesterday. *My MainMenu
calls ARInfoForm. *I hit the Exit button in ARInfoForm and it closes and
displays/activates the MainMenu just fine.

The ARInfoForm has a complicated recordsource that makes reference to a
couple of checkboxes on the ARInfoForm. *Like
* * * * Forms!ARInfoForm!CheckBox = True

In A2003, when I open the form ARInfoForm and close it via the Exit
button it appears to close, displays/activates the MainMenu and then it
pops up behind the MainMenu and I am prompted to enter the value for the
parameter
* * * * Forms!ARInfoForm!CheckBox

Do you have any idea why it appears to execute a call to the
recordsource of ARInfoForm when it closes...like it's doing a requery on
a closed form? *My Exit button is simply
* * * * Docmd.Close acForm, Me.Name

There's no Unload event and in the OnClose event I simply check to see
if another form open and if so close it. *There's no Before/After update
event for ARInfoForm.
Jul 31 '08 #5

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

Similar topics

1
by: waisty vb.net rookie | last post by:
How do i prevent my program from being closed with Alt + F4 in vb.net -- Thanks for reading
5
by: Richard | last post by:
Hi, I have a form that take some time to load due to many comboboxes and at least 8 subforms. When I filter or sort the main form I get an error message and then Access shuts down. They ask if...
15
by: Steve | last post by:
I have a form with about 25 fields. In the BeforeUpdate event of the form, I have code that sets the default value of each field to its current value. For a new record, I can put the focus in any...
5
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...
1
by: Nico | last post by:
Hi! I use Windows XP and Access 2002 (XP) SP2 (not SP3) My company has not upgraded to SP3. My problem: -I have a form "F_BOMs" -in this form, i have a sub form called "SF_BOMs" -the sub-form...
2
by: Brian Henry | last post by:
Hi, this task sounds like it should be easy but what I tried didn't work. My app has a logoff button, and when a user clicks it i need to close all the child mdi windows in a mdi container... i...
1
by: nomaam | last post by:
i am useing VB.NET, and am working in a windows form. my form interacts with Internet Explorer, and i would like only the main IE window to be open. i know how to terminate a process, but how...
5
by: ortaias | last post by:
I have a form which calls up a second form for purposes of data entry. When closing the data entry form and returning to the main form, things don't work as expected. When I return to the main...
1
by: fugaki | last post by:
Hi everyone I'm learning asp, and i downloaded this script to teach me how to post form data from a webpage to an access database. I put it on the server so i could make sure that it worked, and...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.