Search results

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.

Change the code to With objBook1.ActiveSheet and got the error on line .Range("A5:G65000").ClearContents Run-timer error '91': Object variable or With block variable not set

Thank you both for replying. I modified the code as suggested but i am still having problem in opening the file

Below is the code where template file File1.xlsm is loaded with new data and saved it as File2.xlsm and close the File1.xlsm without saving it. But I am having two problems: 1. Once I try to open the File2.xlsm after database finish the process, it gives the error: "Excel cannot open the file...

I want to create the separate files and saved it as template 1, template 2 and template 3

My criteria is to generate the multiple excel files if the records on the table exceeds more than 400. Basic steps are: 1. Check the counts of records in the table 2. Open the template and delete the existing data 3. if counts > 400, grab above template and populate with 400 records and save as...