Hi all,
My large public sector employer makes use of a large private sector
comglomarate for our IT, and so flexibilty and attention to the needs of the
little people aren't exactly top of anyone's agenda.
To that end, I've spent the last 3 years providing quick 'n' cheap databases
in Acc 97, augmented with VB that I'm picking up from books and the net.
My employer's intranet displays stuff (e.g. staff location info) & I'd like
to tap into this via Access 97. Currently i can use SendKeys (i.e. take the
user name form our db and submit this data to the 'search' page of a
webpage. (i.e. load a page via a Hyperlink & then SendKeys) And yep, it
works sometimes. My question is: How can I optimise this to (say) delay
'sending the keys' until the page has fully loaded and /or interact more
intelligently with the web page. (e.g can loading the page inside an Access
form give me more control?)
If I can make this work better/properly, there's a bunch of other stuff I
could do to improve the data at our disposal, but at the moment, while some
folks are impressed by this, I'm frankly a little embarressed: something
that only works correctly 90% of the time may as well not work at all.
Any pointers?
Paul Wagstaff