Results 1 to 15 of 15
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing labels (Office 2000)

    Hi,
    Every time we get a new customer, I have to prepare a packet that includes printing labels for their membership card and we also use a label for the address. Some days I only have one to print and maybe a couple another day.

    What I do now is merge the name and address into Word from the Access database. (I would prefer to do everything from inside of Access but...) Since I don't use a entire sheet of labels at once, I usually have to cut and paste where I would like the label(s) to print. Is there a way to tell Access or Word where to start printing? for example the 4th row, 2nd column?

    Thank you
    Louise

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing labels (Office 2000)

    Hi Louise
    I had this problem but, thanks to Hans, it's now not a problem!
    He pointed me here and it works perfectly.
    HTH
    Silverback
    Silverback

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing labels (Office 2000)

    Hi! Silverback,

    Thank you very much! I'll check it out. Isn't Hans great? What would we do without him!

    Have a great day!
    Louise

  4. #4
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing labels (Office 2000)

    Hello again,

    Is there something like this that works for Word as well?

    Thanks
    Louise

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing labels (Office 2000)

    Doesn't seem hopeful. I found this in the Word forum, but it's very old, so things might have changed.
    I'll keep looking
    Silverback
    Silverback

  6. #6
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing labels (Office 2000)

    Hi Silverback,
    I couldn't find anything either. That's ok. I can just keep cutting pasting like I've been doing.
    Louise

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing labels (Office 2000)

    Haven't found anything but I have managed to make it merge at a particular point (crude, but it works)

    Set up the labels merge doc as per normal.
    Copy the first label - this is the one which doesn't have a <Next Record> before the Merge Fields.
    Delete the contents of all the cells up to your starting label position.
    Paste the copied record into the start label position i.e your page of labels now has, at the beginning, blank cells corresponding to the used label positions and the starting label cell has the merge fields but no <Next record> entry.
    Merge data and the labels will start at your start point.

    However, this, while being resonably quick, isn't hugely different to just merging a whole sheet of labels and then cutting the label cells from the used label positions and pasting them at the end of the merged sheet.
    You pays your money . . . . <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Silverback
    Silverback

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

    Re: Printing labels (Office 2000)

    I'd prefer the method described in the thread you referred to: if you want to skip the first n labels, temporarily insert n blank rows/records at the top of the data source table.

  9. #9
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing labels (Office 2000)

    HI,

    I'm back to the original question. I followed Microsoft's instructions ( I thought), and I'm doing something wrong. I keep getting "can't find macro or macrogroup".
    The instructions said to "create a new module", so under "Modules" in Objects, I clicked on "New" and copied everything from Microsoft's listing into it. The only thing I did differently was rename "MyLabels" to the actual name of the label report. The module named itself "LabelLayout" so I left it that way.

    Did I create this in the wrong place? or go about it the wrong way?

    Thanks again
    Louise

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

    Re: Printing labels (Office 2000)

    Try giving the module another name - LabelLayout is the name of one of the functions in the module, and you shouldn't have a module with the same name as a sub or function.

  11. #11
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing labels (Office 2000)

    Hi Hans,

    Sorry, but that didn't do it. Changed to simply "Labels" . The error message is the same and references pretty much what is in the "OnPrint" section. =LabelLayout(Reports![PCRM Card Label]) Could be just a coincidence?
    Louise

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

    Re: Printing labels (Office 2000)

    Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  13. #13
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing labels (Office 2000)

    Hans,
    Here you go!

    Thanks again,
    Attached Files Attached Files
    Louise

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

    Re: Printing labels (Office 2000)

    Open the report in design view.
    Click in an empty part of the detail section, or click on the gray bar at the top of the detail section.
    Activate the Event tab of the Properties window.
    Remove the space from before the = in the On Print event.
    It should work OK then.

  15. #15
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing labels (Office 2000)

    Oh for Goodness' sake! How on earth did you spot that one? Hans, you're wonderful! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    Even when I was looking at it, I thought "what space?"

    Once again, thank you so much!
    Louise

Posting Permissions

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