Access Web Sync Seminar (see lesson 4)

Windows 10 can display weather info on the taskbar (go to Start -> System -> Personalization -> Taskbar -> Show news and interests on the taskbar).  See picture below.  So I would consider going with that first.  If you do this for a company, you may not want to spend resources to build, maintain, debug, etc. something that is already built-in in your PC.

Thank Kevin, I was try to figure out if there was away to "Get Weather Data" for a Location for Client's Chemical Applications and save it in the Table.

Do you have lots of locations for which this needs to be done?  If you have only a few, you may consider just looking them up manually on the web and put the info into the table.

Weather changes all the time.  Do you need frequent real-time retrievals of up-to-the-minute weather info?  Of few locations?  Many locations?

Obviously, it would only be worth it to write code for this if it were for many locations and many and frequent retrievals of data.  If I had to do this manually 10 times a day, I would rather do it manually.  If I had to do it, well..., 100 times a day, then maybe I would look for ways to automate it.

If I were paid to create automation for this, I would consider "web-scrapping."  This is (way) outside the scope of Access and database, but let me briefly describes it.

For instance, this is the webpage showing current weather info of Seattle, WA:
https://weather.com/weather/today/l/98105

Every webpage is composed of HTML codes.  The codes are just plain text.  With VBA, Access is able to obtain those codes.

The codes of the above webpage contain something like this:

     <span class="CurrentConditions.....">49'</span>
     <div class="CurrentConditions.....">Mostly Cloudy</div>

And this is where VBA could extract key text data from the codes: 49' and Mostly Cloudy.  Once obtained, you can store these values into tables.

The more "standard", more widely used method is to use the API (application programming interface) furnished by the website.  This may make coding simpler to do, but it may cost you for the use of the API, which is almost always proprietary.  And if the website's owner goes out of business, the API becomes unusable.  Also, whoever you hire may not be familiar with said API; he will have to learn it, and that will cost you more.

Access Expert 24

Thanks Guys....