hi to all
I have a table (tblTargetCells) with 2 long fields, col and row. There are typically about 100 records.
There is a 2nd table (tblOutput) that has long values in, say, 23 fields (row, c1, c2, c3, ... c22).
A report,(rptOutput), presents the data exactly as it appears in tblOutput.
Here's my question. In the Report, I want Fore Color = 255 for ALL cells identified in tblTargetCells.
For example, the first record of tblTargetCells indicates that we need to change the Fore Color of the 11 found in column c1 and row 3 of the Report.
Could some kind soul sketch out VBA that would do this? Even a rough outline would really help.
Thanks in advance.
I have a table (tblTargetCells) with 2 long fields, col and row. There are typically about 100 records.
Code:
col row
========
1 3
1 12
1 25
2 4
2 35
3 17
... etc
22 18
22 50
There is a 2nd table (tblOutput) that has long values in, say, 23 fields (row, c1, c2, c3, ... c22).
Code:
row c1 c2 c3 ... c22
==================================
1 5 7 2 ... 45
2 42 6 31 ... 21
3 11 54 14 ... 99
... etc
21 31 5 71 ... 38
22 4 65 30 ... 20
A report,(rptOutput), presents the data exactly as it appears in tblOutput.
Here's my question. In the Report, I want Fore Color = 255 for ALL cells identified in tblTargetCells.
For example, the first record of tblTargetCells indicates that we need to change the Fore Color of the 11 found in column c1 and row 3 of the Report.
Could some kind soul sketch out VBA that would do this? Even a rough outline would really help.
Thanks in advance.