Search results

Hi I'm trying to apply conditonal formatting with TrafficLights using below access VBA but getting error "object doesn't support this property or method". I'm new to Access VBA please let me know what I'm doing wrong. Sub setRAGStatusFontColorIcon(strRange As String) Dim objISet As...

Hi, My query is not returning correct result of outer join I tried to write query in different way but no success. Please find below my query: SELECT ProdCat.ProductName, Sum(tbl_Consol_Weekly_Product.RevenueInUSD) AS Revenue FROM tbl_Consol_Weekly_Product, tbl_Bankers_Mapping, (SELECT...

Thanks Pat. But how to populate the data in the form. I'm sorry for basic question. Actually I'm now to Access world and have not created from to display the data. Thanks a lot for all the help

Any idea how to show backend data in frontend application. I have two databases FE and BE. And BE database is password protected. I need to extract data from BE database and need to show in FE in read only format and need to provide one button to change the data. Any idea how to achieve...

Ok Will try in excel section as but this needs to be done from access VBA

I can't build the report using template because this has to be dynamic I'm sure someone must have done this Any idea???

If A3 page size driver is install then this works Even if its dummy printer But at work place I can't install dummy printer in all user's desktop Ant idea how to tackle this?

I'm importing data from Excel to Access using Access VBA which works fine that sheet name is first sheet in workbook. However, if multiple sheets exists in the workbook and that particular sheet can be 2 sheet, 3 sheet or any sheet. In that case how to search particular sheet name and import in...

Yes are right Its not a good design but due to time limitations and requirements I have done in this way

Hi Pat Thanks for the reply Are you saying queries should be in FE ? If I'll keep queries in FE then I need to create tables as well FR, right? I have only few queries in DB otherwise all queries are written in VBA code itself

Dear All, I have created Access database as a frontend application and another database as a Backend Database (all the databases are password protected). All tables and queries are stored in Backend Database. I have created Excel Sheet and writing data in this excel file and performing the...

I have not splitted the database. I have created two different databases. One database has only forms and other database has Tables and Queries only. And Form / Sub-form both needs to be created from single table only.

Dear All, I have created Access database as a frontend application and another database as a Backend Database (all the databases are password protected). All tables and queries are stored in Backend Database. My problem is that I need to create a form (Combo filters) with sub-form (List of...

I changed the code to below: Sub setRAGStatus(strRange As String) objXLSheet.range(strRange).Select objXLSheet.range(strRange).FormatConditions.Add Type:=xlCellValue, Operator:=xlGreater, Formula1:="=1"...

Highly appreciate your help and response on this.

I have used below the code but this is not working Sub setRAGStatus(strRange As String) objXLSheet.range(strRange).Select objXLSheet.range(strRange).FormatConditions.Add Type:=xlCellValue, Operator:=xlGreater, Formula1:="=1" objXLSheet.range(strRange).FormatConditions(1).Font.Color...

Thanks Michael. I need to change the font color only (not background of the row). If cells value is 100% and above then change value's colour to Green (default is Black) If it's above 95% and Less than 100% then check font color to Amber If it's less than 95% then change font color to Red

Any idea how to set the A3 excel page size using Access VBA? http://www.access-programmers.co.uk/forums/showthread.php?t=231362

Thanks. I have designed in this way due to the requirment. Thanks for the help.

Thanks for the reply. There was no issue in establishing the connection. Anyway I have managed to resolve the issue. Thanks