1quickst162
New member
- Local time
- Today, 14:35
- Joined
- Nov 9, 2012
- Messages
- 4
I'm sure this has been answered (matter of fact I'm still scouring the forums trying to find an example or the answer to what I'm looking for).
Access 2003 as we all know has a limit of 3 conditional formatting options (4 if you count the default). I'm looking to add to this via some VBA code. The data I'm referencing is in a table stored in columns labeled 'Day1, Day2' all the way to 31 (for days of the month). Each row has a persons name (for example John Doe). This is sorta like a time clock entry. John Doe did 3 hours of work on the 3rd day, so in Day3 it'd have 3.0.
Anyway, the report that was given to me pulls this data and generates the report. Right now, if it's over 6.5 the cell is colored Green. between 3.0 and 6.5 it's another color, less than 3.0 is another color and if no data entered it's red (default). I want to break this down even further.
I'm having a hard time finding the proper steps to do this. Would I need to do it as Report_Open or Report_Load function? Module? ARGH.
I can do this no problem in Excel, I just can't figure out the VBA to make it work in Access 2003.
Thanks.
Access 2003 as we all know has a limit of 3 conditional formatting options (4 if you count the default). I'm looking to add to this via some VBA code. The data I'm referencing is in a table stored in columns labeled 'Day1, Day2' all the way to 31 (for days of the month). Each row has a persons name (for example John Doe). This is sorta like a time clock entry. John Doe did 3 hours of work on the 3rd day, so in Day3 it'd have 3.0.
Anyway, the report that was given to me pulls this data and generates the report. Right now, if it's over 6.5 the cell is colored Green. between 3.0 and 6.5 it's another color, less than 3.0 is another color and if no data entered it's red (default). I want to break this down even further.
I'm having a hard time finding the proper steps to do this. Would I need to do it as Report_Open or Report_Load function? Module? ARGH.
I can do this no problem in Excel, I just can't figure out the VBA to make it work in Access 2003.
Thanks.