473,326 Members | 2,133 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,326 software developers and data experts.

Activate Event question

I have a form with a few command buttons. These command buttons open forms.

In the OnActivate event of the main form I put in the line
msgbox "Activate"

When I press a button to open a form, close the opened form, I get the
message "Activate"...except for one. All of the called forms have the
syntax
Docmd.Openform "FormName"
with no arguments.

All opened forms are closed with
Docme.Close acForm, "CurrentFormName"

Is there any reason you can think of that the one form, when closed,
does not "activate" the main form? The only difference between it and
the other forms is that it is unbound and has 2 subforms in it. The
others are forms are unbound with a datasheet subform inside it.
Nov 13 '05 #1
3 3798
MLH
Experiment with the order in which the order in which you
close one and open another. Reverse that to open the other
then close the one. Observe what happens when you do that.

Take a moment to explain a tiny bit more. Take care to tell us
on which form a button you say you're clicking resides - stuff
like that - just to eliminate unnecessary ambiguity.

I read it to mean you have a main form, a current form and a
desired form. Current form is open because of a button click
you made on main form. Desired form is about to be opened
because of a button click you're about to make on current
form?
Nov 13 '05 #2
MLH wrote:
Experiment with the order in which the order in which you
close one and open another. Reverse that to open the other
then close the one. Observe what happens when you do that.


I "discovered" the reason. I thought I'd check out the Cycle property
of my forms and learned I had set the Popup/Modal property of the form
in question to Yes. I guess since it is a popup/modal, it is "part" of
the main form...almost like a subform doesn't "activate" since it's
parent is the main form.

Since there was no reason for it to be popup/modal, the problem is solved.
Nov 13 '05 #3
MLH
Glad U-found it. That kind-a-crap happens to me all the time.
Any full featured program, though providing MANY tools for
you to do unique and wonderful things is providing sneaky
hiding places where all kinds of things the you didn't necessarily
intend can hide.

I "discovered" the reason. I thought I'd check out the Cycle property
of my forms and learned I had set the Popup/Modal property of the form
in question to Yes. I guess since it is a popup/modal, it is "part" of
the main form...almost like a subform doesn't "activate" since it's
parent is the main form.

Since there was no reason for it to be popup/modal, the problem is solved.


Nov 13 '05 #4

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

Similar topics

2
by: Randy Harris | last post by:
I'm working with Access 2K and seem to be getting some behavior that contradicts the documentation. First, the help says: "Note The Activate event doesn't occur when a form receives focus back...
1
by: June Homer | last post by:
I have a form which has its activate event set to maximise the form. This used to work but no long does. I have put a breakpoint in the Activate event and it is never trapped. The form is opened...
9
by: MLH | last post by:
Say I open a form (MyForm) in design view, then I close it and dbl-click it in the database window to open it. Shouldn't the Activate event occur in all such situations? What might the case(s) be...
0
by: Brian Wilson | last post by:
According to the Access 2002 help file: "The Activate event can occur only when a form or report is visible" So why do I see two message boxes: "Activate" and "Visible=False"? ' In the...
3
by: active | last post by:
I remember when I checked NewGroups for comments about the VB6 Activate event and found that many thought it was not a reliable way to keep track of which form has focus. There was enough bad press...
2
by: Simon | last post by:
Dear reader, How to start the event "Activate" in a report as the report is a sub report. By opening the main report the event "Activate" in the sub report is not actived.. Thanks for any...
1
by: tomlebold | last post by:
When or should the form Activate event be used? I'm working on an existing application that excutes Me.Refresh on the form Activate (Form_Activate) event. This event causes the form to try to...
0
by: tomlebold | last post by:
When or should the form Activate event be used? I'm working on an existing application that excutes Me.Refresh on the form Activate (Form_Activate) event. This event causes the form to try to...
2
by: CGatto | last post by:
Hi, I have Windows Form with several User Controls embedded within. Only one user control is visible at any one time. The user moves through the various user controls by clicking Previous and...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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: 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...

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.