Recent content by Rosana

HI, I am writing a query which split fullname field into separate columns(firstname,middlename,lastname,title or suffix). Here is my query so far and it seems to be working fine except for the ones with title or suffixes. Query: --------- SELECT Participants.[Full Name], GetNamePortion([Full...

Thanks arnelgp. Yes, I do have a unique id field and a full name field in the query.

Thanks a ton arnelgp. Very well written. I see you have put the parsed values into a new table called tblMain. Is there a possibility that we can append these parsed values into a query directly instead of table?

Awesome. I'd appreciate it greatly. Good Night.

I am getting this error. Object variable or With block variable not set Here is how I am calling. Option Compare Database Public Function accessJsonCopy(strJson As String) Dim json As clsJSON Dim var As Variant Dim i As Integer json = New clsJSON json.Parse (strJson) For i = 0 To...

Thanks arnelgp. Where do I call this class? On address field from design view? I am a beginner and please excuse if its an obvious question. How about strJson with multiple array items? How to insert a new row based on the unique id? My source is a query(join of 3 tables) and not a table.

I am calling the function in immediate window for testing purposes. I have also placed breakpoint in the code and when it hits this below line, it goes back to the beginning. No error nothing. Set rst = db.OpenRecordset("Copy Of Mail Merge", dbOpenDynaset) 'hits this line and goes back to...

HI, I am trying to use openrecordset to access query fields but nothing happens. What am I doing wrong? Public Function test() As String Dim db As DAO.Database Dim rst As Recordset 'Dim qryfld As DAO.QueryDef 'Dim fld As Field Set db = CurrentDb() Set rst =...

Hi, I have a field with multiple values in it(for ex: address with street,state,zip etc) which is in JSON format. I need to split this into multiple fields. Some of the columns may have multiple addresses also. Those needs to be created in a new row. any ideas would be appreciated.:banghead...