Screen flash

[Pete Beall]

I have a couple of lines:

DoCmd.Echo False

DoCmd.SelectObject acQuery, "q special mult", True

DoCmd.DeleteObject

DoCmd.Echo True

In spite of my Echo False, I still get a screen flash. Not a big deal, but
it is irritating. Anyone help?

 

[Dirk Goldgar]

I have a couple of lines:

DoCmd.Echo False

DoCmd.SelectObject acQuery, "q special mult", True

DoCmd.DeleteObject

DoCmd.Echo True

In spite of my Echo False, I still get a screen flash. Not a big
deal, but it is irritating. Anyone help?

Is there any special reason that you're selecting the object in the
database window -- essentially telling Access to make this object
visible and show it as selected -- just to delete it? Why not just
write

DoCmd.DeleteObject acQuery, "q special mult"

and have done with it, never needing to turn Echo off and on?

 

[Pete Beall]

Works fine. It’s just a question of knowing that the syntax exists.

Thanks