Compile error Type Mismatch - Weather API in Microsoft Access, Part 2


	Back to Weather API 2 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Compile error Type Mismatch

Tannim Hallman

2 years ago

I was getting a type mismatch error in my GetWeather() function so I downloaded the database and copy/pasted from yours. I'm still getting the error but when I compile your copy, I don't.
MyURL = "https://api.openweathermap.org/data/2.5/weather?" & _
"zip=" & Forms!MainMenuF!ZIP & "&units=imperial&mode=xml&appid=" & APIKEY
Where it highlights is !ZIP
I checked and the ZIP field is a regular text field. I didn't change any properties. I have also closed down the database and re-opened it.

	Alex Hedley @Reply 2 years ago
What's the name of the Control?

	Tannim Hallman OP @Reply 2 years ago
The control is named ZIP. I checked that, too, because I don't type as well as I used to. I have also gone as far as rebooting the entire machine, and the error persists. I also tried with [ZIP] and [MainMenuF]![ZIP]

	Alex Hedley @Reply 2 years ago
What happens if you `MsgBox` ZIP?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Weather API 2.

Next Unseen

New Feature: Comment Live View