Unanswered: Re: how I can refresh database window?
I am trying to refresh database window through code with the following code:
Set cBars = Application.CommandBars
Set cBarCtl = cBars.FindControl(msoControlButton, 3812)
If Not cBarCtl Is Nothing Then
BUT I received this Error mess:
Method ‘Execute’ of object ‘_commandBarButton’ failed
ERROR occurred here --> cBarCtl.Execute
Does anyone know how I can fix this or another way to refresh database window? I tried using RefreshDatabaseWindow method it doesn't work ACC2K.
I created a table in code to temporary store the results from two queries and this 'temp' table is use as form's recordsource. But I need to delete this table when the form is being closed. Everything works just fine except I can't delete this table. I just can't find a way to refresh the database window so the table will be visible. I keep getting the error message it can't find the table.
In Acc97 the code is
That is exactly what I need but it won't work in Acc2K.
Is there something equivalent?
Doesn't anyone know if refreshing the link to the table will it refresh the database window & how I can write it?