Slow down code execution to improve form opening 2

[votegop]

I've been struggling with how to improve form opening & closing without screen flicker. For the most part, "repaint" & "echo" solutions don't help.

A solution that helps is 1) eliminating menubars; 2)making all forms over-sized popups with no scrollbars; 3) always keeping the switchboard form open, allowing the popups to cover it (when I exit, the switchboard appears with no flicker/resizing).

The only remaining problem is that the Form Open code executes so fast that the form becomes visible while it is opening (maximizing/resizing). Is there something I can add betweeen DoCmd.Maximize and DoCmdClose to slow it down, allowing the form to fully maximize before it becomes visible?

Private Sub per_Click()
DoCmd.OpenForm "Permitswtchbrd", , , , acHidden
DoCmd.Maximize
Forms!Permitswtchbrd.Visible = True
DoCmd.Close acForm, "Mainmenu", acSaveNo
End Sub

Thanks.
Jay

 

[genomon]

When using the find method in Jet 3.51, I have had to add a for....next loop to allow the function to "catch up":
For i = 1 to 100000
next i
Maybe not what you need, but what the heck?
Genomon

 

[votegop]

Thanks genomon.

 

[shannonp]

I'm not entirely sure what you mean?? When you open (maximise) a form it should almost be instantaneous...hence, you shouldn't really be able to 'see' any screen flicker as it does so.

I'm finding a little difficult to grasp what it is you need exactly, although, if all you want is a 'delay' of sorts then try this thread:

thread705-268517

 

[votegop]

Well, I don't know how to say it other than you definitely see a flicker, which appears to be the form maximizing. This is unlike when I exit forms, which is instantaneous.

Genomon's code didn't have an effect, and the code at your link didn't work. This may be me just being a perfectionist, but somebody has to have encountered this and has a solution.

 

[shannonp]

hmmmmm, this is just a stab in the dark, but have you got transition menu effects turned on?? (OS: Win2K and higher I think)

Go to your computers's Display Properties -> Effects Tab and try de-selecting transition effects.

 

[shannonp]

Hi - just a bit of a follow up...how'd you go with your problem? Got it working yet?

 

[votegop]

Thanks ShannonP1. No answer yet. I'm using WinME. I find the same effect when used on other systems as well. Am I to understand that my "open maximized flicker" is an anomoly unique to something I've done? I've seen other posts complaining of same, but no good solutions. You actually have maximized forms open instantaneously?

 

[shannonp]

Q. You actually have maximized forms open instantaneously?

A. Yep! definitely[/green]

I emulated what I thought could be flicker by turning on transitional effects to 'fade'. I went to a random access DB and maximised, minimised and restored various forms and I could see the forms change shape as you have stated. Then, I turned OFF (unchecked) transitional effects and again tried maximising, minimising and restoring my forms...and as certain as rain falls from the sky there was no flicker.

If what I have mentioned is definitely not the issue in your case...I too, would genuinely be interested in finding out who can solve this problem. So I will be keeping my eye on this thread.

Cheers

Did you actually try my idea?
---------------
When you open a menu, list box, or other screen element, in Win98, Win98SE or WinMe the object may open with a "animated" effect. This option may affect the speed of the response that you expect from your computer. To disable this option, use the following steps: Right-click on the desktop and choose Properties. Click on the Effects Tab. Clear the "Use transition effects for menus and tooltips" or "Animate windows, menus and lists" check box. Click OK.

 

[votegop]

Shannon, you typify all that is great about Tek-Tips! You were exactly right! Thanks for the specific instructions. I know this issue is plaguing other Access users, so it is worth either an FAQ or a "TIP".

Please do the following:
1) Take right hand, reach over left shoulder
2) Pat self on back

Thanks again!

Jay

 

[shannonp]

Cool Problem Solved!

You're more than welcome to send out a faq/tip to other users of this issue if you like, I just like trying to get to the bottom of the threads I read.

 

[jimlee]

Shannonp.....

Nice one, this has been bugging me for a while and I just came across this post by accident. Very helpful thanks.... have a nice big star!

jimlad

 

[shannonp]

Thanks jimlee, always appreciative of an extra star!


Shann