Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Wellfleet, Massachusetts, USA
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Header (Access 97)

    I am working on a small booklet for a group. The easiest way to create a report for the membership list was to use a label report.
    I am NOT a developer or skilled in using VBA! I am trying to use a header in the label report (which I have printing in landscape with 4 columns). However, the header (with just a text box) does not show up in print preview. I tried creating a field in the database that said "Member List" for each record. and then pusing this field in the header. Obiously I am not doing something right. HELP! I don't want to have to cut and paste to insert this on each page. The page will be folded in half with 2 columns and the header would appear over the first 2 columns and then the last 2 columns on each page. If someone can walk me through the VBA process, I am eager to learn. Thanks a bunch.
    <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    LibbieL

  2. #2
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    New Jersey, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Header (Access 97)

    Try using the sorting and group function in the report, placing the header info in the group header section. The info will then show up on the first label, not all the way across buy at least it is something. Also you might want to use the group footer so that you can force new page after section.

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Wellfleet, Massachusetts, USA
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Header (Access 97)

    Cathy, thanks for your help. I can't use the first mailing label as the title since this is for a booklet. The cut and paste method is the easiest as far as I can see. But I will remember your info for another project.
    LibbieL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •