Hi,

I have created a form in MS access. On submit the form I need to call procedure. Anybody have idea on this..

Thanks,

Webfocus 7.1, MS Access(UI)

This message has been edited. Last edited by: Kerry,

Don't know how MS Access works, but you might be able to construct a URL that will do this.

Access use the same VBA set that Excel does. You will likely have to create a module or macro in Access to do what you want.

You should be able to create a URL that points to your Web FOCUS servlet (normally in ibi_apps/WFServlet - you may need to qualify where ibi_apps lives). To thsi servlet, pass the reporting server name (or take the default), the focexec name (provided it is in a folder/directory in the app path), and any parameters that the focexec needs. That should do it.

Hi All,

Thanks for your replies,

I am using following code to hit webfocus server. But It is not working. Could anybody provide some sample code to connect to webfocus server.

Private Sub Command0_Click()
Dim sUrl As String
sUrl = "/ibi_apps/WFServlet? IBIF_ex=car.fex &IBIAPP_APP=foldername &IBIC_server=BIWC01 "


FollowHyperlink sUrl
End Sub

Thanks,

quote:

sUrl = "/ibi_apps/WFServlet? IBIF_ex=car.fex &IBIAPP_APP=foldername &IBIC_server=BIWC01 "

Srini,

Firstly try to understand how the url will function and where you have to direct it. Then you might be able to get your requirement working.

As a hint, What webserver are you expecting to hit?

T

as a further hint remove the spaces from your url....