Screen updating ms access

[/size][/font] Try the following steps and let me know what happens: If it does not do the trick in a macro setting, I will show you how to accomplish it with just a few lines of VBA code. Before running your macro, make sure that the checkbox for confirming action queries is unchecked. Modify your macro to sandwich the Open Query action between the Set Warnings On = No and Set Warnings On = Yes actions as shown.Action ............................................... Arg uments Set Warnings ................................... On = No Open Query................................... View = Datasheet; Data Mode = Edit Set Warnings .....................................In Excel I can "freeze" the appearance of the window while a macro runs in the background updating various cells in a spreadsheet and then "unfreeze" the screen to reveal all of the changes.Do this eliminates screen flicker and other various unattractive visual actions while a macro is running. I have a couple of subforms that require my using Me.

This causes the screen to "flash" as one is closed, the main menu becomes visible very briefly and then the new form opens.The user should never have access to the db window or any of the db objects. Echo False, "Visual Basic code is executing." This does the same as above except no message text. They should be navigating and accessing the data through forms. If you do not turn if back on your users will have all kinds of problems with your db. 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. There may also be a way to execute a macro from VBA using the Do Cmd method, but I'm not familiar with doing that.Everyone I have talked to has advised me to avoid using macros when possible.

Leave a Reply