Search results

You need to add the = sign. And I think you should also add me.orderbyon = true

And you should rename your command buttons to something meaningful, having command170 and 171 only complicate things

Ok, after many failed attempts, I found another solution to my problem: DCount("*", "tblKpiReporting", "Month([ReportDate]) = " & Month(Date()) & " And Year([ReportDate]) = " & Year(Date)) This is working fine for me.

Hi Guys, Based on this idea, I am building a similar function. Instead of sending a report weekly, I would like to do it only once per month. I am now building the check to see if the report from this month was sent already or not. If DCount("*", "tblKpiReporting", "#" & Format([ReportDate]...

Brilliant, thank you Arnel. Customized it a bit, but this is working perfectly! Public Enum RdwDataset rdwVoertuig_informatie rdwAssen rdwBrandstof rdwCarrosserie rdwCarrosserie_specifiek rdwVoertuigklasse End Enum Function GetVehicleDetails(strPlate As String...

Thank you Arnel, that's indeed another approach. But if possible in any way, I would like to include it in the function call. In the end I want to enter 1 license plate and find different bits and pieces of information from several datasets. Combining the vehicle information, with fuel...

Hi all, I'm trying to create a custom function to return vehicle information, using an webservice. When calling the function, I want to provide 2 parameters: 1 for the vehicle plate number and 1 for the dataset type. The online service provides different datasets for different kind of vehicle...

Or maybe try to replace certain words in the template with your form fields. So in the template you write %meetingdate% Then use the replace function on that string to replace %meetingdate% with me.MeetingDate

Thanks for the help guys. You're method for selecting the required node helped a lot. I have a working solution now. It currently only prints to the Direct window, but now I can approach the individual results and finetune the function according to my needs. For the record, here is a copy of...

No, thanks for your response, maybe handling it as JSON is much easier... The split function sounds a lot easier then all Node stuff...

Thank you, that does look interesting indeed. I did already find one issue. Apparently the default response is indeed JSON, they have an additional optional parameter that specifies that it should output XML instead... I will try to fiddle some more with it

Yes I understand that, the current URL will work, it will return the Error response. As mentioned, this response I also want to process, it's example result 1. Yes, the site explains clearly how the webservice works. And it is indeed working fine when I enter the url in de browser. The working...

Hi, The URL is visible in the strQuery variable. The URL works and returns the lines mentioned below my code. And yes, I have a valid key. It's just the code of my function that is not working. I'm not sure if it receives the data at all and if it does, how to approach it...

Hi all, I'm trying to create a function that converts a zipcode with house number to an address. I found a web service that does this, but I don't get the function to work. I don't understand how to parse the XML result. My current code (which returns nothing) is: Function findAddress() As...

Yes, you could add something like this to the Outlook button on click even: Const cDQ As String = """" Dim strSQL As String Dim strActionType As String strActionType = "E-mail button pressed" strSQL = "INSERT INTO " _...

You could add an action to the 'Send' button command. For example by adding a new record with date, time and username to another table, for example 'tblEmailSend'

Yes, that's clear. That's why I created this Do While loop. It doesn't matter if it find a duplicate, as long as it detects it, generates a new one and check again. I think the problem is solved with the Randomize addition though. Thanks again.

Hi Jdraw, It's a customer number that customers can use refer to when they contact our company. The SSE part is a reference for us, that identifies the product-group. I don't want to give my customers any insight on the amount of customers I have. That's why I don't want to use the Dmax...

Aha, excellent, thanks guys. I'll see if this improves the results.

Thanks for the reply. It triggers the 'Duplicate found' line very often. Usually it does find a random option, but I have the feeling the code is not good enough. I didn't use the Dmax function because I prefer having a random result.