Search results

Hi Good Morning, It retruns Null values in filed if we use above code. Can you check once. Regards, Hari

It is Run-time error '5' Invalied procedure call or arument. End Debug Regads Hari

if the data filed "L1" contains "-" between the text like "Broke-Hop" or "Dude-Like" it stops the macro. Regards, Hari

Hi vbaInet, There is another bug found while useing with large data.. as attached.. Can you try to solve... Regards Hari

Yes.. you are correct.. I would take date from another field, (other field in mm/dd/yy format) not from this..this function also skip's the date where ever it in splitted fields.. about your sample file..I am checking with... Regards, Hari

Hi , it is fixed foramt, as mm/dd/yy

It's Ok. I have two queries.. query :1 SELECT FBD.L1, FBD.L2, GetCSWord([L1],1) AS Expr1, GetCSWord([L1],2) AS Expr2, GetCSWord([L1],3) AS Expr3, GetCSWord([L1],4) AS Expr4, GetCSWord([L1],5) AS Expr5, GetCSWord([L1],6) AS Expr6, GetCSWord([L1],7) AS Expr7, GetCSWord([L1],8) AS Expr8, "%"...

You can Find in atached Sample.zip file contians sample Access file. please check. Regards, Hari

Hi, It concatenate all the fields, except % and Dates, it gives final output in filed as "Name", it does not concatenate few cloumns in filed "Expr10" whre it conitans some text. Please refer filed "Expr10" and "Name" you can understand. Regards, Hari

Hi All, I am useing below code to concatenate the different fileds, omit if columns contians % as well as dates. A small bug found in the code, where the total filed [Expr10] of data unable to concatenate in filed as "Name" (query: 1_1) attached screenshot and sample dbf. can you help in...

Good Morning, I am useing below code to download the comma delimited text files to access table. Function Load_Attendance_Data() Dim NextFile, ImportFile, FileCriteria, ctr As Variant Dim DB_Path As Variant ' get the DB path DB_Path = "C:\temp\" FileCriteria = "C:\temp\" & "*.txt" ' create...

HI All, Can any one help to my query I have a table with coloumn called rate, i want to update that filed with percentage as per below criteria. 1. If the rate contains 4th decimal that's rounded to 3rd decimal (Ex. 1.2564 as 1.256 or 3.5689 to 3.569%) 2. if the rate does not contian second...