Search results

Thank you for the live saving support always. while calling this function, got the error "argument not optional" as below. dont know how to resolve it.

Having few files with different extensions (pdf, doc etc) in a folder. Below sequence to be achieved. rename all the files in the source folder. as Me.textName with a random suffix for multiple files but all names should start with Me.textName without affecting the file type (random suffix...

thank you. the problem solved with arnelgp and your inputs.

Thank you for solving the problem I had. Much appreciated. I will update the header of this thread to reflect appropriately.

Thank you arnelgp. You saved my day, (maybe this year). Now the code works as intended. However one peculiar thing I noted after executing this. 1st instance it moves the file correctly. while at subsequent attempts somewhere the file name misses the ".", so the file is not readable. Maybe a...

Thank you, Gasman. I added a "Next" immediately after "End Select", code compiled successfully. however no action happened still, the files are in the folder not moved. I don't know where I am making mistake. Hope experts here could guide me. copied the code into a module and only changed the...

Thank you for taking the time to support me. below error appeared. anything to add?

Thank you arnelgp. you are always helping me. following this would like to ask your help how to paste the file with a new name (to add some suffix) if already exists in that folder. I have code to move but only moving if the file doesn't exist in the destination. which function to use. thanks...

I tried looking at multiple places, but could not file specific information. How to find a file if exists without specifying file extension (like .pdf, .txt). Tried the below code found in this forum but an extension is required. If Dir("C:\YourFile.xml") = "" then msgbox "file does not...

I tried adding = sign, but now no records returned; earlier without =, all records were returned. I will wait for your availablility. Thank you very much for your time and kind replies.

Tried the below without success. Anything am I missing below?

Instead of creating duplicate forms and queries, we could use the "Navigation Where Clause" in the navigation form. I used this successfully when the filter parameter is always fixed. However, could not able to pass through the textbox value in the main form to the syntax successfully. Below...

Instead of building a crosstab query from another query having a calculated field, I created a make table query and done the crosstab from the table. it works as intended. I believe the issue with calculated field query. Had a workaround, but helps for me.

Thanks for the reply. It does return the date field and in the date format only.

while creating a crosstab query throws below error. The source is another query having a calculation. please help how to rectify this. Crosstab Query PARAMETERS qryKPIDataEntered.KPI_Code Text ( 255 ); TRANSFORM First(qryDataSequence.Calculation) AS FirstOfCalculation SELECT...

Just to update that a simple method to solve this problem - accidentally found. Sharing if useful to anyone add the field one more time and format it to the desired (in this case "YYYY/MMM") empty the crosstab box ( nothing to select- no "row heading" or "column heading"), leave it blank. sort...

this solved my problem. thank you very much for writing the syntax as well.

tried that as well earlier. below is the result but not in ascending order by month.

thanks. below is the error received. tried "yyyymmm" also, the same error.

Having a problem while sorting the custom field (YYY-MM). checked many forum posts but looks complex for me. Please help me to sort based on the month and year. TRANSFORM Count(qryAll.ArrivalMode) AS CountOfArrivalMode SELECT Format([qryAll].[ArrivalDate],"yyyy/mmm") AS [Month] FROM qryAll GROUP...