|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
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.
|
|
"Kathy" <Kathy[ at ]discussions.microsoft.com> wrote in message
news:A04CAF30-41DF-4453-B26D-FF29BA735029[ at ]microsoft.com...
[Quoted Text] >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.
|
|
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.
"Art MacNeil" wrote:
[Quoted Text] >
> "Kathy" <Kathy[ at ]discussions.microsoft.com> wrote in message
> news:A04CAF30-41DF-4453-B26D-FF29BA735029[ at ]microsoft.com...
> >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,
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.
--
Steve Schapel, Microsoft Access MVP
Kathy wrote:
[Quoted Text] > 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.
|
|
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" wrote:
[Quoted Text] > 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.
>
> --
> Steve Schapel, Microsoft Access MVP
>
> Kathy wrote:
> > 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.
>
|
|
Kathy, I will see any follow up messages that you post here.
--
Steve Schapel, Microsoft Access MVP
Kathy wrote:
[Quoted Text] > 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.
>
|
|
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?
"Steve Schapel" wrote:
[Quoted Text] > 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.
>
> --
> Steve Schapel, Microsoft Access MVP
>
> Kathy wrote:
> > 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.
>
|
|
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" wrote:
[Quoted Text] > 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.
>
> --
> Steve Schapel, Microsoft Access MVP
>
> Kathy wrote:
> > 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.
>
|
|
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.
--
Steve Schapel, Microsoft Access MVP
Kathy wrote:
[Quoted Text] > 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.
|
|
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" wrote:
[Quoted Text] > 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.
>
> --
> Steve Schapel, Microsoft Access MVP
>
> Kathy wrote:
> > 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.
>
|
|
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.
--
Steve Schapel, Microsoft Access MVP
Kathy wrote:
[Quoted Text] > 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!).
>
|
|
I'll try that. Thanks for all your time, Steve.
"Steve Schapel" wrote:
[Quoted Text] > 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.
>
> --
> Steve Schapel, Microsoft Access MVP
>
> Kathy wrote:
> > 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!).
> >
>
|
|
|