I've been working with Access for about 5 years and have decided that I need to learn VBA to bring my database up a notch. I have never done any programming before, so this is all new to me.
I have a database that groups records by when a project is due. I would like to change the background color by Week. The problem I'm having is that the weeks are not necessarily consecutive. How to I make the report alternate between colors if there is a week in-between when they are due?
Thank you for any assistance you can give.
Jax
I have a database that groups records by when a project is due. I would like to change the background color by Week. The problem I'm having is that the weeks are not necessarily consecutive. How to I make the report alternate between colors if there is a week in-between when they are due?
Thank you for any assistance you can give.
Jax