Search results

Thanks, pbaldy. It didn't work!

Hi, one of the fields in my query is calling a function which returns a string value or null values. I want to exclude records that has null value in that field. I do have alias name to that function for that field. This is how I am writing the where condition in the query. where aliasName>...

Hi Ridders, Thanks for the quick response. That's a great work. I have managed to parse JSON data but am not sure how to create new rows for second address in the array. I am not sure how to write query in access to insert new row after parsing address field if there are multiple addresses. So...

HI, I have a query which has few temp columns that call one of my functions. What the function does is, it takes a field value for example address field is passed into the function, and then I am using vba json parser to parse address field and then store appropriate value into the calling...

Arnelgp, so basically, I am not sure if the field 'Street' has been created correctly or not in the query design view. There is no field called Street in the query, I have manually created one by clicking insert column in the query design view and gave a name.

Oops, my bad. nv(0) contains "street" and nv(1) contains street address. I am not sure why it is still failing after this step. :banghead:

Thanks Arnelgp, It shows a double quote in nv(0). Like so: nv(0)=" Each field and value are wrapped in double quotes. fld(0) "street:43 xxx rd" should I stripping those double quotes?

Thanks, Paul. Here is my code snippet. Public Sub aaaRunParser() Dim r As Boolean r = ParseAddresses End Sub Private Function ParseAddresses() As Boolean ' Purpose: ParseAddresses - split hairy addresses On Error GoTo errorexit Dim result As Boolean result = False...

HI, I have been working on a module to split an address field into multiple columns. I am fairly knew to ms access but gained some knowledge in the past couple of days and I do have programming knowledge. I have written a couple of functions to split an address field which has street address...