|
Regina Whipp |
|
The difficult I do immediately, the impossible takes a little bit longer. |
|
Miscellaneous |
Print Full or Partial Sheet of Labels |
|
To use this database import the module and the form enclosed in the sample download into your database. There is no need to import the report as you can use your pre-existing label report.
(If you do not want to use the enclosed form (see above) you can place the fields on another form of your choice. BUT where you find a reference to the form and/or field name you must change the name accordingly, including within the module!) |
|
Question: Hi, I am trying to create a full sheet of the same label from my access file. I would like 30 of record 1, 30 of record 2, etc. Is there a way to do that so I get a full sheet of each record rather than just one label of each?
Question: I need a way to print only 2-3 labels at a time, but not waste the whole sheet of labels. Any ideas?
Answer: |
|
This sample database will allow you to print a full sheet of the same label or print a partial sheet of the same label or use a partially used sheet to print labels or any of the above in combination of each other.
This database requires 2002 or above. |
|
In your report entries must be made in the three sections…
1. Report Properties—On Open event |
|
2. Report Header Properties—On Format event |
|
3. Report Detail Properties—On Print event
Notice, you will need to put the name of your report within the parenthesis, ie: (Reports!YourReportName) |
|
If you have elected to use another form then don’t forget open the module and change the form name to your own! |
|
In the query attached to your Report on the Criteria line put a reference to your form and the combo box where you select which entity you want to print labels for. |