Search results

HI! all i am trying to use the below select statement to auto-fill the data if it meets the criteria. User will select SOLid from combobox dropdown and IDSRef field will get auto-filled from unbound fields (txtPQR....etc) Below is my statement Private Sub SOLid_AfterUpdate() Select Case...

Namaste crystal, this is what everyone is following nowadays. Shukriya Aap Ka, Aap ne Aapka Kimtye Samay Diya (Thank you very much for giving me your precious time) Coming back to this thread. I am so overwhelmed and dont have enough words to thank you for the knowledge and insight you have...

Thank you crystal. I will close this thread as solved.

Thank you very much crystal. i blindly followed your instructions without any challenge and was able to get it working. I will try to understand your code but honestly it is difficult for me. But will make sure i use this learning in my next project. Yes you are right, i have been here for so...

Thank you crystal for the detailed step by step procedure. I will try this and let you know the result.

Thanks, crystal. I have refreshed your code and replaced with the earlier code. My only question is, do i need to put the code behind a form OnClick event and run it. if you can post the updated db with the change will really help. Thanks

HI! crystal. below is my end goal. If you note, MachineId; AccountNos & TransactionRef is constant for the first records as there were 3 splits in MICR_Line and 2 in the next one. MachineId AccountNos TransactionRef New_MICR_Line E4003302 1012345678901 E4003302200884777...

My Name is Mahesh and i am from India

Thanks crystal, for the code. it removes the unwanted characters from MICR_Line. Sorry not mentioned the end goal. i wanted to further split the MICR_Line and limit it to 25 characters anything above 25 moves to next row. Is this possible thanks again

i have found a function given my MarkK which i have placed in the module. I am able to remove the unwanted characters from the string. Now i want to move each split character to next row. i have placed updated db v1 Any suggestions pls

HI! i have attached db just for better clarity. Can anyone here help me pls.

HI! All, Hope everyone over here are safe. I have a table with 4fields: MachineId; AccountNos; TransactionRef; and MICR_Line i want to split the MICR_Line field into multiple rows keeping the MachineId; AccountNos & TransactionRef field constant. MICR_Line text contains below details...

Yes, its been some while now. Apologies for the late response.

HI! isladogs, i too tried but it did not work of me. i am still getting runtime error 3219, Invalid operation

Thank you for your response My table is at the moment all by itself, there is no relation with any other table. I have update db post 5 for reference

H!! Guys i tried using this to delete the data from the table and it gave me below error data to delete was through delete query with start & end date prompt any suggestions, Thanks

Rightly, there is no alternate for learning. I have tried to learn this but its difficult to understand from the middle, i need to understand from the beginning like kindergarten. Yes, before posting any thread i look for Google, everywhere for an answer and some of you guys are amazing who not...

Thanks Gasman for the patient and explaining me this. Putting the punctuation in the right place is very important. i have the below working code. Private Sub MICR_Scan_BeforeUpdate(Cancel As Integer) Dim strMIRC As String Dim strDate As Date Dim strCriteria As String...

i am sure the solution is in front of me, but as i told you i have limited vba knowledge. I am confused at the moment and with the last code that you provided.

i have changed the code as strCriteria = "MICR_ndt = '" & strMIRC & "'" And PDC_dueDate = strDate i remember you mentioned to put # for date #" & Format(Me!Textbox.Value, "dd/mm/yyyy") & "#") strCriteria = "MICR_ndt = '" & strMIRC & "'" And #" & Format(Me!PDCDueDate.Value...