使用DLookup将多个报告保存为PDF和AutoName [英] Save to Multiple Reports to PDF and AutoName using DLookup

问题描述

问：我收到无效使用null错误。什么错了？！？


此命令的目标是首先为每个 SSN创建单独的报告rptECR 在 tblBand会员。接下来，将每个报告保存为PDF并将每个PDF命名为 [location] ，并将其保存到选定的文件夹strMonth。

tblBand会员

Q: I am getting "invalid use of null" error. Whats wrong?!?

The goal in this command is to first create a individual report "rptECR" for each SSN in tblBand Members. Next, save each report as a PDF and name each PDF the expression [location] and save into selected folder strMonth.

tblBand Members

展开 | 选择 | Wrap | 行号

推荐答案

如果你发布了哪一行给出了错误，那将非常有帮助。 />

现在我猜你在第23行得到了错误，我猜测原因是strReportFile是Null。其根本原因是第12和第15行。

第12行和第15行：

It would have been very helpfull, if you had posted which line gives the error.

Now I am guessing that you are getting the error on line 23, and I am guessing the cause is that strReportFile is Null. The underlying cause for this is lines 12 and 15.
Line 12 and 15:

< span class =codeLinkonclick =Blur（this，this.parentNode.parentNode，getChildren（this），true）;>展开 | 选择 | Wrap | 行号

事实上，斯蒂万，正如笑脸所说，包括带有错误信息的行号，对于其他人来说，比在代码本身中使用诸如Bold，甚至评论之类的亮点更容易。那当然说，这是另一个问题很好的问题。


我会跟着它，但我正在通过我的手机ATM工作，所以现在不能做多少贡献（并不是我需要我怀疑，因为笑脸已经覆盖了你。）

Indeed Stevan, as Smiley says, including a line number with the error message is very much easier for others to work with than using highlights such as Bold, or even comments, in the code itself. That said of course, it''s another well-asked question.

I''ll follow it, but I''m working from my phone ATM so cannot contribute much now (not that I need to I suspect, as Smiley has you covered).

好的先生们，


我考虑了你的意见，但我我有点迷失在这里。下面的代码是我尝试和容纳的最新变化，但我仍然不确定如何处理一个部分。 第15行是我得到Null问题的地方。我知道为什么，但我不知道如何指导它。此代码是单个PDF创建者的混合，将一个报告保存为 PDF 并将名称保存为 [位置] ''a 组合框我用来选择谁选择;和一个 NeoPa 的循环帮助我为 tblBand会员中的每个 SSN 打印个人报告。我试图将它们一起使用，但当然命名尝试让我陷入困境。我不知道如何将每个名称与每个PDF相关联。哪个是错误的地方。 对第12行进行更正以正确关联名称是什么？

OK gentlemen,

I have taken your input into consideration but I am a little lost here. the below code is my newest change to try and accommodate but I am still not sure how to treat one section. Line 15 is where I am getting the Null problem. I do know why but I don''t know how to direct it. This code is a mix of an individual PDF creator that saves one report as a PDF and saves the name as the [location] ''a combobox that I use to choose who to select; and a loop that NeoPa helped me work to print an individual report for each SSN in tblBand Members. What I have attempted is to use them together but of course the naming attempt has me in a bind. I don''t know how to associate each name with each PDF as they save. Which is where the error is. What is the correction to line 12 to correctly associate the name with?

展开 | 选择 | Wrap | 行号

这篇关于使用DLookup将多个报告保存为PDF和AutoName的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！