Chat with nacked girl - Stop updating gthtdjl

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?

Queries will run in the background if the correct command syntax is used.

stop updating gthtdjl-49stop updating gthtdjl-41

I know this is possible in Excel by setting application.screenupdating =false, is there a similar way in Access?

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 macro runs when the user clicks a button on a form.

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

For example, this code will resize a sub-form within a resized form: [font=Verdana][size=2]You should not have to do all that.So, I prefer Open Query action rather than Run SQL action.Regards, jon [font=Verdana][size=2]You should not have to do all that.Everyone I have talked to has advised me to avoid using macros when possible.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.

Tags: , ,