Results 1 to 4 of 4

can anybody explain dirty event to me?

  1. #1
    RedGoneWILD is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    105

    can anybody explain dirty event to me?

    i read this webpage but i still dont really understand what its purpose is. can anybody explain "dirty" to me in simple terms that a noob like me can understand? is it something that is necessary to have in my app?

    http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

  2. #2
    trb5016 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Location
    Pennsylvania
    Posts
    71
    My understanding (which could be wrong haha) is this:

    Since access doesn't "save" any changes until you go to a different record, press refresh, or close the form. Any changes the user makes "dirties" the form, but that change isn't actually transferred to the table until one of the above conditions is met.

    This allows you to make an undo button (as seen in the example on that site) because you can access what a controls current value is (if a user changed it) with the .Value property and you can access the old value (before the user changed it) with the .OldValue property.

    So no, unless you want to do something with reverting changes you don't need to use it on your forms, though it can be handy for the user depending one what kind of use your form is getting.

  3. #3
    RedGoneWILD is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    105
    okay...im not certain i need it, but we'll see...thanks for the reply!

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,896
    To add to the comments of trb5016, having "Dirty" in your application is not a choice. It is there IF you want to use it. It is both a Property and Event of forms that can be handy at times. Ignoring it will not cause you any problems.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Event Calendar Help
    By Nosaj08 in forum Forms
    Replies: 9
    Last Post: 06-11-2010, 11:19 AM
  2. Event procedures
    By GIS_Guy in forum Forms
    Replies: 1
    Last Post: 05-11-2010, 02:34 PM
  3. Delete and Dirty functions
    By Evgeny in forum Programming
    Replies: 3
    Last Post: 05-03-2010, 02:39 PM
  4. Could someone please explain to me what a Switchboard is
    By wabbalee in forum Database Design
    Replies: 2
    Last Post: 06-26-2009, 07:20 AM
  5. Replies: 21
    Last Post: 06-03-2009, 05:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums