By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,376 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Form Calculation writes record to Audit Log

P: n/a
I've implemented Allen Browne's Audit Log and it works quite well
(thanks). However, my form has a series of calculated fields that
fire on the form OnCurrent event. The calculation causes a record to
written to the Audit Log. This means that a log entry is created even
if users are only scrolling through the records.

Is there a way to block a log entry if the only form change is an auto
calculation?

Thanks in advance.

Dave

Sep 21 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Dave, I don't understand the need to alter stored fields in Form_Current.

If the user never visits the field, would your stored calculated fields by
*wrong*? If so, you should not store them in the table.

If visiting the field does not necessitate changing the fields, then
updating stored fields is unnecessary, and is the wrong approach.

AFACT, the problem is with whatever logic you are using that requires
changing the stored fields in Form_Current.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"FrozenDude" <ds*****@inco.comwrote in message
news:11**********************@d55g2000hsg.googlegr oups.com...
I've implemented Allen Browne's Audit Log and it works quite well
(thanks). However, my form has a series of calculated fields that
fire on the form OnCurrent event. The calculation causes a record to
written to the Audit Log. This means that a log entry is created even
if users are only scrolling through the records.

Is there a way to block a log entry if the only form change is an auto
calculation?

Thanks in advance.

Dave
Sep 21 '07 #2

P: n/a
If you alter bound fields, the form's BeforeUpdate event will fire, and so
the audit log code will be called.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"FrozenDude" <ds*****@inco.comwrote in message
news:11**********************@n39g2000hsh.googlegr oups.com...
>
Having said all that, is there a way to stop the audit log from
writing based on the auto-calculation? Many thanks.

Dave
Sep 28 '07 #3

P: n/a
On Sep 28, 11:06 am, "Allen Browne" <AllenBro...@SeeSig.Invalid>
wrote:
If you alter bound fields, the form's BeforeUpdate event will fire, and so
the audit log code will be called.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org."FrozenDude" <dsal...@inco.comwrote in message

news:11**********************@n39g2000hsh.googlegr oups.com...


Having said all that, is there a way to stop the audit log from
writing based on the auto-calculation? Many thanks.
Dave- Hide quoted text -

- Show quoted text -
Thanks, much appreciated and thanks for the online help, it's a
tremendous resource. Dave

Oct 1 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.