Search results

Thank you Mike for responding. I've attached 2 pictures. For example, for EventID = 2 When we have the start date 15.01.2008. the "No october meeting" is in october. But if we change the start date to, for example 15.05.2008. the "No october meeting" is in february 2009. Because the...

Hello, I've found a great solution for recurring events calendar from Allen Browne. It works perfectly untill we have exceptions in tblEventException and we change the start date of the event. Because it is coupling to the InstanceID when we change the start event date it fails. The data in...

Colin, sure you can use it. And of course, we can continue this discussion via email. My email is davor.geci AT gmail.com Thanks

Looping is because I'm going the data day by day, because if the user wants to get all the data (90 days) then this would be a huge file. 90 days for this sample is around 3 million of records, and in real situations, there would be a lot of more data. Do you think that I should go with all at...

Hm, because I'm looping through every value before adding the record to a table, maybe I could create a long or double field and convert and store this timestamp data into milliseconds value, what do you think? This would be a very big number, would it speed up or is this not a good approach...

Thanks guys for responding. I'm not thinking to only get one record. But all the records, because the Azure Application Insights retention time is 90 days (after 90 days the data is removed). So because of this retention and also for users to be able to create their own reports and queries I'm...

Hello guys, I'm creating a desktop app in Access to retrieve a lot of data (millions) from Azure cloud using Rest API. I know that linking to SQL server would be the solution. But wanted to know if there is a way to speed up the query for getting the last record in Access table. TOP, LAST...