Computer Learning Zone
Computer Learning Zone
  • 1 842
  • 45 461 882
How to Use a Web-Based Weather API To Pull Current Weather Data into Microsoft Access
In this Microsoft Access tutorial, I will show you how to use a web-based weather API to pull current weather data into your database. We will cover API basics, obtaining and using an API key, and importing weather data into Access
BECOME A MEMBER:
UA-cam: ua-cam.com/channels/l7-jJie4ifOVK87FINIuDg.htmljoin
or My Site: 599cd.com/THMember
LEARN MORE:
Weather API: 599cd.com/WeatherAPI
PREREQUISITES:
Intro to VBA: 599cd.com/VBA
Web API: 599cd.com/WebAPI
Find Between: 599cd.com/FindBetween
LINKS:
AccuWeather: rss.accuweather.com/rss/liveweather_rss.asp?locCode=33909
OpenWeather: openweathermap.org
OpenWeather Signup Page: home.openweathermap.org/users/sign_up
OpenWeather API Call City, State: api.openweathermap.org/data/2.5/weather?q=Cape Coral,FL,USA&units=imperial&mode=xml&appid=YOURAPIKEY
OpenWeather API Call ZIP Code: api.openweathermap.org/data/2.5/weather?zip=33909&units=imperial&mode=xml&appid=YOURAPIKEY
OpenWeather API Call Coordinates: api.openweathermap.org/data/2.5/weather?lat=26.5&lon=-81.9&units=imperial&mode=xml&appid=YOURAPIKEY
UP NEXT:
Weather API, Part 2: 599cd.com/WeatherAPI2
RECOMMENDED COURSES:
Access Expert 24: 599cd.com/ACX24
Access Developer Courses: 599cd.com/Developer
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$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/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access/
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, web-based weather API, current weather data, Microsoft Access VBA, weather conditions Access, OpenWeatherMap API, Access API call, API key setup, retrieve weather Access, XML weather data Access, JSON to XML Access, Access weather import, temperature data Access, wind speed Access, humidity data Access, parse XML Access
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
Переглядів: 541

Відео

