Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / February 2007

Tip: Looking for answers? Try searching our database.

me.dirty doesn't seem to fire

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PeterW - 18 Feb 2007 19:37 GMT
I am using the me.dirty property of a form to enable a save button to
highlight changes have been made. This seems to work fine except on the first
record shown by the form. When the form is opened at the first record any
change will make the button enabled and this will continue to work until I
update a field using a calendar control. After this the button appears
disabled and any alteration to the form doesn't seem to trigger the event
again. If I move to any other record all works fine
Anybody any ideas?
Stefan Hoffmann - 18 Feb 2007 22:45 GMT
hi Peter,

> I am using the me.dirty property of a form to enable a save button to
> highlight changes have been made.
You may also query Me.NewRecord.

mfG
--> stefan <--
Allen Browne - 19 Feb 2007 02:44 GMT
Peter, you are using the form's Dirty event procedure to enable your button?
(The form's Dirty property is a yes/no value.)

At least in some versions of Access, the Dirty event doesn't fire if the
record is dirtied programmatically. Therefore I would assume that whatever
is happening with your calendar control, it is dirtying the record, so the
Dirty event doesn't fire, so the button doesn't get enabled.

If that's the case, the solution will involve tracking down why the record
is being dirtied unnecessarily, and fixing that problem.

Signature

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.

>I am using the me.dirty property of a form to enable a save button to
> highlight changes have been made. This seems to work fine except on the
[quoted text clipped - 5 lines]
> again. If I move to any other record all works fine
> Anybody any ideas?
PeterW - 19 Feb 2007 11:35 GMT
Thanks for your help - what is confusing me is that this only happens with
the first record in the set - if I move to another record then everything
works fine

> Peter, you are using the form's Dirty event procedure to enable your button?
> (The form's Dirty property is a yes/no value.)
[quoted text clipped - 16 lines]
> > again. If I move to any other record all works fine
> > Anybody any ideas?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.