使用代码创建新标签/瓶子...... [英] Creating new labels/bottons using code...
问题描述
我知道我之前已经问过这个问题了，但我没有得到答案..
我会试着解释一下我在做什么：
我有一张带有生日的pepole的桌子，我希望在当月提供一个位置的所有pepole ...并为每个persone添加一个按钮发送他给我发了一封快乐的电子邮件。
我不能说它会是100或300的1个人......这就是为什么我必须为每个人使用标签/按钮SELECT循环..
我正在做形式负载循环
希望有人可以帮助我，或者建议我一个更好的主意.. 。
提前感谢，
Idan
I know I already asked this question before, but I didn''t get an answer..
I''ll try to explain what I''m trying to do:
I have a table with pepole with birthdates, and I want to present all the pepole with a bitrthday on the current month... and to add a botton for each persone to send him email of happy bday.
I can''t tell wather it will be 1 persone of 100 or 300... thats why I must create a labels/botton for each persone using the SELECT loop..
I''m doing to loop on form load
hope someone could help me out, or advice me a better idea...
thanks in advance,
Idan
推荐答案
我知道我之前已经问过这个问题，但我没有得到答案..
我会试着解释我在尝试什么要做的事情：
我有一张带有人孔的桌子出生日期，我想在当月提供当天的所有人员...并为每个人添加一个按钮给他发送快乐bday的电子邮件。
我可以告诉wather它将是100或300的1个人...这就是为什么我必须使用SELECT循环为每个persone创建一个标签/ botton ..
我正在做循环在表格上加载
希望有人能帮助我，或者建议我一个更好的主意......
提前感谢，
Idan
I know I already asked this question before, but I didn''t get an answer..
I''ll try to explain what I''m trying to do:
I have a table with pepole with birthdates, and I want to present all the pepole with a bitrthday on the current month... and to add a botton for each persone to send him email of happy bday.
I can''t tell wather it will be 1 persone of 100 or 300... thats why I must create a labels/botton for each persone using the SELECT loop..
I''m doing to loop on form load
hope someone could help me out, or advice me a better idea...
thanks in advance,
Idan
我想知道为什么要动态地这样做。在极少数情况下，您需要动态制作表格。但是有几种很好的方法可以完成你的要求。我会尝试给你两个想法。
首先：
如果你打算回顾一个生日快乐的人名单一个月，每个人都会收到一封电子邮件，为什么不简单地使用循环来一次发送所有内容。这比单击表单上的300多个框要好得多。这可以通过检索所述记录集并循环遍历每个记录来将信息添加到电子邮件中来实现。有关此部分的更多信息，我将查看通过电子邮件发送，因为它是这个问题的一个很好的基本答案。
第二名：
如果你真的需要一个按钮，那么最好创造一个按钮连接按钮的连续形式。从这里开始，它将以您希望的格式显示所有记录，并且您可以在表单上显示请求电子邮件按钮。
希望这会有所帮助。
- Minion -
Right off I wonder why you want do this dynamically. There is a rare occasion that you will want to produce a form on the fly. But there are a couple good methods to complete what you are asking. I''ll try and give you two ideas.
First:
If you are going to retreive a list of everyone with birthdays in a month and each are going to get an email message why not simplly use a loop to send them all at once. It would be far better than haveing to click on 300+ boxes on the form. This could be accomplished by retreiving the said recordset and looping through each record adding the information into an email. For more information on this part I would check out Emailing From Access as it is a good basic answer to this problem.
Second:
If you really need to a button for each it would probably be best to create a continuous form with the button attached. From here it would show all the records in what ever format you desired and you could have the requesit email button on the form.
Hope this helps.
- Minion -
感谢Minion ..
我知道怎么做你建议的第一种方式，但是我想选择发送哪个人，以及最重要的何时 ..我只想显示pepole。
我真的不明白你的第二个建议..它只显示当月有bday的人吗？还是会显示桌子上的所有人？
也许如果我能在特定日期之间填充它会有所帮助...如果有人知道怎么做？
虽然我更喜欢创建新标签来显示人们可能...
thanks Minion..
I know how to do the firts way you suggested, but I would like to choose which person to send, and the most importent when.. I want only to display the pepole.
I didn''t really understood your second suggestion.. will it display only the pepole which have bday on the current month ? or will it show all the pepole from the table ?
maybe it will help if I could fillter between specific dates.. if someone know how ?
though I prefer creating new labels to display the pepole if its possible...
我想知道你为什么要动态地这样做。在极少数情况下，您需要动态制作表格。但是有几种很好的方法可以完成你的要求。我会尝试给你两个想法。
首先：
如果你打算回顾一个生日快乐的人名单一个月，每个人都会收到一封电子邮件，为什么不简单地使用循环来一次发送所有内容。这比单击表单上的300多个框要好得多。这可以通过检索所述记录集并循环遍历每个记录来将信息添加到电子邮件中来实现。有关此部分的更多信息，我将查看通过电子邮件发送，因为它是这个问题的一个很好的基本答案。
第二名：
如果你真的需要一个按钮，那么最好创造一个按钮连接按钮的连续形式。从这里开始，它将以您希望的格式显示所有记录，并且您可以在表单上显示请求电子邮件按钮。
希望这会有所帮助。
- 小兵 -
Right off I wonder why you want do this dynamically. There is a rare occasion that you will want to produce a form on the fly. But there are a couple good methods to complete what you are asking. I''ll try and give you two ideas.
First:
If you are going to retreive a list of everyone with birthdays in a month and each are going to get an email message why not simplly use a loop to send them all at once. It would be far better than haveing to click on 300+ boxes on the form. This could be accomplished by retreiving the said recordset and looping through each record adding the information into an email. For more information on this part I would check out Emailing From Access as it is a good basic answer to this problem.
Second:
If you really need to a button for each it would probably be best to create a continuous form with the button attached. From here it would show all the records in what ever format you desired and you could have the requesit email button on the form.
Hope this helps.
- Minion -
使用
Dim Label3作为新标签
不能用？
using
Dim Label3 As New Label
can''t work ?
这篇关于使用代码创建新标签/瓶子......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
