If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Building a Resource Scheduling Database Version: 2000 (9.0)
Hello --
Can Access develop a report in Excel with shaded areas to denote a used resource for a given timeframe? I am building a database that will hold schedules for Trainers and Training Rooms, along with other related training class data. I'm looking to develop an excel report that will display the 52-weeks of the year down column A, and the classrooms across row one. Cell would be color-coded vertically by department. I've attached an example: I have a class beginning on January 1st and ends on February 28th, in Classroom C. I want Access to generate an Excel spreadsheet that will color the cells from 1/1 to 2/28 under Classroom C. Any help would be greatly appreciated. Thanks! -------------------- Thanks, Gabe |
#2
|
|||
|
|||
Building a Resource Scheduling Database Version: 2000 (9.0)
You can't do any formatting with either the OutputTo or TransferSpreadsheet
methods. For this, you will need to use automation. If you have not used it before, the learning curve can be intimidating; however, once you understand it, you can do anything that can be done in Excel. -- Dave Hargis, Microsoft Access MVP "Gabe" wrote: Hello -- Can Access develop a report in Excel with shaded areas to denote a used resource for a given timeframe? I am building a database that will hold schedules for Trainers and Training Rooms, along with other related training class data. I'm looking to develop an excel report that will display the 52-weeks of the year down column A, and the classrooms across row one. Cell would be color-coded vertically by department. I've attached an example: I have a class beginning on January 1st and ends on February 28th, in Classroom C. I want Access to generate an Excel spreadsheet that will color the cells from 1/1 to 2/28 under Classroom C. Any help would be greatly appreciated. Thanks! -------------------- Thanks, Gabe |
Thread Tools | |
Display Modes | |
|
|