How to Use a Web-Based Weather API To Pull Current Weather Data into Microsoft Access, Part 2

In this Microsoft Access tutorial, you will learn how to pull current weather data using a web-based weather API. We will cover methods for API calls, setting up a default zip code, creating the appropriate modules, and parsing the returned weather data to display key information like temperature and location in your Access database. This is part 2.

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

RECOMMENDED COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, weather API tutorial, Microsoft Access, web-based API, current weather data, Access VBA, parse weather data, API key management, weather data API, OpenWeatherMap integration, zip code weather retrieval, automate data pulling, VBA programming, Access API calls, weather data extraction, real-time weather Access, JSON response parsing Access

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[Shadow.Dragon]

Thanks Richard (and Juan) for the great video!

[jopaz]

Hi Richard, is it possible to send msg or chat into front end user in MS access?

[onyx_gabriel]

I have a problem with my access form. I'm making a database for a small therapy clinic and it's patients, one of the forms I have for it doesn't display the fields when I enter into Form View, and Layout View, but all of it is present on Design View. I checked the Visibility to make sure it's Yes and have tried turning the Visibility on and off but it still wouldn't show up.

[waynebendelow]

Thank you for this Video. I implemented to get Wind, Wind Gusts, Humidity, Temperature and Sky. Sky has given me issues. I am working on that. I did notice that my first API call provides new information but subsequent calls only get the old information. In order to get new information i have to close the form, close access, reopen access, reopen the form and make my request. Anyone know a fix? I can make calls by entering my API Key directly in the browser and get new information, but using the key in my access vba after the first New my follow on calls give me the original NEW. Close access and reopen, I then get New.