指定的文件名不起作用 [英] Specified file name not working
问题描述
如果之前有人问过，请事先道歉。
我在表单中创建了一个按钮及其功能
on click（我已进入宏构建器）
-ExportWithFormating
对象类型 - 表格
对象名称 - （?? ？）
输出格式 - PDF格式（* .PDF）
现在发生了事情如果我将对象名留空，它会自动尝试保存表单转换为pdf格式，默认名称为FrmMachinefault.pdf
，这非常有效。
但是，如果我试图指定名称无论如何，即使是简单的文件也是如此。它出现了一个错误。
我要放入的代码是一个宏来从现有表格中提取信息
= [关闭日期]& " _" &安培; [受影响的区域]& " _" &安培; [资产]& " _" &安培; [标题]。
结果应该是例如。
02_07_15_101_Foundry_Mixer_Broken_Shaft.PDF
这就是我想要的，它目前做的是带有正确标题的安全页面，但是当我点击SAVE时它附带
" Microsoft Access无法找到对象''| 1''。
确保对象存在且你的名字拼写正确。
我已经查看了名字并且它应该是正确的请帮助
Hi apologies in advance if this has been asked before.
I have created a button in a form and its function
on click ( I have gone into the macro builder)
-ExportWithFormating
Object type - Form
Object name - (???)
Output format - PDF Format (*.PDF)
now heres the thing If I leave the object name blank it automatically tries to save the form into a pdf format with a default name "FrmMachinefault.pdf
and this works perfectly.
However if I tried to specify the name in anyway even a simple "file" it comes up with an error.
the code I want to put in is a macro to pull information from the existing form
= [Closed date] & "_" & [Effected area] & "_" & [Asset] & "_" & [Title].
The result should be for example.
02_07_15_101_Foundry_Mixer_Broken_Shaft.PDF
this is what I want and what it currently does is goes to the safe as page with the correct title but when I click SAVE it comes with
"Microsoft Access cannot find the object ''ǀ1''.
Make sure the object exists and that you spell its name correctly."
I have gone through the names over and over again and it should be correct please help
推荐答案
是不是因为被引用的对象名称是应该导出的对象，而不是生成的文件的名称。您可以指定任何表单或表或查询的名称。
Jim
Isn''t it because the object name that is being referred to is the object that should be exported, not the name of the resulting file. You could specify the name of any form or table or query.
Jim
嗨吉姆，我认为你是对的，我把它改回了正确的对象名称，它一直有效。
然而，这并不能解决我的问题。我要求它从打开的信息中提取信息。对于文件名，所以当我点击导出按钮时，它会根据示例自动提取我想要的信息，我需要做的就是在进入该位置后按保存。
Hi Jim, I think you are correct, I have changed it back to the correct Object name and it consistently work.
However, that doesn''t fix my problem. I require it to pull information from the "opened" for the filename so when I click the export button, it will automatically pull the information I want as per the example and all I need to do is press save after I go into the location.
您使用的是哪个版本的Office？
ExportWithFormatting宏操作
您应该可以选择设置OutputFile
Which version of Office are you using?
ExportWithFormatting Macro Action
You should have the option to set the OutputFile
这篇关于指定的文件名不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
