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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access to HTML form
- Thread starter dani58
- Start date
Yes, you may be able to run an instance of Internet Explorer within Access, and transfer the data as you're saying.
Another method, which woudld be easier to implement, but may also be riskier, would be to use SendKeys.
To use a slighly better version of SendKeys, there's an API out there you can download for free from Microsoft Access MVP, Dev Ashish:
When I used that API, SendKeys seemed to at least be a little less buggy, but still not perfect.
--
"If to err is human, then I must be some kind of human!" -Me
Another method, which woudld be easier to implement, but may also be riskier, would be to use SendKeys.
To use a slighly better version of SendKeys, there's an API out there you can download for free from Microsoft Access MVP, Dev Ashish:
When I used that API, SendKeys seemed to at least be a little less buggy, but still not perfect.
--
"If to err is human, then I must be some kind of human!" -Me
- Thread starter
- #3
thanks for your replay
In a database Access I manage some information that every month I must have transmitted to a public Office.
For the trasmission that Office has predisposed a form on a page html, with various fields (text, radio, check) that must be compiled with the data on my db Access.
To manage all from the inside of the procedure in Access:
1) I have a form in Access with the data
2) I have positioned an activex web Browser in other form of Access, and I pass to it the parameter of the URL to which I have to connect, .
3) the browser shows the page html with the form to compile.
To this point I could compile with copy2clipboard and after pastefromClipboard, but I would like to be able to interact (button with OnClick event???) with the form html sending it the values in form Access by VBA and eventually, when I stop compilation, to read a value in the form html and to send it to the form of Access, always by VBA.
The problem is for me, first of all, understand the name or id of the fields in the form html, and then as to modify them according to the values stored in form Access and vice versa.
Too complicated?
thanks, dani
In a database Access I manage some information that every month I must have transmitted to a public Office.
For the trasmission that Office has predisposed a form on a page html, with various fields (text, radio, check) that must be compiled with the data on my db Access.
To manage all from the inside of the procedure in Access:
1) I have a form in Access with the data
2) I have positioned an activex web Browser in other form of Access, and I pass to it the parameter of the URL to which I have to connect, .
3) the browser shows the page html with the form to compile.
To this point I could compile with copy2clipboard and after pastefromClipboard, but I would like to be able to interact (button with OnClick event???) with the form html sending it the values in form Access by VBA and eventually, when I stop compilation, to read a value in the form html and to send it to the form of Access, always by VBA.
The problem is for me, first of all, understand the name or id of the fields in the form html, and then as to modify them according to the values stored in form Access and vice versa.
Too complicated?
thanks, dani
- Status
Similar threads
