问题描述
如果之前有人问过,请事先道歉。
我在表单中创建了一个按钮及其功能
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
推荐答案
这篇关于指定的文件名不起作用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!