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
|
|||
|
|||
Printing reports with no data
I have designed an equipment inventory db. I have to
conduct an inventory of our equipment and want to print out what I have so far so I can make any changes to it and add equipment that isn't accounted for. I have designed a report by employee with 4 subreports which identify the computer, monitor, printer and any peripherals the employee has been assigned. Each equipment type is a separate subform. For some employees, we have no information. For others, we have the computer and printer, but no monitor or peripheral info. The tables are set up so that there is one main table (tblInventory) and 4 additional tables (tblComputer, tblPeripheral, tblMonitor, tblPrinter) with information specific only to that equipment type in the secondary table. Each table has a relationship with the main table. How can I design my report so that all 4 subreports print, with or without data? Right now, if an employee has a computer, but no other information in the database, only the computer subform prints and the rest of the page is blank. Thanks in advance for any help! Tina |
#2
|
|||
|
|||
Printing reports with no data
Tina,
I don't have an answer for you but you might want to watch the next post from me as well. I am trying to solve the same problem. I posted this problem in late June with no replies so I posted again today. I'm currently trying to add a blank record to the recordset for the subform but I'm not finding the right place to add the record. I'll let you know if I succeed. HTH, -- Greg Blair CNV Software Minneapolis MN " wrote: I have designed an equipment inventory db. I have to conduct an inventory of our equipment and want to print out what I have so far so I can make any changes to it and add equipment that isn't accounted for. I have designed a report by employee with 4 subreports which identify the computer, monitor, printer and any peripherals the employee has been assigned. Each equipment type is a separate subform. For some employees, we have no information. For others, we have the computer and printer, but no monitor or peripheral info. The tables are set up so that there is one main table (tblInventory) and 4 additional tables (tblComputer, tblPeripheral, tblMonitor, tblPrinter) with information specific only to that equipment type in the secondary table. Each table has a relationship with the main table. How can I design my report so that all 4 subreports print, with or without data? Right now, if an employee has a computer, but no other information in the database, only the computer subform prints and the rest of the page is blank. Thanks in advance for any help! Tina |
#3
|
|||
|
|||
Printing reports with no data
Greg:
I saw your post shortly after I posted mine. I hope we get a response, but I'm not optimistic what we are trying to do will work. I know there is an event property in the properties box of the report called "Has no data" but I don't know what code to put in it. I'll keep trying and waiting for a response. Hopefully we'll get one! Tina -----Original Message----- Tina, I don't have an answer for you but you might want to watch the next post from me as well. I am trying to solve the same problem. I posted this problem in late June with no replies so I posted again today. I'm currently trying to add a blank record to the recordset for the subform but I'm not finding the right place to add the record. I'll let you know if I succeed. HTH, -- Greg Blair CNV Software Minneapolis MN " wrote: I have designed an equipment inventory db. I have to conduct an inventory of our equipment and want to print out what I have so far so I can make any changes to it and add equipment that isn't accounted for. I have designed a report by employee with 4 subreports which identify the computer, monitor, printer and any peripherals the employee has been assigned. Each equipment type is a separate subform. For some employees, we have no information. For others, we have the computer and printer, but no monitor or peripheral info. The tables are set up so that there is one main table (tblInventory) and 4 additional tables (tblComputer, tblPeripheral, tblMonitor, tblPrinter) with information specific only to that equipment type in the secondary table. Each table has a relationship with the main table. How can I design my report so that all 4 subreports print, with or without data? Right now, if an employee has a computer, but no other information in the database, only the computer subform prints and the rest of the page is blank. Thanks in advance for any help! Tina . |
#4
|
|||
|
|||
Printing reports with no data
Tina,
I've learned that a subreport without data will never show up under any circumstance so I had to recreate the subform controls on the main report. I had to set the controls visible depending on whether the subreport has data, using the Format event. The thread on my post has the details. -- Greg Blair CNV Software Minneapolis MN " wrote: Greg: I saw your post shortly after I posted mine. I hope we get a response, but I'm not optimistic what we are trying to do will work. I know there is an event property in the properties box of the report called "Has no data" but I don't know what code to put in it. I'll keep trying and waiting for a response. Hopefully we'll get one! Tina -----Original Message----- Tina, I don't have an answer for you but you might want to watch the next post from me as well. I am trying to solve the same problem. I posted this problem in late June with no replies so I posted again today. I'm currently trying to add a blank record to the recordset for the subform but I'm not finding the right place to add the record. I'll let you know if I succeed. HTH, -- Greg Blair CNV Software Minneapolis MN " wrote: I have designed an equipment inventory db. I have to conduct an inventory of our equipment and want to print out what I have so far so I can make any changes to it and add equipment that isn't accounted for. I have designed a report by employee with 4 subreports which identify the computer, monitor, printer and any peripherals the employee has been assigned. Each equipment type is a separate subform. For some employees, we have no information. For others, we have the computer and printer, but no monitor or peripheral info. The tables are set up so that there is one main table (tblInventory) and 4 additional tables (tblComputer, tblPeripheral, tblMonitor, tblPrinter) with information specific only to that equipment type in the secondary table. Each table has a relationship with the main table. How can I design my report so that all 4 subreports print, with or without data? Right now, if an employee has a computer, but no other information in the database, only the computer subform prints and the rest of the page is blank. Thanks in advance for any help! Tina . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Printing colour in reports | Pat Hartman | Setting Up & Running Reports | 0 | July 8th, 2004 05:39 PM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |
Data Labels on Charts in Reports | Frank | Setting Up & Running Reports | 0 | June 3rd, 2004 03:00 AM |
Printing subform data in Access XP | Raj K | Using Forms | 3 | May 31st, 2004 02:24 AM |
Collapsing rows with no data for printing | John Sullivan | Worksheet Functions | 2 | April 17th, 2004 05:42 PM |