Recent content by Jovial

Hello Everyone, I have a passthrough query where I have to pass the search criteria as "IN" using access VBA. All the search criteria are stored in the field "Code" in the table "Area" in access as: I can pass each code value in the passthrough query as a loop and execute the passthrough query...

Thank you for replying. I spent a lot of time on this but still could not figure out.:banghead: Waiting for your code :)

Any help please

Thank you for your reply. I want to do formatting only if there is a match between the cells in column.For this I have to check each and every cell in column E. For eg: I have data in Column E AS shown below Column E 1234 678 678 890 1234 First find the match in Column E then only format so...

Hello, I have a excel file generated from access. After exporting i have to do some formatting which i tried to do though excel automation. I need look the each cell value of column E in the same column. If it exists highlight and make it bold. Here is my code snippet. 'Find the last row...

Hello, I have a query in access which i export to excel via 'Output to' method and result look like this: But I want the result like: I want to create the function (modifyExport) in access vba which will be called after exporting the file and format the excel file I am not very good at VBA...

nope -Same error

My table name is CommentItem Select Replace(Left([CustomerName], Len([CustomerName] - 2, " ") from CommentItem error is still in the function. It is showing error in " " part

Replace(Left([CustomerName], Len([CustomerName] - 2, " ")

What is LAST and FIRST here? Data are present in column CustomerName as CustomerName WILSON, DAVE D GROVER, LAURA A

I changed the name to my column name 'CustomerName' and it gives me error as: the exprerssion you entered has a function containing the wrong number of arguments

I have data as WILSON, DAVE D GROVER, LAURA A I want as WILSON,DAVE GROVER,LAURA How do i achieve this in access query?

I have not use the FileCopy function till now and there are macros and code behind the template.

I use old code in 'with' statement as: With ActiveSheet 'Clears the current contents in the workbook range .Range("A5:G65000").ClearContents 'rst Copies the recordset into the worksheet .Range("A5").CopyFromRecordset rst1 End With And I modify the code for 'Save as' as...

This code is behind the button on the form. Upon clicking, it is supposed to load the data in the template and save it as different name.