Stock Quote

[Guest]

I am trying to figure out how to insert an up to date stock quote into one of
my forms. I found an article online about how to do it in excel
(http://office.microsoft.com/en-us/assistance/HP010414041033.aspx) but don't
know how to carry that over to an access form. Any ideas?

 

[Arvin Meyer [MVP]]

I am trying to figure out how to insert an up to date stock quote into one
of
my forms. I found an article online about how to do it in excel
(http://office.microsoft.com/en-us/assistance/HP010414041033.aspx) but
don't
know how to carry that over to an access form. Any ideas?

If the output of the stock quote control is to an Excel cell, you can read
it using automation:

http://www.mvps.org/access/modules/mdl0006.htm

If it is an ActiveX control, try inserting the control into an Access form.
Using the "More Controls ... " Tool from the Access form toolbox in Design
View, search through all the available controls until you find it.