MsAccess showing #deleted# when bound to table that is deleted and reloaded

Have a listbox bound to a "work" table this is refreshed with a delete query and then an append query.

Because it takes a long time I am seeing the listbox rows show #deleted# for a second or two before the new values come up.

Is there a way to suppress this?

Was thinking to first to the delete query and then requery the listbox so it shows empty.  Then to do the append query and requery the listbox again.

Or else would it make sense to do nothing until the table is rebuild and then reset the listbox recordsource?
hertzgordmanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

hertzgordmanAuthor Commented:
Right now I testing

Application.Echo False

...Doing rebuilds and requery

Application.Echo True
Me.Repaint

Seems to work...
0
hnasrCommented:
What you are testing is a suggested approach. It is neat and does not distract user.
http://msdn.microsoft.com/en-us/library/office/ff834500(v=office.15).aspx

Above link show this example in VBA:
 
Public Sub EchoOff() 
 
 ' Open the Employees form minimized. 
 Application.Echo False 
 DoCmd.Hourglass True 
 DoCmd.OpenForm "Employees", acNormal 
 DoCmd.Minimize 
 Application.Echo True 
 DoCmd.Hourglass False 
 
End Sub

Open in new window

0
Gustav BrockCIOCommented:
Using Application.Echo is brute force.

Before the update, do:

  Me.Painting = False

When finished:

  Me.Painting = True

/gustav
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

hertzgordmanAuthor Commented:
Thanks to all will see what works best.  I like the idea of avoiding brute force...
0
hnasrCommented:
Two issues with painting compared to echo you need to observe.

1 you need to set painting off for any sub form on the form.
2 painting is set to true automatically when form looses or gains focus.
0
hertzgordmanAuthor Commented:
thanks hnasr good to know will factor that into the changes
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.