Form Flicker

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

snelson - 22 Mar 2007 03:47 GMT

I have a database with several forms being loaded from a Main Menu. I
created the command buttons using the tool box. When I open a form I
generally like to close the first one (don't know why) but there appears to
be a slight delay occuring between closing the main menu and opening the form.
(almost a flicker or stutter effect) If I don't close the main menu and open
a form it works ok BUT when I close the form and return to the Main Menu I
find myself with scroll bars and a different size menu (scroll bars are set
to neither).

At the end of the process I can live with it but would like to know if anyone
out there has some thoughts on this

Thanks in advance

Steve

Reply to this Message

JimaldoFratelli - 22 Mar 2007 22:36 GMT

Hi Steve

are you using macros or vba to open/close your forms?

i'm using the same approach to a database just now. i have a main menu with
four buttons linked to four forms. i'm using a macro attached to each button
to close the main menu (first) and then open the appropriate form (second).
each of the four forms displays a "menu" button, which in turn, has a macro
attached which closes all open forms (first), and then opens the main menu
(second)

sounds like the same idea, but there is definetly no flicker when i run my
app. which may (or may not) be down to the order you close/open your forms.

jimaldo

Reply to this Message

snelson - 26 Mar 2007 07:52 GMT

I am using the 'On Click' Event Procedure as follows

Private Sub frmdefendantopen_Click()
On Error GoTo Err_OpenDefendantForm_Click

Application.Echo True
DoCmd.OpenForm "frmDefendant"
DoCmd.Close A_FORM, "frmCommandCentre"
DoCmd.Maximize
Application.Echo True

Exit_OpenDefendantForm_Click:
Exit Sub

Err_OpenDefendantForm_Click:
MsgBox Err.Description
Resume Exit_OpenDefendantForm_Click

End Sub

I have modified the toolbox wizard setup to come up with the above, not sure
if it is right but have tried several different variants with fairly
different results, the above seems to be the best (of a bad bunch) so far.

Steve

>Hi Steve
>
[quoted text clipped - 11 lines]
>
>jimaldo

Reply to this Message

JimaldoFratelli - 28 Mar 2007 01:56 GMT

try switching the code to read:

DoCmd.Close A_FORM, "frmCommandCentre"
DoCmd.OpenForm "frmDefendant"

i'm sure doing it in this order will have the desired effect

jimaldo

> I am using the 'On Click' Event Procedure as follows
>
[quoted text clipped - 37 lines]
> >
> >jimaldo

Reply to this Message

snelson - 30 Mar 2007 10:43 GMT

Thanks for the clue, I tried it but it still didn't do what i wanted. It
appears to jump between the opening and closing of forms. Will keep
searching, thanks anyway

Steve

>try switching the code to read:
>
[quoted text clipped - 10 lines]
>> >
>> >jimaldo

Reply to this Message

JimaldoFratelli - 28 Mar 2007 00:56 GMT

Hi Steve

i just started reading "access 2000 programming weekend crash course" which
advises that in some cases writing macros is more efficient than writing VBA,
especially for opening and closing forms...so it could have been your
problems were down to using VBA rather than the order of opening/closing

jimaldo

Reply to this Message

snelson - 30 Mar 2007 10:45 GMT

I tried a basic macro that closes the menu and then opens the other form but
still the same jump between opening and closing, will play around with it a
little bit more to see if one is better than the other.

Thanks for the help

Steve

>Hi Steve
>
[quoted text clipped - 4 lines]
>
>jimaldo

Reply to this Message