Avoiding Phishing Scams: How to Spot and Prevent Email Phishing Attacks
Переглядів 7219 годин тому
In this tutorial, I will show you how to spot and prevent email phishing attacks, understand phishing attempts, identify suspicious links, and report phishing to your email provider. Learn to protect your sensitive information and maintain cybersecurity in both personal and professional settings. BECOME A MEMBER: UA-cam: ua-cam.com/channels/l7-jJie4ifOVK87FINIuDg.htmljoin or My Site: 599cd.com/...
Identifying a Security Flaw with Linked Tables in a Microsoft Access Database, Part 2
Переглядів 1 тис.14 годин тому
In this Microsoft Access tutorial, I will show you how to identify a significant security flaw involving linked tables and how to fix it using unbound forms and connection strings. This video covers setting up a connection string, opening record sets programmatically, and minimizing security risks in your Access databases. This is part 2. Silver Members & up get access to an Extended Cut of thi...
Identifying a Security Flaw with Linked Tables in a Microsoft Access Database (and How to Fix it)
Переглядів 1,3 тис.17 годин тому
In this Microsoft Access tutorial, I will show you how to identify and fix a significant security flaw with linked tables. Learn how passwords stored in frontend files can compromise your data and explore effective methods to secure your backend, such as setting passwords on the frontend and using VBA for dynamic linking. Sam from Murrieta, California (a Gold Member) asks: I have noticed that e...
How to Determine the Date of the Second Last Order Placed by a Customer in Microsoft Access (DMax)
Переглядів 90819 годин тому
In this Microsoft Access tutorial, I will show you how to determine the date of the second last order placed by a customer, using domain aggregate functions like DMax. We will explore methods to accurately extract and compare order dates, even when multiple orders are placed on the same day. Simon from Blue Springs, Missouri (a Gold Member) asks: This might seem like a weird question, but I nee...
How to Properly Relate Students & Parents in a Microsoft Access Database, Part 8
Переглядів 810День тому
In this Microsoft Access tutorial, I will show you how to manage a mailing list for students and parents. We'll learn to store which parents are on the mailing list for each student (not everyone needs to get a copy of Timmy's report card). This is part 8. BECOME A MEMBER: UA-cam: ua-cam.com/channels/l7-jJie4ifOVK87FINIuDg.htmljoin or My Site: 599cd.com/THMember LEARN MORE: Students & Parents 8...
How to Properly Relate Students & Parents in a Microsoft Access Database, Part 7
Переглядів 828День тому
In this Microsoft Access tutorial, I will show you how to streamline adding students and parents directly within a form using a list items edit form. We'll create continuous forms for editing data, add functionality to our main menu with buttons, and enable easier navigation across your database. This is part 7. Silver Members & up get access to an Extended Cut of this video. In the extended cu...
How to Properly Relate Students & Parents in a Microsoft Access Database, Part 6
Переглядів 789День тому
In this Microsoft Access tutorial, we will build a report to properly relate students and parents, setting up groupings and sorting defaults for a well-organized phone list. This is part 6. BECOME A MEMBER: UA-cam: ua-cam.com/channels/l7-jJie4ifOVK87FINIuDg.htmljoin or My Site: 599cd.com/THMember LEARN MORE: Students & Parents 6: 599cd.com/StudentsParents6 PREREQUISITES: Students & Parents, Par...
How to Properly Relate Students & Parents in a Microsoft Access Database, Part 5
Переглядів 831День тому
In this Microsoft Access tutorial, we will learn how to create a comprehensive call sheet by properly relating students and parents in your database, adding parent phone numbers, and using queries to generate reports listing each student with their corresponding parent. This is part 5. BECOME A MEMBER: UA-cam: ua-cam.com/channels/l7-jJie4ifOVK87FINIuDg.htmljoin or My Site: 599cd.com/THMember LE...
How to Properly Relate Students & Parents in a Microsoft Access Database, Part 4
Переглядів 1 тис.14 днів тому
In this Microsoft Access tutorial, I will show you how to efficiently navigate between student and parent records using buttons and VBA code. Whether you prefer a no-programming solution or want to learn a bit of VBA, you'll learn two methods to link your student and parent forms seamlessly. This is part 4. BECOME A MEMBER: UA-cam: ua-cam.com/channels/l7-jJie4ifOVK87FINIuDg.htmljoin or My Site:...
Inclusivity Matters: Addressing Feedback on Inclusive Gender Options in Microsoft Access
Переглядів 1 тис.14 днів тому
I wanted to address some of the feedback I've received on my recent Microsoft Access video about adding more inclusive sex and gender options. Some of you have raised concerns, so I want to take a moment to clarify a few things. First, let me say that my goal with these tutorials is to create tools that are useful for everyone. This isn't about being "woke"; it's about recognizing that our worl...
How to Properly Relate Students & Parents in a Microsoft Access Database, Part 3
Переглядів 1,1 тис.14 днів тому
In this Microsoft Access tutorial, we will learn how to create forms to manage student-parent relationships using junction tables, continuous forms, and combo boxes. I'll show you how to efficiently view and edit multiple parents for each student and vice versa. This is part 3. BECOME A MEMBER: UA-cam: ua-cam.com/channels/l7-jJie4ifOVK87FINIuDg.htmljoin or My Site: 599cd.com/THMember LEARN MORE...
How to Properly Relate Students & Parents in a Microsoft Access Database, Part 2
Переглядів 1,1 тис.14 днів тому
In this Microsoft Access tutorial, I will show you how to properly relate students and parents in your database, including setting up a junction table and using an append query to fix existing records. This is part 2. BECOME A MEMBER: UA-cam: ua-cam.com/channels/l7-jJie4ifOVK87FINIuDg.htmljoin or My Site: 599cd.com/THMember LEARN MORE: Students & Parents 2: 599cd.com/StudentsParents2 PREREQUISI...
How to Properly Relate Students & Parents in a Microsoft Access Database (and Fix Your Old Records!)
Переглядів 1,8 тис.14 днів тому
In this Microsoft Access tutorial, I will show you how to properly relate students and parents in your database, create a many-to-many relationship, and fix your old records without losing data. Learn to use append queries, relational combo boxes, and subforms effectively to manage complex relationships. Darren from Broomfield, Colorado (a Platinum Member) asks: I have my database set up where ...
How to Use the Screen.PreviousControl Property in Microsoft Access VBA
Переглядів 1,7 тис.21 день тому
How to Use the Screen.PreviousControl Property in Microsoft Access VBA
How to Store Multiple Options for Sex & Gender in Your Microsoft Access Database, Part 2
Переглядів 1 тис.21 день тому
How to Store Multiple Options for Sex & Gender in Your Microsoft Access Database, Part 2
How to Store Multiple Options for Sex & Gender in Your Microsoft Access Database
Переглядів 1,1 тис.28 днів тому
How to Store Multiple Options for Sex & Gender in Your Microsoft Access Database
Resolving a ByRef Argument Type Mismatch Error in Microsoft Access VBA
Переглядів 1,4 тис.Місяць тому
Resolving a ByRef Argument Type Mismatch Error in Microsoft Access VBA
Add an Abort Checkbox to Gracefully Exit a Loop in Microsoft Access VBA
Переглядів 1 тис.Місяць тому
Add an Abort Checkbox to Gracefully Exit a Loop in Microsoft Access VBA
How to Speed Up Your Loops in Microsoft Access VBA
Переглядів 1,8 тис.Місяць тому
How to Speed Up Your Loops in Microsoft Access VBA
How to Roll Back Microsoft Access to a Previous Version in Case of Bugs, Crashes, Problems
Переглядів 975Місяць тому
How to Roll Back Microsoft Access to a Previous Version in Case of Bugs, Crashes, Problems
Print a Shipping Label for a Customer with a Separate Ship To Address in Microsoft Access, Part 2
Переглядів 924Місяць тому
Print a Shipping Label for a Customer with a Separate Ship To Address in Microsoft Access, Part 2
How to Print a Shipping Label for a Customer with a Separate Ship To Address in Microsoft Access
Переглядів 1,2 тис.Місяць тому
How to Print a Shipping Label for a Customer with a Separate Ship To Address in Microsoft Access
How to Separate Debits & Credits From a Single Amount Field in Microsoft Access
Переглядів 1,8 тис.Місяць тому
How to Separate Debits & Credits From a Single Amount Field in Microsoft Access
How to Convert a Full ISO 8601 Date Time Value to Microsoft Access, Part 2
Переглядів 910Місяць тому
How to Convert a Full ISO 8601 Date Time Value to Microsoft Access, Part 2
How to Convert a Full ISO 8601 Date Time Value to Microsoft Access
Переглядів 1 тис.Місяць тому
How to Convert a Full ISO 8601 Date Time Value to Microsoft Access
Microsoft Access Quick Queries #18: Paste Behavior, Text Box Margins, Vertical Alignment, More...
Переглядів 1,7 тис.Місяць тому
Microsoft Access Quick Queries #18: Paste Behavior, Text Box Margins, Vertical Alignment, More...
Fail! When Using Another Query For Criteria or Calculations in Microsoft Access Doesn't Work
Переглядів 1,4 тис.Місяць тому
Fail! When Using Another Query For Criteria or Calculations in Microsoft Access Doesn't Work
Sometimes You Need Another Query to Use Criteria or Complicated Calculations in Microsoft Access
Переглядів 1,7 тис.Місяць тому
Sometimes You Need Another Query to Use Criteria or Complicated Calculations in Microsoft Access
How to Find Gaps in Your Check Number Sequence in Microsoft Access, Part 2
Переглядів 925Місяць тому
How to Find Gaps in Your Check Number Sequence in Microsoft Access, Part 2

