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

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

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?

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

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

Hello, I export the access report to excel via access VBA(outputo method) and then I am opening the file from access to add the data validation list in the excel file. Below is the code -Code runs fine and it shows no error but when I check the file, nothing happening. I want to have data...

Hello All, My requirements is to send the alert messages with the approaching due date on every Monday of the week. I am able to send alert messages on Monday. My Problem is: How to send alert messages on Tuesday if Monday is Vacation. Is there a way to do it in access? I don't have much...