- 1 842
- 45 461 882
Computer Learning Zone
United States
Приєднався 7 вер 2006
Computer Learning Zone specializes in making video tutorials to teach you how to learn Microsoft Access, Word, Excel, Windows, and much more. Learn more about us and sign up for more free lessons at 599cd.com.
Richard Rost was awarded Microsoft MVP in 2014, 2015, and again in 2023. He has been a computer consultant and trainer since the early 90s, and is the author of The Complete Idiot's Guide to Microsoft Excel 2010 from Alpha Books: 599CD.com/XCIGXLY
BUSINESS INQUIRIES: I get a LOT of emails from people asking to advertise on my channel. If you want me to even consider advertising your product, FIRST you must become a DIAMOND SPONSOR on my channel. Then you may email me about any other offers you may have. You can find out more information here: 599cd.com/Business
Richard Rost was awarded Microsoft MVP in 2014, 2015, and again in 2023. He has been a computer consultant and trainer since the early 90s, and is the author of The Complete Idiot's Guide to Microsoft Excel 2010 from Alpha Books: 599CD.com/XCIGXLY
BUSINESS INQUIRIES: I get a LOT of emails from people asking to advertise on my channel. If you want me to even consider advertising your product, FIRST you must become a DIAMOND SPONSOR on my channel. Then you may email me about any other offers you may have. You can find out more information here: 599cd.com/Business
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.
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
hmmmm
Sir thanks so much you shared this code. I tried so much to find it but failed. Thanks again, sir. God bless you
Been building databases for a while but this is excellent!
Really saved me alot of problems in ms access 🤝
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?
This channel is the bomb!!! I love it
Great tutorial.!. Many thanks.
Thanks for dance safety.
I wish you would teach this topic completely and for free
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.
@@599CD yes I do?But unfortunatly I live in Iran , and because of sanction I can't be your member
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.
This would be even cooler if it showed us how to name sheets as well. Very cool
can you do this on behalf of someone?
Thank You Very Much Sir
Most welcome
Very informative
Not just Delta. 3rd party Microsoft antivirus group put in a bad update, causing chaos for those that updated Thursday and Friday last week.
Thanks
I follow your courses on UA-cam. But don't see a video where your life. Please show your self.
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
Great Video. I think I'm gonna use it.
Thanks
Take a brake sir.....
I hate learning about this right now. Have to find a way to encrypt my users table now😭
Health to you my friend.
Hi Richard...may I ask for the extended cut...I need the signature to save and print out on an invoice...thanks
Link for the extended cut is in the description below the video
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.
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.
Great job, thanks. But what about the queries, and how we deal with them?
i've the same question.
Excuse me, how i can hide the application window behind the opened form, as i want to open only the form...can i?
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..
Oh man...I had no idea....this is wonderful content! Please continue!
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.
GOOD ONE
Thank you My Kind Teacher😘
Thanks 👍
Thanks👍👍
Google API gets a 404 error
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.
Great video. If the "order date" has date and time, would that mean the first method is good (and easier)?
Very helpful video. Thank you!
Doubtful if this will work with a Replication ID type because of the random number assignmnts
Great video, Richard! I rarely use multi-criteria in DMax function so its good to see an example.
For Tattoo Artists is there a DPlane function?
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.
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?
the audio on your video as really awful otherwise a helpful video
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
is it possible to have a tabular form with field names on the left (vertically aligned) instead of them at the top (horizontally)
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?
Thanks Richard.
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!
I resize subforms in the main form double clicking on the border of the subform in the main form. 😉