Search results

Looked at this; seems more advanced level for me. My concern is a simple task. There are certain items due on each user every month. These due items are already filtered and available as a query. Now, how to send reminder emails to each user with the items only due for them? ID Task User Due...

Replace(me.txtName," "," ") above code can be used to remove double spaces between two words in a string. However, if there are three or four spaces that randomly occurs, how can we strip all these extra spaces and keep only one space? Tried adding nested "replace" without success. Any...

It worked like a magic wand. Thank you for helping. You are a star.

It works the intended way. However, strips some of the characters in the first part of the file after renaming which had no prefix. In the below example, characters "test file" stripped for the file which didn't have the prefix. Before: After:

so, means it's not possible to exclude the items already with prefix. better to leave this condition?

Hi @arnelgp I tried this code, but no change in action. It renames all irrespective of the prefix name already present or not. Kindly help.

Thank you. I will try it.

Having a task list due on every user. Would like to send a reminder email to the respective users about their pending item and summary with a click of a button instead of sending one by one. Is this possible to achieve? kindly assist.

@arnelgp, you are awesome. Earlier you provided me with the code for a similar scenario. Appreciated your support to the community members. always clear detailed code for any issue.

Tried running the code, but no change in the outcome. It renames all the files in the folder including the ones if the name already matches with prefix.

If Me.txtName already exists in the first 8 digits of the file name then adding txtName as a prefix is not required

Hi arnelgp, in this code provided earlier, how could we add an exception not to rename if a condition met. fncRenameFiles(FromPath, , , textName & "_"). If Me.txtName already exists in the file name then adding txtName as a prefix is not required. Kindly help if possible.

Thank you. I will move it above the tabs. I am a beginner to MS Access, could you please refer me to resources about building custom menus, if possible.

This idea works, I tried. Is there any other workaround to resolve this while keeping both control closer?

Attached the db. frmHistoSearch is the main form. "Enter" activity key in the blank text box takes to the next control. but "enter" key activity while some text in the textbox makes the db crashing. Please help to troubleshoot this. thank you.

Controls Textbox Search button Textbox - no code any event Search button - is acutally a navigation form with a query linked to search texbox. (first form in navigation form is hidden to show blank screen on load). No code on the search button as well. scenario - when the text box is empty...

A search box is linked with a navigation form to filter the items. After inputting data in the search text box if I hit the enter button (habitual) the entire MS access not responding and crash. What would be the underlying reason? how to avoid this crash?

How can we use the default path without specifying it? each user name has a different default path for downloads. sorry for the late reply.

Yes, I follow ExportWithFormatting. However in the output file either I have to leave it blank or specify the full file path with name. cannot specify the name without a file path. is there any way to achieve this via macro?

Via macro or VBA we can specify the file name with the location for the query or report export. I am exporting via macro but now the query or report picked up as the default name where the user can change while saving it. Question: in macro how to specify the export file name without specifying...