Recent content by gwynn76

  1. G

    Weather forecast VBA

    How did you code that (as in did you go through each icon element since there are several)? OR did you blanket code for the elements? And does it work?
  2. G

    Weather forecast VBA

    Hey June! Thanks. That was actually one of the many posts I visited when creating this :-) Everything works but when the live XML doesn't include information, I need to figure out how to make it skip that line and continue on to the next. Gasman's XML feed is missing data :-(
  3. G

    Weather forecast VBA

    From your excerpt: <flik>43</flik> <t></t> <icon></icon> <bar> Yes, there isn't an "icon" specified in the XML file - nor a title for the weather condition. That's not your fault. Or the programs fault. That's the services fault lol. For some reason the...
  4. G

    Weather forecast VBA

    Your online XML feed attached... There are a few missing elements in this XML feed. Your problem might simply be the missing data. A DB is only as good as the data put into it and this file is sketchy. It's entirely possible you might need to wait a day or two and then try looking at the live...
  5. G

    Weather forecast VBA

    When I plug in your location data, it populates correctly on my end (see images). So, I'm not sure why it wouldn't populate on yours unless the image paths were off somewhere or you changed the day0 from the lsup. The only reason it would have for not adding an image otherwise would be if there...
  6. G

    Weather forecast VBA

    C:\Temp\Weather\weather_icons\.png - Why are you using the .png in your path? To grab the images from the folder, you should have nothing after the backslash (\). That allows the code to find the right image in the specified folder. "\\BIDMAGIC-SERVER\Microsoft SQL Server\Tracker DB BE\Front...
  7. G

    Weather forecast VBA

    For day 0 (Current on 5 day and 10 day) the weather changes throughout the day. So instead of using an icon "path" in the direct XML, it pulls from: .imgWeatherIcon.ControlTipText = "Updated " & WeatherConditions.selectSingleNode("lsup").Text - LSUP under day 0. If the icon path is not set...
  8. G

    Weather forecast VBA

    I can try it again. But every time I tried to pull all images for 5 day or 10 day from the same local image path, it would break all of the images. That was one of those beat my head against the wall moments as theoretically, it should have worked just fine.
  9. G

    Weather forecast VBA

    Another image with changes location so you can see that the images are changing.
  10. G

    Weather forecast VBA

    Just use Google and search for weather location codes and choose your location. Your zip code can work as well just make sure you change the location code in all areas where it pulls the weather xml data for location. Attached images of current weather showing working images. Make sure you...
  11. G

    Weather forecast VBA

    OK - I have attached images separate from the weather database sample. The zipped file with all exceeds the 2mb limit. You'll need to unzip the "Day" and then create a folder called "weather_icons" in the location you want the coding to point to. In "weather_icons" folder, you'll need to create...
  12. G

    Weather forecast VBA

    Well, all ready to go but keep getting a security token error when I try to upload the zip file. Sent a message to the admin. Sorry :-( hopefully will be ironed out soon!
  13. G

    Weather forecast VBA

    Sure. Can do so tomorrow. Will zip all together and add directions for where the code will need to be changed so it works. If you want to show all images for each area (day/part like the 6 day) you will need multiple image paths (will also break that out). Was part of what I ran into. For some...
  14. G

    Weather forecast VBA

    Figured it out. Using selectSingleNode on dayf you cannot loop because there are spaces in the naming convention of the XML. Can't loop it using selectNode either. If you want to populate all "days" under dayf you have to specify precisely what day you want bypassing the spaces...
  15. G

    Weather forecast VBA

    I am trying to do exactly what it said: pull the 6 day forecast from the XML file to populate the fields. It’s only 2 forms. The first form already populates correctly. That form is the one day forecast. Included to show it works. The second form is the 6 day forecast. I can only get it to...
Top Bottom