Search results

  1. C

    Please Help With This Code

    Hi, No it did not work as now only the data after which the Print statement comes is replaced but the first record stays the same. Now the output is |001#AKA|STO| |001#WAR|STO|
  2. C

    Please Help With This Code

    Hi I am trying to change the values in the txt file now but having this problem. Can you see what could be the problem. I read a txt file which looks like this |001#AKA|002#STO| |001#WAR|002#STO| After running the macro it should look like |AKA|STO| |WAR|STO| Instead it looks like this:-...
  3. C

    Problem with Loop

    Hi Thanks for your help. The problem with this code is also the same as before as the program reads the first line in the file and finds 001# and replaces it but next to it is 002# but it does not replace this. On the second line the 001# is not replaced but 002# is replaced. And also extra data...
  4. C

    Please Help With This Code

    Hi, Thanks very much it worked. I have another problem.can you please help. I am opening a text file and finding a string say 001# till EOF and then replacing it. Once the replacement is done I want to find another string say 003# in the complete file and replace it with another string. This...
  5. C

    Problem with Loop

    Hi, I am opening a text file and finding a string say 001# till EOF and then replacing it. Once the replacement is done I want to find another string say 003# in the complete file and replace it with another string. This way I need to find around 15 strings and replace them. And in the end...
  6. C

    Please Help With This Code

    Hi Thanks very much for the code. Everything runs fine but the table is not getting the new values? The table still has old values. But when I debug and see each line everything looks fine. What could be the problem?
  7. C

    Delete all the characters on the left of # in a recordset

    Sorry Mate. Please ignore my previous posting. My fault I made the changes and put the correct field name. The program runs fine but the values in the table is not changing. I have put Msg Box to see all the process and it looks fine. but the values in the table is not getting changed. any...
  8. C

    Delete all the characters on the left of # in a recordset

    Hi Thanks very much The code looks great but I am getting an run time error 3265 that Item not found in the collection. The error is on line fieldvalue = rsMyRS!FieldName.value Here is the code Sub main() Dim ws As Workspace Dim db As Database Dim rsMyRS As Recordset Dim str_rep As String...
  9. C

    Delete all the characters on the left of # in a recordset

    I put the name of the field in the field value eg field1. The program runs but nothing changes in the table
  10. C

    Delete all the characters on the left of # in a recordset

    Thanks Mate With field value you mean the column name of the field or the values in the field like 001#AKA.
  11. C

    Please Help With This Code

    Hi, I have an access table with records and each record has an entry like 001#AKA. I want to remove all the characters on the left of #(inclusive #). I am using this code as an Module in Access to find the # and then doing the replacement. But it seems to be going in a loop and not doing...
  12. C

    Delete all the characters on the left of # in a recordset

    Hi Thanks for your reply. I am using this code as an Module in Access to find the # and then doing the replacement. But it seems to be going in a loop and not doing anything. Please can you let me know what could be the problem. Thanks Here is my code Sub main() Dim ws As Workspace Dim db...
  13. C

    Delete all the characters on the left of # in a recordset

    Hello, We have an access database where we import daily data via txt file. The data is seperated with pipes. Each record has a value and before that value we have a number like 001#. This is in all the records. We have about 250,000 records in each file. I tried to replace the characters in...
Back
Top Bottom