Recent content by jack555

how to sort a field populated by expression? Created a filed TextLength using LEN([fieldname]; now need to sort the TextLength column by ascending or descending. However it is working. Please help.

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

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

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

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 =...

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...

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

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

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...

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...

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.

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...

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...

Exactly. my problem solved.

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.