Code Examples

Create Web Pages

acCmdPublish

This example is based on an article by Mark Gillis of Microsoft called "Using Microsoft Access 97 to Share Static Data on the Web". This article seems to be no longer available on the Microsoft website.

It assumes that you have already set up some WebPage profiles in the Publish Wizard. The following code generates Web Pages based on the first profile.

'***************** Code Start *******************
SendKeys information
'Code by Terry Wickenden

Sub ReportToHtml()
  SendKeys " {DOWN}{DOWN}%F", False
  DoCmd.RunCommand acCmdPublish
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.