Printing report with tabs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have my report set up based on my form. It has 4 tabs which don't always
contain data. I would like to set it up to print the tabs that have data not
just the first tab or the tab showing at the time. I also would like it to
show the tab name. Can anyone help me? Thanks in advance.
 
You can place the controls from each "tab" on a subreport (or just on the
main report). Tab controls shouldn't be used on reports.
 
So would I create a text box and write an event procedure? Or am I missing
something completely easy?
 
I am confused regarding what you have for fields in your report's record
source and what you want to display in your report. Don't even think about
tabs and reports in the same sentence.
 
Okay what I have is a library database. What I need to enter is a set of
curriculum books. Some of these books are in sets which have big books,
small fiction books, small non-fiction books, and cassette tapes. I created
a form with fields for title, author, category (in this case it would be
curriculum), library, and notes. Under that I created 4 tabs which willl
hold the list of books that are included in the set. Not every set has books
or cassette tapes. Maybe I need to set it up differently but I'm not sure
what would work. Any ideas would be wonderful. Thats is why I wanted to
create a report that showed the information in the tabs. I hope this
explains what I am trying to do a bit more.
 
TblCategory
CategoryID
Category

TblBookSet
BookSetID
NameOfBookSet
CategoryID
DateRecd

TblBigBook
BigBookID
BookSetID
BigBookTitle

TblSmallFictionBook
SmallFictionBookID
BookSetID
SmallFictionBookTitle

TblSmallNonFictionBook
SmallNonFictionBookID
BookSetID
SmallNonFictionBookTitle

TblCassetteTape
CassetteTapeID
BookSetID
CassetteTapeTitle

For data entery, create a main form with four subforms. Base the main form
on TblBookset and a separate subform for TblBigBook, TblSmallFictionBook,
TblSmallNonFictionBook and TblCassetteTape. Use a combobox in the main form
to enter the category (CategoryID).

For reporting, create a main report with four subreports. Base the main
report on a query joining TblBookset and TblCategory and a separate
subreport for TblBigBook, TblSmallFictionBook, TblSmallNonFictionBook and
TblCassetteTape.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
 
Why have so many tables. You could have 3 tables

TblCategory
CategoryID
Category

TblBookSet
BookSetID
NameOfBookSet
CategoryID
DateRecd

TblBigBook
TypeOfBook-(BigBook,SmallFictionBook,SmallNonFictionBook..)
BookID
BookSetID
BookTitle

Chris
 
Back
Top