Search results

Hi Alan, Sorry I did not get the solution on the blog. Not sure if that link is correct. If you have the sample code then pls post it in this. Thanks

Dear All, I need to export multiple queries into a single spreadsheet in different range of cells. Means one query need to be exported from B2:E2 and second query need to be exported from B10:E10. In this way need to export 18 queries' result into one sheet only on different name range. If...

Dear Experts, I need your expert advice. I have an Access database which imports the data from different sources. After importing and processing the data I need to prepare the attached dashboard by Team (for 13 teams) which is in Excel. Each team has 2 to 10 bankers. Data need to be...

Thanks for the reply. But this is not table names or datatype issue. Because if I run the same code in debug mode it works. I suspect data is not imported while excuting update SQLs. Cause I'm importing the excel file in another database which is taking some time to refresh in other database...

Hi Mark, I mean records are not getting updated. Below is the code: objAccess.DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _ tsWeeklyMIByProd, Input_Dir & "\" & InputFileName2, True, File1Wks1 & "!" strUpdateSQL = "UPDATE " & tsWeeklyMIByProd & " SET ReportingMonth = '" &...

Just to clearify. My VBA is in different database and actual data is in different database. I don't think this should cause the problem as I'm importing / selecting / inserting and doing other activities in this database only and all those are working fine.

Thanks Mark. I have tried this already but did not work. When I run the code in debug mode it works but in normal mode it does not. Any other suggetion to force exceution and to make sure update statement is working fine. Thanks Ria

Hi All, I’m having problem in updating the Table using VBA. I have imported the data from Excel and immediately updating the Reporting Month in imported table. This update statement sometime works and sometime does not. Quite weird :banghead:… Below is the VBA code I’m using in MS Access...

Highly appreciate your help on the above issue. Regards Ria

Dear Friends, I'm getting below error while using MS Flex Grid "Run time error 438 object doesn't support this property or method" I have registered "Microsoft FlexGrid Control 6.0 (SP3)" but still getting this error. Below is the code I'm using: 'MS Flex Grid Control used to create the...