Screen updating hidden in vba
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.Regards, jon [font=Verdana][size=2]You should not have to do all that.
A new Excel Application instance is, by default, hidden. So, if setting its visible property to false hides it then there is some code somewhere that made it visible to begin with. I made it visible to keep the user entertained while the spreadsheet was formatting since it was only one sheet and it didn't take too long. Hi all, I have inherited a Access database that exports data to Excel. It shaved over 2 mins off a 10.30min report and I will be trying the same on some of the larger reports.It uses a combination of sql and VBA to produce the reports in Excel. I was very impressed when I came in this morning and saw all your responses.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.Don't forget error handling & turn the screen on before you try to msgbox an error or exit the sub.