Search results

I want to check if we should close backend database after every SELECT / INSERT / UPDATE OR can leave it open and should close when user close the application. I'm checking if all databases are available using below code. If any of database is not available it'll prompt the user. If...

Hi Pat, Thanks. I'm pretty much new in this that's why asking experts help. Once you can provide some guidance then I can take it from there. Need some sample code e.g. using different queries coping that into different cells. Tried to find the code but did not get any useful sample code.

Hi Zak, I need to copy the data in each cell which is coming from different SQLs. Data need to copied approx 1360 columns. And in this way I need to generate 15 Excel files. Is there any best way to do this?

I could not find any function in Excel as well to hide the rows dynamically if there is no value.

Hi I have one front end application which in MS access and few backend databases (MS Access). I'm able to export the whole table from one database to another database using below code. But my issue is I want export only selected columns only and based on condition (e.g. Date > so and so)...

Any solution?

Thanks Pat for all the guidance. Users need these in Excel as well cause they need to adjust the numbers in excel after the output generated. Can you please let me know how to create this dashboard dynamically? Pls guide me with some sample code which will be really useful.

Thanks Pat. Building this in report format will be bonus. But need to be generated in Excel Format because these will be reviewed by Middle Management / Top Management to check the performance of Bankers, Team and Region. They carry the printout of these Excel files and discuss in Management...

I need to hide these records using MS Access 2007 VBA

I am exporting data from Access to excel, once all the data is exported into multiple sheets. I have one Master Sheet which has formula / reference to other sheets. I want to hide those rows which do not have data but contain formulaes referencing back to another sheet. How to hide those...

Hi Zak, Thanks for the reply. Can you please shed some light how to do this? If you can post some sample code that will be really very useful. Regards Ria

Thanks Pat but issue is number of records in each box (e.g. Row 5 to 11, Row 16 to 24 and so on). That has to be dynamic / automatically e.g. Team 1 will have 30 records in each box and while generating report for Team 2 will have 5 records in each box (except last box Row 82 to 91, this will...

Hi Pat, We can't hard code the values in Column A as these contain Bankers names. And banker names will keep changing every month. These values need to be dynamic and as I said each team can have different number of bankers e.g. Team 1 ====== Banker ABC 1 Banker DEF 2 ........ Banker HJK 38...

Hi Pat, Sorry I did not get you. If my data sheet contains names and amounts then how data will be moved from "Data" sheet to "Main" sheet without any lookup? Attached sheet is a common template which needs to be generated for each team and there are total 9 teams and for each team there...

Dear All, I also need to create the dashboard. Not sure how to proceed and got stuck. http://www.access-programmers.co.uk/forums/showthread.php?t=227889 Highly appreciate your help on this. Thanks Ria

Hi Artemis, Did you manage to build the dashboard? I also got the same requirements and not sure how to proceed. http://www.access-programmers.co.uk/forums/showthread.php?t=227889 Could you please share your experience, how you have done this? Highly appreciate your help on this...

I also thought of doing that but issue is Bankers names in Column A will be changed time to time. And showing Top 10 Trades / Bankers etc will be dynamic. How to achieve this using template?

Hi Experts, Is this really not possible?

Got error: Run-time error '3265': Item not found in this collection.

Got error Item not found in this collection. /C cntRow = 2 cntCol = 2 Do While Not rsTmp.EOF lngCol = 0 For Each varField In rsTmp.Fields ' appExcel.Cells(cntRow, 1) = rsTmp!Status ' appExcel.Cells(cntRow, 2) = rsTmp!DBT_RM_NAME '...