Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Edinburgh, Midlothian, Scotland
    Posts
    492
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Labels (Access 2007)

    Can you help a newb please. Virtually my first time using 2007.

    I'm trying to create labels for my Mini-DV tapes. I have had to create a custom label 4.5cm high. and 6.5 cm wide.

    My labels however do not output correctly. See attached image showing layout and print preview. The colums are set up (apparently correctly) on page set-up,

    It seems as if I need to force a new label at the right height, rather like a page break, but I can't see how. If I make the detail a total of 4.5 cm high, then I get the right label size, but only 1 clip list per label.

    Do I need some form of sub-report?

    I'm sure you'll need extra info, but not sure what to include.

    Any help welcome

    Thanks


    Colin
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Labels (Access 2007)

    I think you'll need to create a subreport to list the clips. The subreport would go into the group header, and the detail section of the main report would have height 0.

    Or you could use the Concat function from <post#=301,393>post 301,393</post#>, but I think that'd be more work.

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Edinburgh, Midlothian, Scotland
    Posts
    492
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Labels (Access 2007)

    Wow that's fast!!!!!!!!!!!!!!!!!!!!!!!!!!!

    I'll have a look at the sub report.

    Thanks


    Colin

  4. #4
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Edinburgh, Midlothian, Scotland
    Posts
    492
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Labels (Access 2007)

    Thanks Hans. Worked perfectly.

    I've spent 2 hours trying to solve this. I do like to try and solve my own probs as it's the best way to learn, but!!!

    I had tried a sub report, but put it in the detail. Never thought it should go in the Header.

    Thanks again, and particularly for such a fast response.

    Colin

Posting Permissions

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