You can now choose when you want to update your formulas on the spreadsheet.

Applying this change will simply get Excel to stop updating existing formulas when you make a change to a cell value that is included as part of the formula’s calculation.

If, after applying the manual calculation setting, you create a new formula, that formula will still be executed.

Ed Sorry, looks like it's as simple as Application. Here is a clip from a good help page by Tony D'Ambra.

The url is Ed : Resize Form Controls You can use the Inside Height and Inside Width properties of an Access form to dynamically resize controls at run-time.

I would like the queries to be invisible while they are running, but currently the user sees 50 query windows open/close which is ugly.

Is there a way to automatically minimize/hide query windows or disable screen update?Action ............................................... Arg uments Set Warnings ................................... On = No Open Query................................... View = Datasheet; Data Mode = Edit Set Warnings .....................................One quick and easy technique to make your code run faster in Excel VBA is to simply prevent the screen from being redrawn each time something changes.Don't forget error handling & turn the screen on before you try to msgbox an error or exit the sub.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.I know this is possible in Excel by setting application.screenupdating =false, is there a similar way in Access?