问题描述
我有一个用于回流测试的数据库。该数据库包含3个表：客户信息，测试日期和实际文档的超链接以及发票信息。
我已经与客户ID周围的表建立了关系。
用户可以选择客户端并单击打开客户端信息。命令按钮。
从客户信息表中我创建了一个命令按钮，用于打开发票表单并插入所选客户表单中的信息。
从发票表单中我创建了一个命令按钮，将发票保存为pdf。
这是我希望您可以提供的帮助：我想要另存为pdf命令按钮做几个任务。
1：另存为pdf，2：保存到桌面上的临时文件夹，3：根据FirstName，Lastname字段保存为文件名，最后保存打开aol电子邮件，以便将其发送给客户。
我已经完成了将其保存为pdf并输入了输出文件信息。但我得到一个错误，说文件打开时我无法保存它。如果我删除输出文件信息，它允许我将其保存为pdf，但我必须选择位置。
我知道我问了很多你，但我希望你能帮助我
I have a built a database for backflow testing. The database contains 3 tables: Client Information, Testing Date and hyperlinks to actual document and Invoice information.
I have built the relationships with the tables around the client ID.
The user can select the client and click on a "Open Client Information" command button.
From the client information form I have created a command button that will open the invoice form and insert the information from the selected client form.
From the invoice form I have created a command button that saves the invoice as a pdf.
This is what I am hoping you can help with: I want the Save as pdf command button to do several tasks.
1: save as pdf, 2: save it to a temporary folder on desktop, 3: save it as file name based on FirstName, Lastname fields, and lastly open up aol email so that it can be sent to client.
I have accomplished saving it as a pdf and I entered the output file information. But I get an error saying I cannot save it while the file is open. If I delete the Output file information it allows me to save it as a pdf but I have to choose location.
I know I am asking a lot of you, but I hope you can help me
推荐答案
这篇关于需要一个命令按钮才能在Access 2013中执行多个作业的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！