alsa
01-17-2009, 09:11 AM
Hi All,
In order to make as simply as possible what my problem is please find attached two documents (my_example.xls and db32.mdb). Excel workbook is connected to Access database. All can be seen in VBA editor.
In order to make this working just specify correct path to db on your PC.
Sheet2 is gathering information I wish per each TCID separately (pay attention to combobox load and loc (TC...TC5) I used (from Users table in Access mdb) depending of entered user name and password.It works fine.
Here is my problem I really need urgent solution (related to sheet3 in which I want to have correct information):
If you use username aa and password aa you can see in combobox in sheet2 only TCIDs that in 5th and 6th position contain value 09, 10, 11, 12, 13 and 14 (as defined in USERS table in Access db). Following to that in sheet 2 you can generate informations only for one chosed TCIDs from Combobox. In sheet3 i need to make possible to have sum of Value1 in cell B7 refferng to date (column in TEMP table in Access db) for all TCIDs at once(that in 5th and 6th position contain value TC, TC1, TC2,TC3,TC4,TC5 as specified in Users table in Access db). This mean when user chose one of offered dates he\she would have sum of all TCIDs he\she at aggregate level (for e.g.09,10,11,12,13 and 14 TCID) not only for one of them. So basically sql statement in where condition has to reffer to Users table and collect only TC...TC5 assigned to used UserName and Password inLogin to Excel Workbook.
I would very appreciate help in order to solve my problem.
Also I would very appreciate to use attachet excel document in providing solution.
Thank you very very much for time end effort.
Best regards
In order to make as simply as possible what my problem is please find attached two documents (my_example.xls and db32.mdb). Excel workbook is connected to Access database. All can be seen in VBA editor.
In order to make this working just specify correct path to db on your PC.
Sheet2 is gathering information I wish per each TCID separately (pay attention to combobox load and loc (TC...TC5) I used (from Users table in Access mdb) depending of entered user name and password.It works fine.
Here is my problem I really need urgent solution (related to sheet3 in which I want to have correct information):
If you use username aa and password aa you can see in combobox in sheet2 only TCIDs that in 5th and 6th position contain value 09, 10, 11, 12, 13 and 14 (as defined in USERS table in Access db). Following to that in sheet 2 you can generate informations only for one chosed TCIDs from Combobox. In sheet3 i need to make possible to have sum of Value1 in cell B7 refferng to date (column in TEMP table in Access db) for all TCIDs at once(that in 5th and 6th position contain value TC, TC1, TC2,TC3,TC4,TC5 as specified in Users table in Access db). This mean when user chose one of offered dates he\she would have sum of all TCIDs he\she at aggregate level (for e.g.09,10,11,12,13 and 14 TCID) not only for one of them. So basically sql statement in where condition has to reffer to Users table and collect only TC...TC5 assigned to used UserName and Password inLogin to Excel Workbook.
I would very appreciate help in order to solve my problem.
Also I would very appreciate to use attachet excel document in providing solution.
Thank you very very much for time end effort.
Best regards