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

Подписаться 237 тыс.

50% 1

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:
RU-vid: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
Weather API 2: 599cd.com/Weat...
PREREQUISITES:
Weather API, Part 1: 599cd.com/Weat...
LINKS:
AccuWeather: rss.accuweathe...
OpenWeather: openweathermap...
OpenWeather Signup Page: home.openweath...
OpenWeather API Call City, State: api.openweathe... Coral,FL,USA&units=imperial&mode=xml&appid=YOURAPIKEY
OpenWeather API Call ZIP Code: api.openweathe...
OpenWeather API Call Coordinates: api.openweathe...
Status Box: 599cd.com/Status
Double Double Quotes: 599cd.com/Doub...
RECOMMENDED COURSES:
Access Expert 24: 599cd.com/ACX24
Access Developer Courses: 599cd.com/Deve...
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Mi...
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
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.

Опубликовано:

16 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 7

@Shadow.Dragon Месяц назад

Thanks Richard (and Juan) for the great video!

@alializadeh8195 Месяц назад

Thanks

@jopaz3780 Месяц назад

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.

@waynebendelow282 Месяц назад

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.

@599CD Месяц назад

599cd.com/Ask