Access screenupdating

Ed Disabling the screen in Access is the same as in Excel. Instead of using a macro, link your button to a subroutine and execute the queries from there.

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

Disabling the screen in Access is the same as in Excel. Instead of using a macro, link your button to a subroutine and execute the queries from there.

Hi all, I have a macro that executes ~200 queries which modify the data, create some tables etc.

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.

A form's Resize event as well as firing when a user resizes a form, also fires when a form is loaded.

The macro runs when the user clicks a button on a form.

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.