我被难住了--而且我对access中的VBA也很陌生,但这是我的意图:
我想让成员在access中选择“开始”按钮,从那里,多个输入框将弹出,允许用户输入数据。我希望输入数据(名称、日期等)要存储到表单上的标签中,最后打开“开始”按钮的下一个人会弹出一堆新的输入框,然后将它们的数据存储在表单的每个标签中。游戏结束时,一个漂亮的表格通过电子邮件寄给了我。
我已经掌握了输入框和消息框-它们会弹出并一直运行下去。我的问题是,当用户输入他们的信息时,我需要将其转到表单的适当字段中,以便最终表单可以“打印”为.pdf并发送给我。任何帮助都将不胜感激!
Sub Begin()
Dim AddName As String
Dim AddAddress As String
Dim AddSupv As String
Dim AddPhone As String
AddName = InputBox("What is your rank and full name?", "Enter Rank and Name")
AddAddress = InputBox("What is your home address? Please include street, city, state and zip.", "Enter Address")如果是any,我是否要添加一个函数,以便在表单的字段中插入每个输入框之后的数据。表单名称是Form1,如果输入框数据必须先转到表中,我还有一个标记为'AUS Table‘的表,其中有名为'Name_and_Rank’和'Address‘的字段。
发布于 2020-04-28 00:50:32
不需要变量,只需要引用控件。
对于label控件:
Me.lblName.Caption = InputBox("What is your rank and full name?", "Enter Rank and Name")
Me.lblAddress.Caption = InputBox("What is your home address? Please include street, city, state and zip.", "Enter Address")
对于textbox控件:
Me.tbxName = InputBox("What is your rank and full name?", "Enter Rank and Name")
Me.tbxAddress = InputBox("What is your home address? Please include street, city, state and zip.", "Enter Address")
但是如果表单上有文本框,用户应该直接在文本框中输入。
https://stackoverflow.com/questions/61461203
复制相似问题