Need help submitting a HTML form using MS Access 2000!!

jimtmelb1 · Nov 25, 2004

Hi,

Is there any way to create a html form in Access 2000 using information already installed in the database and when the user clicks on a button it submits this html form to its destination without creating a html file on the local machine.

Creating a html file locally is the way I have been doing it currently which works okay except when the form submits on load it it blocked by IE in Win XP SP2.

Can this be done inside Access or is there any other way of doing this.

This is a snippet of the html file I create locally. It shows that onload the form is submitted. I still want this to happen without being blocked in IE for WINXP SP2.

The message in IE is "To help protect your security, Internet Explorer has restricted this file from showing active content that could access your computer".

Thanks
Jim

'''''
strFileContent = strFileContent & "<body bgcolor=#FFFFFF text=#000000 link=#FFFFFF alink=#FFFFFF vlink=#FFFFFF onLoad=" & Chr$(34) & "Test.submit()" & Chr$(34) & ">" & vbNewLine

strFileContent = strFileContent & "<FORM NAME=" & Chr$(34) & "Test" & Chr$(34) & " METHOD=POST ACTION=

http://test/index.jsp>"

& vbNewLine

oharab · Nov 26, 2004

You could try using the XMLHTTP object.

Code:

Dim objXMLHTTP, xml
  Set xml = CreateObject("Microsoft.XMLHTTP")
    
  xml.Open "POST", "[URL unfurl="true"]http://website/datapage.asp",[/URL] False
  xml.Send "datum=bob&datum2=bill&datum3=jayne"
    
  Debug.Print xml.responseText

  Set xml = Nothing

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------
Want to get great answers to your Tek-Tips questions? Have a look at F

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Need help submitting a HTML form using MS Access 2000!!

jimtmelb1

Technical User

oharab

Programmer

Similar threads

Part and Inventory Search

Sponsor