设置表条目数后自动打印标签 [英] Automate Print Labels After Set Number of Table Entries

问题描述

您好，


我想询问如何在Access 2003中最好地执行任务。我有一个将数据输入表格的表单。这又与标签相关联。在表格中输入十个数据后，我想要打印一个标签。我最好在豁免上使用计数器吗？我的表单中的按钮还是有更简单的方法吗？我也想能够打印一个部分标签，说3,5或7通过我的过程进入，我想？也许是第二个？即时品脱？表格上的按钮会覆盖这个，但如果我绑定？保存？按钮到10计数，它会使我的代码复杂化。我是一个初学者，所以我真的很想保持简单。任何来自更聪明的人的话都会受到赞赏。


谢谢，

Peader

Hello,

I?d like to make an inquiry into how to best perform a task in access 2003. I have a form which enters data into a table. This in turn is linked to a label. After ten data entries into the table, I?d like a label to print. Is it best for me to use a counter on the ?save? button in my form or is there an easier way to do this? I?d also like to be able to print a partial label say 3, 5 or 7 enters through my process, I?m thinking maybe a second ?instant pint? button on the form would cover this however if I tie the ?save? button to a 10 count, will it over complicate my code. I?m a beginner so I?d really like to keep it simple. Any words from wiser people would be appreciated.

Thanks,
Peader

推荐答案

Best可能要添加一个打印的YesNo字段。

当输入一行时，使用PrintedYN = False计算记录的查询将给出新输入的行。当大于或等于10时，运行labelprint并发出更新查询以将PrintedYN字段设置为True。


对于计数，您可以使用DCount（）函数。


得到这个想法？


Nic; o）

Best probably to add a "Printed" YesNo field.
When a row has been entered a query counting the records with PrintedYN = False will give the newly entered rows. When greater or equal 10 run the labelprint and issue an update query to set the PrintedYN field to True.

For the counting you can use the DCount() function.

Getting the idea ?

Nic;o)

感谢你指着我正确的方向nico5038，它''我花了一段时间，但是我开始取得进步

thanks for pointing me in right direction nico5038, it''s taken me a while however i''m beginning to make progress

卡住时不要犹豫发布。我来这里是为了帮助。

我始终用指针开始因为我知道当你自己完成一项工作时，它会给你多少满足感。


Nic; o）

Don''t hesitate to post when stuck. I''m here to help.
I start always with "pointers" as I know how much satisfaction it gives when you do a job (almost) by yourself.

Nic;o)

这篇关于设置表条目数后自动打印标签的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！