I have a table with firstname, lastname, and birthdate and about 20
records. I need to visit a website to look up info on each of these
people. I'm looking for a way to automate the process (at least a
little bit).

The website can only look up people one at a time. The website has
fields for lastname, firstname, middlename, and birthdate. The middle
name is optional. On the website, I can navigate between fields with
the tab key.

I'm looking for a method to read one record from my table, and
possibly use the clipboard to store lastname & vbTab & firstname &
vbTab & vbTab & birthdate. Then I can switch to the website and ctrl+v
to past the data into the fields.

I tried a form with an unbound text control and built the data string
into the text control and loaded it into the clipboard. But when I
switch to the website & paste, it loads the entire string into the 1st
field.

Has anyone got a better technique?
TIA
Fred

<zuckermanf (AT) gmail (DOT) com> wrote

Maybe you can bypass the input form. After submitting the form, take a look
at the address bar for the new page. If it is like Google map, it will be a
long string. Try decoding this string to see it you can submit it directly
to the browser.

Thanks for the suggestion, Ron. Unfortunately, after entering the
input data, the website does not transition to another webpage.
Instead, the resultant information is displayed on the same web page
by appending it to the bottom of the page. The web page address does
not change. The address ends with the extension of ".aspx" if that
gives you an indication of what language it uses.
Fred



On Jun 16, 7:29*am, "paii, Ron" <n... (AT) no (DOT) com> wrote:

Sorry to hear that, pulling up a Google or Yahoo map from Access if very
easy. I don't have any suggestions about filling in a HTML form from Access
but I think ".aspx" is a ASP.NET extension.

<zuckermanf (AT) gmail (DOT) com> wrote

Thanks for the suggestion, Ron. Unfortunately, after entering the
input data, the website does not transition to another webpage.
Instead, the resultant information is displayed on the same web page
by appending it to the bottom of the page. The web page address does
not change. The address ends with the extension of ".aspx" if that
gives you an indication of what language it uses.
Fred



On Jun 16, 7:29 am, "paii, Ron" <n... (AT) no (DOT) com> wrote: