VBScript & Access procedures

[mhjb]

Hi there

On a page on my client's intranet i've made a button called MSAccess, and an onclick procedure for it:

[green]

Sub MSAccess_onclick()

   Set acApp = CreateObject("Access.Application")

   With acApp
      .OpenCurrentDatabase "f:\Database.mdb"
      .Visible = TRUE
      .Run("webGotoItem(""ItemOne"")")
   End With

End Sub

[/green]

That opens the database correctly, but then Internet Explorer gives me an error message:

[red]Error: Microsoft Access can't find the procedure 'webGotoItem("ItemOne&quot.'[/red]

webGotoItem is a Public function in a module called Miscellaneous in the database.

If you've got any ideas on how to make this work i'd be very grateful.

 

[DJS2]

Why not create an autoexec macro to run webGotoItem() when the database is opened

 

[jonscott8]

Review the documentation on the Run method.

http://msdn.microsoft.com/library/en-us/vbaac10/html/acmthrun.asp

.Run "webGotoItem","ItemOne"

Jon Hawkins