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.
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: Adult Dating, affair dating, sex dating