Recent content by jack555

  1. J

    Solved Rename Folders in Bulk

    This solved the problem. Correct usage of delimiter in the earlier given code solved it. Thanks to Ranman256 and CJ_London
  2. J

    Solved Rename Folders in Bulk

    These 4 are samples to understand the scenario. I have more than 2000 folders to rename in a short time.
  3. J

    Solved Rename Folders in Bulk

    the names to be changed in the given table below. Already included in my first question itself. tblNameChangeSource Old Name New Name 1234 ABCD 2345 EFGH 5678 SCHO 8937 MIBZ
  4. J

    Solved Rename Folders in Bulk

    Thanks for the instant reply. I used the code as below in a Form command button. However, no changes were made. Am I doing anything differently? Private Sub Command36_Click() 'Variable declaration Dim sFolder_OldName As String Dim sFolder_NewName As String set rst =...
  5. J

    Solved Rename Folders in Bulk

    Have to rename the folders in a location. New name as per data in a table below. Sample Data Old Name New Name 1234 ABCD 2345 EFGH 5678 SCHO 8937 MIBZ I managed to get the code for renaming the folder, however, this works for one folder only. I want to rename the folders as above...
  6. J

    Solved Met or Not Met - Group By with conditions

    Exactly what I was looking for. Always you are solving the problems in a breeze. You are a star.
  7. J

    Solved Met or Not Met - Group By with conditions

    Sorry, edited the mistakes in question. Please check now.
  8. J

    Solved Temporary Table in Shared Front End

    I did as per your second advice. bound the form to the destination table. The records having the status "draft" until clicking the "save" button. So excluding the records with the draft flags for other purposes. Now successfully achieved the intended result without any issues. thank you...
  9. J

    Solved Met or Not Met - Group By with conditions

    Having a scenario where to auditors review and score different questions under few categories. I would like to mark the category as per the below criteria. if any of the questions in a particular category is "Not Complaint" then the category is "not compliant". If all the questions in the...
  10. J

    Solved Temporary Table in Shared Front End

    I agree with this. However, there is a challenge to implement individual copies for each user. Users float in every department and they always not copying the front end to their location. I will try to implement your advice, but need a workaround as well.
  11. J

    Solved Temporary Table in Shared Front End

    It's a survey table. user will answer certain questions and at the end of the survey, the value stored in the temp table should be transferred to the original. I made this to avoid inserting an incomplete survey in the original table. the reason it is not unbound is, there is an option group...
  12. J

    Solved Temporary Table in Shared Front End

    I use a temporary table to store values from the form and when the form closes, transfer temp data to another table and clear the temp table. This works fine if one user working on it. If multiple users working on the same front end, then throws a tricky scenario. How to solve this scenario...
  13. J

    DSum/DCount - Number of Unique records

    Exactly. my problem solved.
  14. J

    DSum/DCount - Number of Unique records

    This counts all the records of Data.Category. I wish Category should be counted only once for each group of Data.ItemName. Suggestion by @June7 works fine. out of curiosity, I am thinking about how to make this work in a single query.
  15. J

    DSum/DCount - Number of Unique records

    Yes, this solves my problem. Thank you very much. PS: updated the question to correct wrong info about "snack"
Top Bottom