КОМЕНТАРІ

  • @janvanantwerp6574
    @janvanantwerp6574 9 годин тому

    hmmmm

  • @yawarabbas205
    @yawarabbas205 День тому

    Sir thanks so much you shared this code. I tried so much to find it but failed. Thanks again, sir. God bless you

  • @donharrold1375
    @donharrold1375 2 дні тому

    Been building databases for a while but this is excellent!

  • @srinivasbommera3706
    @srinivasbommera3706 2 дні тому

    Really saved me alot of problems in ms access 🤝

  • @donharrold1375
    @donharrold1375 2 дні тому

    Completely understand why you wouldn’t want lookup lists inside tables. However, I hear a degree of opposition against lookup functions using dedicated external tables too. Some people think it will corrupt the database. I don’t understand why? Can you explain if there are any risks with the better approach?

  • @tonyleethal
    @tonyleethal 2 дні тому

    This channel is the bomb!!! I love it

  • @markfannin3975
    @markfannin3975 2 дні тому

    Great tutorial.!. Many thanks.

  • @mitchellfolbe8729
    @mitchellfolbe8729 2 дні тому

    Thanks for dance safety.

  • @shahramahmadzadeh5285
    @shahramahmadzadeh5285 3 дні тому

    I wish you would teach this topic completely and for free

    • @599CD
      @599CD 17 годин тому

      I would love to be able to do that, but are you going to pay my bills? I have to earn a living somehow. Paid videos and memberships allow me to keep making these FREE videos for everyone to enjoy. Otherwise, I'd have to get a real job and then I'd have no more time to make any videos.

    • @shahramahmadzadeh5285
      @shahramahmadzadeh5285 17 годин тому

      @@599CD yes I do?But unfortunatly I live in Iran , and because of sanction I can't be your member

    • @599CD
      @599CD 7 годин тому

      I understand, and wish I could just spend my time making free videos, but alas, I have to feed my family and this is what I do for a living. Hopefully one day SOON, our governments will get their acts together and PEACEFULLY coexist.

  • @victorGee-w6v
    @victorGee-w6v 3 дні тому

    This would be even cooler if it showed us how to name sheets as well. Very cool

  • @DebbieEA-d9v
    @DebbieEA-d9v 3 дні тому

    can you do this on behalf of someone?

  • @shahramahmadzadeh5285
    @shahramahmadzadeh5285 3 дні тому

    Thank You Very Much Sir

    • @599CD
      @599CD 7 годин тому

      Most welcome

  • @SonamPhuntsho-x6y
    @SonamPhuntsho-x6y 3 дні тому

    Very informative

  • @cruzinsweetsntreats
    @cruzinsweetsntreats 3 дні тому

    Not just Delta. 3rd party Microsoft antivirus group put in a bad update, causing chaos for those that updated Thursday and Friday last week.

  • @alializadeh8195
    @alializadeh8195 4 дні тому

    Thanks

  • @victorarchangel9400
    @victorarchangel9400 4 дні тому

    I follow your courses on UA-cam. But don't see a video where your life. Please show your self.

  • @MM-vg7bm
    @MM-vg7bm 4 дні тому

    9 years back I benefit your videos so much Appreciate all your efforts Seeing you keep adding video means people are still using MS Access I assumed its not being used any more Not sure who would be using it now while everything is running on web based applications

  • @erniehaverhals396
    @erniehaverhals396 4 дні тому

    Great Video. I think I'm gonna use it.

  • @alializadeh8195
    @alializadeh8195 4 дні тому

    Thanks

  • @janvanantwerp6574
    @janvanantwerp6574 4 дні тому

    Take a brake sir.....

  • @fontie38
    @fontie38 5 днів тому

    I hate learning about this right now. Have to find a way to encrypt my users table now😭

  • @robbbarbosa
    @robbbarbosa 5 днів тому

    Health to you my friend.

  • @GiovanniCutrona-q5s
    @GiovanniCutrona-q5s 5 днів тому

    Hi Richard...may I ask for the extended cut...I need the signature to save and print out on an invoice...thanks

    • @599CD
      @599CD 4 дні тому

      Link for the extended cut is in the description below the video

  • @cxp8619
    @cxp8619 5 днів тому

    the filtering in datasheet view being able to select from a drop down list multiple items is very helpful in sorting. Can this button be added to form in datasheet view in order to preserve this sortability.

  • @josepherhardt164
    @josepherhardt164 5 днів тому

    All my complaining aside (it appears YT may have a problem with "kv-e-t-ching"?), THANK YOU for posting this. It's saved me HOURS of ****ing around in Word. Seriously, if I had to choose between deth(sic) by firing skwad(sic) or deth(sic) by Microsoft, I'd have to have a think about it. I think YT is going nuts about automated post editing, thus the misspellings.

  • @hassanrozh6579
    @hassanrozh6579 5 днів тому

    Great job, thanks. But what about the queries, and how we deal with them?

  • @mohamedseda3735
    @mohamedseda3735 5 днів тому

    Excuse me, how i can hide the application window behind the opened form, as i want to open only the form...can i?

  • @mloucel7
    @mloucel7 6 днів тому

    Hi Richard.. WHAT IF... I have a database with a T/F Check Box, what if I want to highlight either ALL [or in my case] just 3 of the OTHER fields red back? I've tried a few times to no avail..

  • @daveyks1
    @daveyks1 6 днів тому

    Oh man...I had no idea....this is wonderful content! Please continue!

  • @sheilawebber
    @sheilawebber 6 днів тому

    Thank you for the video! It was really helpful. One thing - I have 365 and although I followed your instructions it still saved the new template in a different templates folder. However all I had to do was find the normal template's and the new template's folders and move the latter into the correct folder, so I could delete the old normal and rename the new one as you say.

  • @sumitsarkar8293
    @sumitsarkar8293 6 днів тому

    GOOD ONE

  • @shahramahmadzadeh5285
    @shahramahmadzadeh5285 6 днів тому

    Thank you My Kind Teacher😘

  • @aravind3596
    @aravind3596 6 днів тому

    Thanks 👍

  • @HusnaSadat-fo4zt
    @HusnaSadat-fo4zt 6 днів тому

    Thanks👍👍

  • @JoeHamby
    @JoeHamby 7 днів тому

    Google API gets a 404 error

  • @HusnaSadat-fo4zt
    @HusnaSadat-fo4zt 7 днів тому

    Good luck. Please, when we organize the login section, i.e. the login form, there is a login option. Can you teach us the code for which section it is used in, if you understand what I mean.

  • @vitom5513
    @vitom5513 7 днів тому

    Great video. If the "order date" has date and time, would that mean the first method is good (and easier)?

  • @stefanlarrass2123
    @stefanlarrass2123 7 днів тому

    Very helpful video. Thank you!

  • @bumpersmith
    @bumpersmith 7 днів тому

    Doubtful if this will work with a Replication ID type because of the random number assignmnts

  • @Shadow.Dragon
    @Shadow.Dragon 7 днів тому

    Great video, Richard! I rarely use multi-criteria in DMax function so its good to see an example.

  • @gleng399
    @gleng399 7 днів тому

    For Tattoo Artists is there a DPlane function?

  • @easyspeak101
    @easyspeak101 7 днів тому

    For feedback purposes, but first thank you Richard for better insights on MSAccess.. To newbies lots of practice to ensure proper oversight of record sets underneath the forms within this template.

  • @petervansoestdevrolijkeboe3320
    @petervansoestdevrolijkeboe3320 8 днів тому

    I kept getting ‘Subscript out of range’ when trying to split the database. Then I followed the tutorial of another video and that seems to work: 1) I made a copy of the database, 2) in 1 copy I removed everything but the tables (backend), 3)in the other copy I removed all the tables, saving the forms, queries, reports etc. (Front end), 5) I opend the front end table and linked it through “External data/from database/access…” with the backend table. It seems to work ok, but am I now at risk of any failures or errors in the future by ‘ surpassing’ the error message I got when trying to use the access splitting tool?

  • @slicqnick35
    @slicqnick35 8 днів тому

    the audio on your video as really awful otherwise a helpful video

  • @stephenbeswick2163
    @stephenbeswick2163 8 днів тому

    Hi Richard been watching your videos which are great. Could you please make a password generator in access please I have my accounts broken into and the banks were very good did not loose any money. If you could do this I would be grateful. Steven

  • @matamelamugagadeli8167
    @matamelamugagadeli8167 8 днів тому

    is it possible to have a tabular form with field names on the left (vertically aligned) instead of them at the top (horizontally)

  • @kkaminski
    @kkaminski 9 днів тому

    Interesting. Is there a way to do it for a form that uses a pass through query (which also uses connection string) as record source?

  • @Nigel1writer
    @Nigel1writer 10 днів тому

    Thanks Richard.

  • @christopherline5836
    @christopherline5836 10 днів тому

    Hi Richard< Thanks for the excellent video. I found an issue with this EOMONTH that I hope you will be able to provide an answer to. I created the EOMONTH function by following your instructions and it works perfectly - Thank You. However, when I use it in a form, then use it again in a Report, any fields that do not have a date (so basically Null values) have the text #Type! displaying and I have tried everything I can think of (conditional formatting etc.) but I cannot get rid of it. Please can you help as the Reports look horrible with this #Type! in every blank field!

  • @xavierbatlle1828
    @xavierbatlle1828 10 днів тому

    I resize subforms in the main form double clicking on the border of the subform in the main form. 😉