UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Test For Whether A Form Has Been Editted, Office 2003    
 
   
Milster
post Jan 7 2011, 03:55 PM
Post #1

UtterAccess Addict
Posts: 157
From: Sydney, Australia
Hello
Is there a function that will return a true/false for whether a form has been changed?
Thanks
Go to the top of the page
 
+
lawmart
post Jan 7 2011, 04:32 PM
Post #2

UtterAccess VIP
Posts: 2,215
From: Vermont, USA
Do you mean the form's design has been changed? Or do you mean that the data on a form has changed?
Go to the top of the page
 
+
doctor9
post Jan 7 2011, 04:35 PM
Post #3

UtterAccess VIP
Posts: 9,440
From: Wisconsin
Milster,

Can you be more specific about what you're trying to do?

Are you referring to the actual design of a form? In that case, you may want to look at the .DateModified property of your form. That will tell you the date of the most recent change.

CurrentProject.AllForms("NameOfYourForm").DateModified

Hope this helps,

Dennis
Go to the top of the page
 
+
Milster
post Jan 7 2011, 04:44 PM
Post #4

UtterAccess Addict
Posts: 157
From: Sydney, Australia
Sorry. I meant when the data has changed whilst using a form. Not the design. I am aware of "Before Update" but just wanted to see if there was a function that could be called from a code module that returns a value for whether a change has happened or not.
Thanks
Go to the top of the page
 
+
trapperalexander
post Jan 7 2011, 04:51 PM
Post #5

UtterAccess VIP
Posts: 2,135
From: Plano, TX
check the .Dirty property of the form. there is also a Dirty Form Event which fires when the dirty property becomes TRUE.

hope this helps
Go to the top of the page
 
+
Milster
post Jan 7 2011, 05:00 PM
Post #6

UtterAccess Addict
Posts: 157
From: Sydney, Australia
You learn something every day. Thank you!
Go to the top of the page
 
+
trapperalexander
post Jan 7 2011, 05:31 PM
Post #7

UtterAccess VIP
Posts: 2,135
From: Plano, TX
glad we could be of assistance! good luck with your project (IMG:style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 04:39 PM