Search results

Yeah you need to make the others invisible in that case. Img1.visible = true Img2.visible = false Img3.visible = false In the next elseif Img1.visible = false Img2.visible = true Img3.visible = false In the else Img1.visible = false Img2.visible = false Img3.visible = true Edit, yeah like...

Hi, How about If me.AvgOfTemp < 32 then Image below 32 goes here Elseif me.AvgOfTemp > 100 then Image above 100 goes here Else Image between 32 and 100 goes here End if

Why not just make a recordset, get school name and number of pupils. Add a loop that executes an INSERT statement for 1 to NrOfPupils times and go to the next record/school?

Additionally you should read up on Xpath, this is what Google recommends for parsing the result.

Well with the function the user selects a file, the function returns the selected file name with path. So: strFilename = fdialog(....) Then you add a new record to your documents table. ID, Filename with Path and possibly an description. It should return the Document ID. Then you copy the...

I can highly recommend this article from Daniel Pineault that shows how you can use the File Dialog. https://www.devhut.net/2016/10/04/late-binding-the-filedialog/

With regards to the allocation of the nearest inspector the solution could be to use the Google Maps Distance API. You can use this API to determine the distance between sets of coordinates. It will be a loop calculating the distance for each inspector and then returning the nearest one. You...

You can find a list of all/most Office constants here on this site: https://www.codekabinett.com/page.php?Lang=2&Theme=10

I only know how to do it with an external program called 7zip. Here is some excellent code from Daniel Pineault: https://www.devhut.net/2017/04/06/vba-zip-unzip-compress-extract/

Here is a link to an article by Gustav Brock, I didn't try it, but he writes very good code, so it should work. https://www.experts-exchange.com/articles/31130/Zip-and-unzip-files-and-folders-with-VBA-the-Windows-Explorer-way.html

You can find some nice examples on the website from Daniel Pineault https://www.devhut.net/2016/07/07/vba-automating-excel/

Ah wow, yes, that should help a lot! Thank you for sharing Colin.

Ok, it's good to know that reducing the accuracy of the coordinates won't make any difference using this encoding scheme. The recipe looks a bit over my head to be honest, I'm not experienced working with binary data at all. For now it doesn't make much sense to me. I checked your application...

Thanks a lot for your feedback Colin. I think I'll need a similar combination of workarounds. Possibly first reduce the accuracy of the coordinates to max 4 decimals, then remove some of points as you described and finally apply the Encoding routine. I read the page you linked to, but it looks...

Hi Colin, I remembered this discussion from the past. I am now encountering the same problem actually, while generating a Google Static Map that displays a route using the Path parameter. When the route exceeds about 100 KM, the URL exceeds the 2K characters and it fails. Do you have some...

Thank you very much also DocMan, in fact the event date/time are currently in 1 field. I was thinking to split them up, but I understand in this case it's better not to. Adding the 2 extra fields in the Events table is also no problem, so we can populate these later with the queries. Basically...

Yes, I agree that would be the function I create as well, but wouldn't that be very slow? Wouldn't it be faster to have the classifications preloaded in an 3D array or something? I barely have any experience with Arrays so not sure if that would be suitable for this purpose... The update...

Thank you guys for your replies. Sorry if I'm not being clear. I get a weekly list of events (about 50 events) for each customer (about 100 customers). The event includes a customer ID, Date and Time. I need to add a classification letter to each event. The customer provides me with a...

Hi all, I need to classify events based on weekday and hour of day. I plan on creating a table that holds: CustID - WeekdayID (0 to 6) - HourID (0-23) - ClassificationValue So I cycle through all the events from Customer X, retrieve weekday number from the event date and the Hour from the...

Here is a really nice example of using XPath to work with XML results https://myengineeringworld.net/2013/08/custom-vba-trip-distance-function-google-directions-api.html