Search results

Thanks MajP, i will try if i can send this across or atleast try to replicate something close.

Hi I have checked the line A as you mentioned. If I keep my cursor after Acct Name and hit right key on keyboard. It moves to next row exactly where you placed the B. The second example is also another instance which in my text is on Srl No 9. Between the A and B there us a row space after the...

HI! MajP, now it gives me another run-time error 9, Subscript out of range. The error has moved to " AvlBal = tempArray(0) i am not able to identify the reason

Hi! MajP, Apologies, couldnt respond to you earlier. Thank you for the code, i have amended the names as per my text file and tried to upload the data. Got the following run-time error '9' Subscript out of rang After i upload, only 11 records get uploaded before showing the error and highlights...

Thanks DBGuy, figured out the below which changes the ScanDate for only SourceA NBDt: IIf([CaptureTime]>"10:00:01" And [Source]="SourceA",[ScanDate]+1,[ScanDate]) Will close the thread for now.

Thanks for the patience and time, I can see it changes the date when the CaptureTime is >10:00:01 but it changes all the other source (A to G). I only wanted SourceA to change when the time is >10:00:01. Do i need to mention SourceA somewhere in the below code that you provided.Hi. If your...

Pls have a look at the DB.

HI! DBGuy, sorry for the confusion and incomplete information. Actually it pertains to the same code i have table: tblTemp SrNo AutoNumber ScanDate Date Source Text CaptureTime Text NewTime Text BusinessDate...

Thanks DBGuy & CJ_London both the solutions have worked for me. The query provided by CJ_London is giving me the same result as DBGuy I wanted to add the below criteria to the vba code. In table, "tblTemp" has fields "BusinessDate" and "Source" If the SourceA CaptureTime after 10:00:01 then...

HI! i am not getting correct result. Below is the code. Is this correct way or something more to this. Public Function GetNewTime(CaptureTime As Date) As String Dim strTimeRange As String Select Case Hour(CaptureTime - #12:00:01 AM#) Case 0 To 6 strTimeRange = "24:00-07:00" Case...

Thanks DBGuy, will give a try.

Thanks DBguy for the suggestion. I would opt for custom function, how can i write one.

HI! All I have IIf statement in query which is working fine for 13 columns to insert the NewTime data in tblTemp. But when i add the 14th IIf statment i get below error. "Expresssion too complex in query expression......" Is there a restriction on IIf/Switch expression. Below is my query...

Thank you so much MajP for looking into this.

Thanks MajP, enjoy your weekend.

HI! MajP, i am able to get most of the reports except the below which is somewhat similar to my 1st project. This report is continuation of that project, its called as Validation2 It contains all the data of the 1st report minus the modified transactions and its in different text format I have...

Thank You MajP, i managed to get this working. i will check all the other reports

HI! MajP, i unable to identify the difference. I have amended the field names Coll. Ref. No => Coll_Ref_No SOL ID => SOL_ID COLLECTION CODE => Coll_Code CURRENCY => CCY but i am still getting the same error

Sorry MajP, i was matching the text with the import. I didnt realize the mis-match. I will re-check and update you shortly

HI! i have added the code and getting the error on the text field, but i am not able to identify the exact reason. The Instr_No is a text field and not a Number, will this be an issue. I have attached the text file and add tblC_ILR to the db