web query in Access 2007

Y

YAM

Hi

I need to state a query the gets information from the WEB as a parameter and
uses it in a calculate query.
specifically, I need to translate product prices from $ to EURO using
up-to-date currency rate.

Can a query do that automatically?

Thanks, Yaniv
 
M

Michel Walsh

If your application runs inside Access itself, you can call one of your own
made public VBA function (stored in a standard module, not in a class, not
under a form) in your query. This function may call the web-service you
need, say, returning the $/Euro actual rate, result that can be then used in
your query.

Vanderghast, Access MVP
 
M

Michel Walsh

Even if it is clearly possible to extract values from any web pages (you can
parse yourself the HTML code), I don't know of any simple mean to do it and
if I would have to do it, I would probably not use VB6/VBA to do it.


Sorry,
Vanderghast, Access MVP
 
Y

YAM

thanks, Yaniv

Michel Walsh said:
Even if it is clearly possible to extract values from any web pages (you can
parse yourself the HTML code), I don't know of any simple mean to do it and
if I would have to do it, I would probably not use VB6/VBA to do it.


Sorry,
Vanderghast, Access MVP
Click to expand...
 
Top