Originally Posted by
carlmdobbs
I have automated programs by causing MS Access to open a web site, click on the needed keyboard keys to open a web page. It then used the tab key and other control keys to do what your fingers would do to capture the information you needed.
The captured information can then go to MS Access easily.
Don't be afraid to do this. People often use keyboard macros. In MS Access you just have to write line after line of SendKeys to do the work your fingers would do.
That is the ONLY way.