如何打印标签一定次数 - 该数字是否存储在字段中？ [英] How can I print a label a certain number of times--the number is stored in a field?

问题描述

我有一个完美的工作表格和报告，所以我没有问题（改变）。我希望采取一些光滑的方式使其更加光滑，但我不知道如何。


我有一个表单设置，您输入CUST_NUM（或多个CUST_NUMs用逗号分隔），表单将这些客户编号传递给报告，该报告设置用于打印运输标签的标签。该报告旨在允许用户跳过标签（之前已在工作表中使用过，因此您可以通过某种方式开始向下打印），并打印用户想要的标签的许多副本。我不聪明，我从这个链接得到了想法和代码：
http://support.microsoft.com/kb/299024 我在此链接中完全没有做任何更改。它完美地运作。我会发布我的代码，万一你不想看链接：

展开 | 选择 | Wrap | 行号

解决方案

您可以修改报告以接受openArgs参数，在您的情况下，它应该是客户ID（一次只有1个），然后您可以获得用户获取printvalue的数量，而不是使用inputbox来获取通过对你的tblCustomers使用DLookup标签。



美化的方法是创建一个表，tblPrintout，包含1个字段，ID_Customer，你的bi一个连续的形式。表单可以包含一个未绑定的文本框，指示要跳过多少标签，以及一个绑定的组合框（绑定到ID_Customer）并查找到tblCustomer，允许您通过使用组合框选择一个或多个客户（更多的故障保护然后键入数字手....）

然后你可以在表单关闭或打开时清除表格，具体取决于你的喜好。


编辑：这不是真的这两种方式都很简单，因为它需要更改很多对象，而不仅仅是报告。抱歉，我不能给出更简单的solutoin。

@DanicaDear - 您可以通过2个简单的步骤完成您的请求：< ol style =list-style-type：decimal>

在LabelSetup（）函数中，REM Out代码行＃3和＃5如下图所示。你不需要它们。

展开 | 选择 | Wrap | 行号

似乎ADezii的（非常好的）解决方案很可能查询每个标签的表格。为了避免这种额外的开销，我已经敲了一个类似的版本（相同的假设等），当 CopyCount& = 0时，它确定正在处理一个新客户（但是只有在所有空白标签都被删除之后）跳过）：

展开 | 选择 | Wrap | 行号

I have a perfectly working form and report, so I don''t have a problem (for a change). I desire to take something slick and make it slicker, but I don''t know how.

I have a form set up which you enter a CUST_NUM (or multiple CUST_NUMs separated by commas) and the form passes those customer numbers to a report which is setup for labels to print shipping labels. The report is designed to allow the user to skip labels (that were used off the sheet previously, so you can start the printing down the sheet a ways) and also print however many copies of the label the user wants. I''m not brilliant, I got the idea and code from this link:
http://support.microsoft.com/kb/299024 I did EXACTLY what it says in this link with no changes. It works perfectly. I will post my code just in case you don''t want to look at the link:

Expand|Select|Wrap|Line Numbers

解决方案

You can modify the report to accept an openArgs argument, in your case it should be the customer ID (just 1 at a time), then instead of using inputbox to get the printvalue from the user, you could get the amount of labels by using a DLookup to your tblCustomers.



The glorified approach is to create a table, tblPrintout with 1 field, ID_Customer, to which you bind a continous form. The form could hold an unbound textbox, indicating how many labels to skip, and a bound combobox (bound to ID_Customer) with lookup to tblCustomer, allowing you to select 1 or more customers, by using a combobox (Much more failsafe then typing numbers by hand....)
You can then clear the table when the form closes or opens, depending on your preferences.

EDIT: This is not really simple either way, as it requires changes to quite a few objects, and not just the report. Sorry that I can''t give a more simple solutoin.

@DanicaDear - Here is how what you are requesting can be accomplished in 2 easy steps:

1. In the LabelSetup() Function, REM Out Code Lines #3 and #5 as illustrated below. You won''t need them.
   

   Expand|Select|Wrap|Line Numbers

It seems that ADezii''s (very good) solution is likely to query the table for every label. To avoid this extra overhead I''ve knocked up a similar version (same assumptions etc) which determines that a new customer is being processed whenever CopyCount& = 0 (but only after all the blank labels have been skipped) :

Expand|Select|Wrap|Line Numbers

这篇关于如何打印标签一定次数 - 该数字是否存储在字段中？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！