Disable Screen Updates in Access VBA (1 Viewer)

[Poppy]

Hi Experts

Is it possible to disable screen updates in Access modules like you would in Excel VBA?

Thanx for all the help

Kind Regards

 

[Mile-O]

Look up the Echo method.

 

[modest]

I've never done this, but if you can do it in Excel, you can more than likely do it in Access. VBA uses same core models/code. And since you can reference specific libraries, you should be able to call on the same objects and/or event procedures.

 

[Poppy]

Echo

Hi Guys

I first tried this from excel:

 application.ScreenUpdating = False

That did not work, then I tried searching on the web, but got no answers.

I have tried the echo method and it does not seem to work. In code this is what I tried:

'Screen.MousePointer = 11
 ' DoCmd.Echo False

Call Button5_Click

'DoCmd.Echo True
 ' Screen.MousePointer = 0

Then I tried doing it in a macro to no avail either. What do I do gentlemen, what do I do?

Kind Regards.

 

[modest]

Generally you turn it off in excel to get rid of the screen flickering from running a Macro... what's ur purpose of using it here in access?

 

[Poppy]

I'm running a macro that has to open and run code from a module, then open a table after it's done. The problem is that the user can see the code module a few seconds before the table is opened. This I think would give the user a bit of a fright.

Thanx

Kind Regards

 

[modest]

Hmm.. that's interesting, I do this all the time and never get the code window.

If you woudln't mind... post your macro events and what's being called.


Also, instead of docmd.echo, try application.echo

 

[ghudson]

Dump the macro, convert it to VBA.

You have a design problem if your function is opening a module and also opening a table. The user should never have access to the db window or any of the db objects. They should be navigating and accessing the data through forms.

Be very carefull with the Echo method. If you do not turn if back on your users will have all kinds of problems with your db. Put the DoCmd.Echo True in that sub or functions error handler to ensure that Echo is turned back on just incase there is a runtime error within that sub or function.

This allows you to display a status bar message.
DoCmd.Echo False, "Visual Basic code is executing."

This does the same as above except no message text.
Application.Echo False

 

[modest]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/acmthEcho_HV05186348.asp

Microsoft recommends application.echo false

and ALWAYS remember to turn it back on

 

[Poppy]

Thanx for all the help.


Kind Regards