表单记录设置克隆导航失败！ [英] Form recordsetclone navigation failure!!!

问题描述

Hello All，


我已经开发了一个程序，可以根据特定条件自动生成和发送报告。


我已经意识到它的导航存在问题。我将发布下面的代码，但基本上表单打开并开始发送电子邮件......就像它应该的那样。


我注意到的是，当它应该导航到rst.movenext时，似乎是在跳过记录。通过跳过，我可以在视觉上看到它通过表单上的每个记录，但只在随机记录上发送对象。


任何关于你能看到什么的建议都会很棒。我会发布代码并附上数据库以提供更好的协助。


提前感谢您的帮助


Nick

Hello All,

I have developed a program to automatically generate and send reports based on certain criteria.

I have realized that there is a problem with its navigation. I will post the code below but basically the form opens and begins to send emails...like it is supposed to.

What I have noticed is that when it is supposed to navigate to rst.movenext it appears to be skipping records. By skipping I can visually see it going through each record on the form, but only does sendobject on random records.

Any advise on what you can see would be great. I will post code and attach DB to better assist.

Thank you in advance for your help

Nick

展开 | 选择 | Wrap | 行号

推荐答案

你好，尼克。


我不会指望由于以下片段，此代码完全可用。

Hello, Nick.

I would not expect this code to work at all because of the following fragment.

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

在我尝试任何事情之前，我也会正确地填充你的recorset

I would also properly populate your recorset like so before I tried anything

展开 | 选择 | Wrap | 行号

您好，尼克。


我不会由于以下片段，我希望这段代码能够正常工作。



问候，

Fish

Hello, Nick.

I would not expect this code to work at all because of the following fragment.



Regards,
Fish

Fish，


为什么Timer会使代码不起作用？这一点是先前尝试减慢代码速度并允许sendobject在再次运行之前运行。


我确实试过取出定时器部分...需要rst.Movenext在记录集中移动。我添加了movelast，movefirst。我之前尝试过无济于事。此外，将它放在那里......如果没有记录，它不会导致错误吗？


Thanx的帮助，任何其他建议表示赞赏。


尼克

Fish,

Why would the Timer make the code not work? The point of that was a previous attempt to slow the code down and allow sendobject to run before attempting to run it again.

I did try both taking out the timer portion...need the rst.Movenext to move through the recordset. And I added movelast, movefirst. I previously attempted that with no avail. Also, placing it there...wouldn''t it cause an error if there are no records?

Thanx for the help, any other advice is appreciated.

Nick

这篇关于表单记录设置克隆导航失败！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！