Parsing

[Access Newbie with a headache via AccessMonster.co]

Would anyone have a clue as to how to go about possibly writing a code in
access that would use a field (tracking number) and be able to enter it into
a website through code, and possibly track the shipment date automatically?
It is a feature that my boss would like to install, but may be above my lever
of coding. Any hints or tips would be great, or if you think it will be
almost impossible, let me know before I invest massive amounts of time into
it!

Thanks for your time

 

[Wolfgang Kais]

Hello "Access Newbie with a headache".

Would anyone have a clue as to how to go about possibly writing a
code in access that would use a field (tracking number) and be able
to enter it into a website through code, and possibly track the
shipment date automatically? It is a feature that my boss would like
to install, but may be above my lever of coding. Any hints or tips
would be great, or if you think it will be almost impossible, let me
know before I invest massive amounts of time into it!

So you want a webpage be filled automatically, submit it, receive the answer
webpage and process the result? It will be difficult to manage if the
webpage (and it's controls) change.
Anyway, you could use a webbrowser control to load the webpage, change the
contents of a (web)form control (tracking number) by using the document
object model (BrowserControl.Document.FormName.TextBoxName = "..."), send
the form back (BrowserControl.Document.FormName.submit) and wait for the
DocumentComplete event to read the data from that page.