Search results

Hi guys, I am creating a function to convert a position from DMS (Degree, Minute, Second) format to DD (Decimal Degree) format. I couldn't find anything good on the web, so I'm now making my own version. The function below is working fine, except for the fact that the DMS parameter normally...

Excellent, been struggling for hours on this... Thank you very much for the explanation also, this makes sense indeed. =DCount("[EditRecordID]";"tblActionLog";"[SourceTable]='tblCustomers' AND [EditDate]>=Date()")

Thank you Minty, but no, it doesn't change anything, it returns 0. So not an error, but 0. When I look at the table directly, the date is visible like this: 12-10-2016 11:22:53

Hi all, I can't get this sorted. I have created a report where I want to display the total number of records that were created today. So I have set the following control source for my textbox. =DCount("[EditRecordID]";"tblActionLog";"Format([EditDate];'mm\/dd\/yyyy') =...

Yes, I think that's it indeed. We are in the process of changing servers and upgrading the workstations to Windows 10 and Office 2016, so I decided to wait with splitting until this is finished. Meantime I'm implementing these various bits and pieces to improve performance on a split database...

I agree CJ, that is what I have and I guess that's part of the problem. But what I don't understand is that I don't have these speed/network related issues in the non-split configuration. The non-split version is on the same network share. I believe it has to do with opening and closing the...

And I would definitely take enough time to properly test your Frontend / Backup setup. I have been running a non-split database quite successfully for years, but after reading everyone's advice I decided to split my Database. It became very slow and just unable to work with. I believe there are...

Excellent, yes this is the correct response. In my production code I just add all tags to an collection object, then you can just retrieve the streetname for example from the collection

I think you enabled the domain limitation setting in your account, it should be set to 'nee'

You should just call the procedure like this: ?GetAddress("1234AB","30") That should print the results directly in your immediate window. I don't know about that domain, I don't have it set and it's also not required.

I checked and indeed you can link your API Key to a domain, so only calls made from the specified domain are accepted. You cab ignore that bit, I don't have it set either.

Ahh right ok, but then you need to have a local file and follow the prompts. I was hoping on a solid automated XML importer, and preferably one that handles XML HTTP responses. Anyway, not related to this thread

What xml reporter are you referring to? Is this included in Access?

Oh and phone number should be: +31622464358 (just a random example)

It says you didn't fill all required fields, a valid Dutch zip code is '1101 BD' for example. 4 digits followed by 2 letters

In fact, the code posted above works with postcodes.nl web service, not postcode.nl The first one allows for 100 free checks per day, the second one not... Obviously you do need a api key, but it's free to request one... The code posted works excellent, I have successfully implemented the...

Not able to test it right now, but something Iike this should work. Private Sub Reminder_Click() Dim Outlookapp As Outlook.Application Dim OutlookAppointment As Outlook.AppointmentItem Set Outlookapp = CreateObject("outlook.application") Set OutlookAppointment =...

According to this link: https://msdn.microsoft.com/en-us/library/office/ff861308.aspx You can simply use the ".recipients.add" method for inviting other users to your meeting.

There is a function called Round() available, it's made to round an amount to a specified amount of decimals... http://www.techonthenet.com/access/functions/numeric/round.php

Try it the other way around? me.orderby = "fieldname" me.orderbyon = True Should work with On Load event...