Results 1 to 12 of 12
  1. #1
    darious18 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2017
    Posts
    6

    Print a label multi-time

    Hi ,



    I create a database, a form and a label,
    i would like to insert a number ( quantity) and according the this number my label will be print

    exemple : i insert a number of 5 in a case , and when i click on print, access display me 5 time the same information that i went to print

    you find in attached my access database
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228

  3. #3
    darious18 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2017
    Posts
    6
    I'm not expert in Access or VBA so it seems to be a little bit like chinese for me

  4. #4
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    I don't fully understand what it is you are printing. what is it?

    and all you want to do is have that print "x" amount of times via user input?

  5. #5
    darious18 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2017
    Posts
    6
    this is the context, i work for automotive company, so i need to create label for product. ( this step is done)
    sometime we produce for example the same product 5 time, so i need to print the same label 5 time.
    what i went to do is to create field , insert the number of label that i went to create(for exemple 5 label ) and print them.

    that all

  6. #6
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    French is like Chinese to me. haha. But do you have this working to print only one? I'm looking inside now.

  7. #7
    darious18 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2017
    Posts
    6
    we can make exchange help me in access and i help you in french hhhhh , Yep i can easly print just the current result, but i cannot print a multi number of the same label

  8. #8
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    I have created an example that shows a very simple way to do what you want.

    See:
    Print Multiple Labels

    This example shows how to print a varying number of multiple labels per record.

    It also shows how to have 1 of X, 2 of X, etc. print for each item in a group.

  9. #9
    darious18 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2017
    Posts
    6
    it look fine i will send you my database, can you modify it in this sens?

    https://ufile.io/k1wti

  10. #10
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    Quote Originally Posted by darious18 View Post
    it look fine i will send you my database, can you modify it in this sens?

    https://ufile.io/k1wti
    To add this to your database you will need to import the table tblLabelQuantity from my example.

    You add this table to your query. There will not be a join between this table are any other table.

    Next you will need to add criteria for the field tblLabelQuantity.LabelQuantity. In my example I used the field Contacts].[LabelQuantity to get the number of labels required per record. You will need to change this to a field in your query. If you want the same number of label sfor every record that you could use a form reference to a control with the desired number of labels.

    Give it a try.

    I am here if you have any further questions

    Let us know how it goes.




    .

  11. #11
    darious18 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2017
    Posts
    6
    Hi,

    Now it create as much as i need of label , but the problem is that when in try to print , it display only one label and not the quantity that i request.

    https://ufile.io/o7zo6

    Please find my updated database.

  12. #12
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    Did you ever get this work?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Print label Problem
    By rlyackel in forum Access
    Replies: 1
    Last Post: 03-21-2016, 01:13 PM
  2. Using a Form to Print out a label report
    By kdtrimble in forum Forms
    Replies: 52
    Last Post: 07-22-2015, 11:17 AM
  3. Cannot get label to print out correctly
    By kdtrimble in forum Access
    Replies: 3
    Last Post: 06-26-2015, 09:19 AM
  4. Print single label
    By Voodeux2014 in forum Access
    Replies: 2
    Last Post: 11-12-2014, 01:52 PM
  5. Print Label when certian condition is met.
    By talktime in forum Reports
    Replies: 3
    Last Post: 12-15-2012, 03:26 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums