screen "jumps" when macro opens/closes forms

[Kathy]

I have macros on text boxes to navigate from one form to another. In those
macros, I Open one form and then close the forms from which I just came.
When these run, the screen jumps. It functions fine, but the "jumping
screen" (I'm assuming as it's opening one form and closing the other) is
really annoying. What haven't I done right? Thanks.

 

[Art MacNeil]

I have macros on text boxes to navigate from one form to another. In those
macros, I Open one form and then close the forms from which I just came.
When these run, the screen jumps. It functions fine, but the "jumping
screen" (I'm assuming as it's opening one form and closing the other) is
really annoying. What haven't I done right? Thanks.

I believe this will solve your problem.

At the start of the Macro enter this line:

Application.ScreenUpdating = False


At the end of the Macro add this line:

Application.ScreenUpdating = True


Art.

 

[Kathy]

Sorry for my ignorance, but I'm not sure where to put these line. I use the
Macro builder to do the macros, which is chart or grid, each row being a
different command. I have OpenForm on one row (and then on the bottom of
that screen I enter the Form Name to open). The next row I enter Close. At
the bottom of that screen I enter Form next to Object Type and then the form
name next to Object Name.

Is what you provided coding? I don't know how to do the coding.

 

[Steve Schapel]

Kathy,

Do I understand that the macro contains just two actions, OpenForm and
Close? There could be a number of explanations, including the sizes of
the forms, whether the Modal property of the forms is set to Yes, etc.
Also, if there are any macros or VBA procedures running on any other
pertinent event of either form, for example the Open or Load or Avtivate
or Current or Resize events of the form being opened, or the After
Update or Close or Unload events of the form being closed.

The first and simplest thing I would try is to reverse the order of the
actions in the macro - it should still work fine. If that doesn't help,
you could try this... Set the Window Mode argument of the OpenForm
action to Hidden, followed by the Close action, then do a SelectObject
action to display the form just opened.

 

[Kathy]

Steve, thank you. I've read through this, but not being an expert, it is
going to take me a little while to work through it (I do know I often put a
"Maximize" command in the macros, so I'm going to check that first). Anyway,
I'm posting this because I have to run out and probably won't get to this
until tomorrow and I'm hoping you might check back in after I've had time to
play with it. I will post again progress or lack thereof.

THanks for your help.

 

[Steve Schapel]

Kathy, I will see any follow up messages that you post here.

 

[Kathy]

I've tried these things:
- Modal property is set to No (always has been, I didn't change that)
- THere are no other procedure running, these are simple data entry forms
- I tried to have the macro close the first form before it opened the next
one - it still jumps
- I tried changing the OpenForm Window Mode to hidden and then doing the
SelectObject - it still jumps

I did figure one thing out (simply because I'd made a mistake on one of the
"navigation macros"). But I don't know how to use this information to fix
the problem. On one of the macros, I forgot to have it Close the form. It
only opened a new one. When I click that navigation button the screen
doesn't "jump" when moving from one to other. Once I added the Close command
to the macro, it did jump. Of course, I do want the forms to close. I don't
want open forms to be left all over the place as folks move around the
database.

Any other ideas?

 

[Kathy]

Sorry if this is a double post, but I got a message that the database was too
busy, so I don't think it saved last time.

I just figured out that it must have something to do with the size of the
forms. WHen I open a form that is not maximized in the macro, it opens
cleanly. Once I add the maximize command, it jumps. I have all the forms
set a little larger that will fit on the screen to account for computer
screens set to different resolutions.

Maybe we just have to deal with the jumping. As I said, it functions, it's
just annoying.

 

[Steve Schapel]

Kathy,

For what it's worth, I would always design a form so that it is small
enough to fit on a screen at the lowest resolutiuon it will ever be
used. And I never maximize forms. It sounds to me like the "jumping"
may be related to scroll bars being added or removed from the screen?
Anyway, I would recommend experimenting with varying the form design.

 

[Kathy]

Well, I reduced the forms so that they easily fit on the screen. There are
no scroll bars that show up. It sill blinks at me. Thanks for you help, but
it seems we'll just have to deal with it. So strange, because I've done
these macros before and never had this jumping. THere is nothing complicated
at all in there (wouldn't know how to do anything complicated!).

THanks for being so helpful.

 

[Steve Schapel]

Kathy,

Well, sorry we didn't resolve it yet. Perhaps it would be worth
re-posting your question in the .forms newsgroup, somebody there might
have some experience with this problem.

 

[Kathy]

I'll try that. Thanks for all your time, Steve.

Kathy,

Well, sorry we didn't resolve it yet. Perhaps it would be worth
re-posting your question in the .forms newsgroup, somebody there might
have some experience with this problem.