Copy Access data to Internet Browser window?

[ghnat]

Was wondering if it was possible to send MSAccess data from a query -OR- using the VB send keys function onto a specific browser window currently open on the desktop. My delima is that there could multiple windows open and the internet application in question sits behind a user ID/password protected site, so opening up the same URL again would not work.

Is this possible? Please advise.

Thank you in advance for any assistance in this matter

Gary

 

[JoeAtWork]

I'm pretty confused as to what you want to do.

Are you writing a web application (e.g. ASP or ASP.NET) and you want to display information from the database to the web page?

 

[ghnat]

What I currently do while in MSAccess is ...

Private Sub UpdateSabre_Click()
On Error GoTo Err_UpdateSabre_Click

Dim stAppName As String
Dim stMSAccess As String

stAppName = "C:\SABRE\SV.EXE"
stMSAccess = "C:\Program Files\Microsoft Office\Office\MSAccess.exe"
Call Shell(stAppName, 1)

SendKeys "% "
SendKeys "x"
SendKeys "{home}"
SendKeys "5h-** ftc script utilized - " & Date
SendKeys "¶"
SendKeys "5h-future credit declined ... " & [NoUse]
SendKeys "¶"
SendKeys "*a"
SendKeys "^%e"

Exit_UpdateSabre_Click:
Exit Sub

Err_UpdateSabre_Click:
MsgBox Err.Description
Resume Exit_UpdateSabre_Click
End Sub

which writes info into a desktop application SV.exe which is not browser based However this application is now moving to a web based product and I am not sure on how to send the same info to a specific web browser window (open, but minimized as the user is currently in Access)
Note - There could be multiple browser windows open but I would need to send it to a specific one.

Hope this clarifies .. thank you for you assistanace!

Sorry ... I'm a bit of a newbie at this

Gary

 

[Remou]

This may help:
On Error won't work for Loop Code pasting Info on Internet
thread705-1254066