Code Examples

Refresh Views

acCmdViewViews

This code is an adaptation of some code that I saw on one of the newgroups. Unfortunately I do not know who posted the original code.

The code is designed to work in an ADP project to make Access aware of a new view tha thas been added to the SQL server.

'***************** Code Start *******************

Sub RefreshViews())

  Echo False
  DoCmd.SelectObject acTable, , True
  DoCmd.RunCommand acCmdViewViews 
  Application.RefreshDatabaseWindow 
  DoCmd.RunCommand acCmdWindowHide 
  Echo False

End Sub

'****************** Code End ********************

© 1998 - 2011 Terry Wickenden TKW Design Site developed maintained and hosted by TKW Design. This site is best viewed at 1024 x 768. Optimised for Firefox.