On Dirty (1 Viewer)

missinglinq

AWF VIP
Local time
Today, 00:02
Joined
Jun 20, 2003
Messages
6,385
When a record is accessed, the first time any bound control on a bound form has data entered/edited, the form becomes Dirty and the OnDirty event is executed. Sounds simple, but this is Access, so naturally it isn't!

This occurs only the first time! If the same control has data entered a second time or another control has data entered, the form is still Dirty, but the OnDirty event will not execute again.

If data is entered into a Control thru VBA code, say

Me.MyTextbox = "Some Value"

or any other way except physically entering the data, the form will be Dirty, but the OnDirty event will not execute!

If data is entered into a Control thru VBA, as noted above, the form will be Dirty but subsequent physically entering data into the form will not cause OnDirty to execute.

Lastly, data entered by way of a control's Default Value while it 'enters' data, does not make the form Dirty and it does not cause the OnDirty event to fire.

Linq ;0)>
 
Last edited by a moderator:

mloucel

Member
Local time
Yesterday, 21:02
Joined
Aug 5, 2020
Messages
37
S... no wonder.. damn, any solution to this?
 

Isaac

Lifelong Learner
Local time
Yesterday, 21:02
Joined
Mar 14, 2017
Messages
2,022
Meaning what?
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 21:02
Joined
Aug 30, 2003
Messages
34,531
What specific problem are you trying to solve?
 

mloucel

Member
Local time
Yesterday, 21:02
Joined
Aug 5, 2020
Messages
37
Sorry ALL, I've been taking a class in ACCESS, but is so frustrating, it teaches you all the basics and some advanced techniques, but when you apply that to the real life of a real application is sort of worthless, so many holes, I explain that to our teacher and he really doesn't care, he says "You'll learn from the basics" SURE, you can teach someone to drive a car, but try with an 18 wheeler and your doom.
I would love to see a class that starts with basics.. OK, then create a full blown application, where Forms are used to enter the info, correct the info, mix tables of all sort, queries, and teach step by step what are the different techniques, but I live in a fantasy world.
I'm sure many of you agree with me, this is no way of teaching, here it is how FORMS are created. (period) compared to let's create a form that is going to enter data to 3 different tables linked, verify certain fields of the data don't exist on the current database, to add or, if data exists, then display the existing data, we will use a sub form, then some tabs and use combo boxes, buttons, etc.
That's a class/book/video I will buy, but so far, here is the ribbon, let's create a table, let's create a form from the table, let's add data to the table,..
SORRY for my rant, but is so frustrated, even the "ADVANCED" classes teaches you nothing of a real life Application, I just got a book recommended here that it looks very promising, besides the usual STUFF, it may go deeper creating an application and developing it fully, to reports easy and complex, I'll see what the future shows me.

Maurice.
 

Gasman

Enthusiastic Amateur
Local time
Today, 05:02
Joined
Sep 21, 2011
Messages
6,676
I know where you are coming from.

I have to use a Landlord computer system. They have video tutorials and a knowledgebase that helps you get to grips with the 'basics' of the system.
However it does not explain why you have to select certain entries and what happens when you do not. :-(

I am finding that out as an entry does not appear where I expect it to. :(

I think there are a good few events that are not executed if the control is modified by VBA instead of a user.? Not aware of the dirty event issue, but then I have never used it, so it has never affected me.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom