Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2008
    Posts
    24

    Unanswered: Report printing onto sticker help

    Ok i have designed a report to print out labels into on a A4 sheet of paper with labels sticks on (see example below) , i us this to print out multiable address to stick on letters. my problem is that if let say i print 3 sticker out well that Used up slot 1 to 3, my problem is that it now mean that the sheet is wasted and i can use the other slots. so i want a way i can tell my report to print a a number of blank reports of my choosing, that way i can push the address down to print on the place i want. how would i achieve this, or is there a better way of going about this?

    ____________
    |__1__||__2__|
    |__3__||__4__|
    |__5__||__7__|
    |__7__||__8__|
    |__9__||_10__|

  2. #2
    Join Date
    Jun 2008
    Posts
    29
    If your report is based on a query that treats each record as a sticker, you could try to enhance the recordset by adding as many "blank" records as necessary by programatically editing the RecordsetClone object of your report. Now that's just an idea and you'd need to work out the details but it could work.

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Try these links :

    http://support.microsoft.com/kb/95806
    http://blogs.techrepublic.com.com/howdoi/?p=129

    Personally, I just use window envelopes. Solves the problem for me
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jun 2008
    Posts
    24
    window envelopes would not solve the problem because we stcik the sticker onto ITem before storage as well.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    ^^ Well that shuts me up!!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Feb 2002
    Posts
    108
    I have looked and looked through the code bank, but I can't find it. But a few months ago, I downloaded some sample code in a database called LS2002, and it works great. It does exactly what you need, we were doing the same thing. We would print a few labels from a sheet for labeling parts, and then turn the page over and print a few labels later, and then trash all the labels in the middle. I'm not sure of the protocol or security issues, but since I can't find it in the forum, I would be happy to send it to you.

  7. #7
    Join Date
    Jun 2008
    Posts
    24
    Don't worry about it, i got bored of try to work this out so i "stole" the com[pany credit card and brought a label printer

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    HAHAhaahahahaaaaaaaaaaaaaa!

    Best solution EVER!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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