Hi all,
I notice that the Form_Dirty event does not fire in Access 2002 (SP-1) when
the first character is typed into a new record. In previous versions of
Access it does fire.
For existing records that are being edited, the event does fire.
Has this (previous) behaviour been changed by Microsoft?
HJ 9 4006
I'm not seeing this behavior in Access 2002 SP3.
Are you sure the record is not being dirtied programmaticall y?
--
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.
"HJ" <hj********@spa mhotmail.com> wrote in message
news:41******** *************** @dreader16.news .xs4all.nl... Hi all,
I notice that the Form_Dirty event does not fire in Access 2002 (SP-1) when the first character is typed into a new record. In previous versions of Access it does fire.
For existing records that are being edited, the event does fire.
Has this (previous) behaviour been changed by Microsoft?
HJ
The OnDirty event only fires for bound controls, and bound forms. Also, if
VBA code makes any change to a bound form, it can prevent the Dirty event
from firing unless you specifically set Dirty to False after your code
executes.
Darryl Kerkeslager
"HJ" <hj********@spa mhotmail.com> wrote: I notice that the Form_Dirty event does not fire in Access 2002 (SP-1)
when the first character is typed into a new record. In previous versions of Access it does fire.
Hi,
Thanks for responding. The form is bound to a table and it is not being
dirtied programmaticall y; I am 'just' entering a new record. That means that
both the BeforeInsert and the Dirty event should fire. The BeforeInsert
event does fire, the Dirty one does not.
I have now also seen this behaviour on another form that does not have a
BeforeInsert event. Here too the Dirty event does not get fired.
Still, this only happens in Access 2002. In Access 2000 the Dirty event gets
fired all the time (and I like that!).
HJ
"Darryl Kerkeslager" <Ke*********@co mcast.net> wrote in message
news:B8******** ************@co mcast.com... The OnDirty event only fires for bound controls, and bound forms. Also,
if VBA code makes any change to a bound form, it can prevent the Dirty event from firing unless you specifically set Dirty to False after your code executes.
Darryl Kerkeslager
"HJ" <hj********@spa mhotmail.com> wrote: I notice that the Form_Dirty event does not fire in Access 2002 (SP-1) when the first character is typed into a new record. In previous versions of Access it does fire.
I have not seen this behavior (Thankfully). I use A2002, but save my mdb as
A2000 for compatibility. Perhaps that is the difference.
Darryl Kerkeslager
"HJ" <hj********@spa mhotmail.com> wrote: Still, this only happens in Access 2002. In Access 2000 the Dirty event
gets fired all the time (and I like that!).
Nope, same here. I am quite stumped. The workaround is, of course, to call
the Dirty event from the BeforeInsert event, but that does not really solve
the initial problem.
HJ
"Darryl Kerkeslager" <Ke*********@co mcast.net> wrote in message
news:FL******** ************@co mcast.com... I have not seen this behavior (Thankfully). I use A2002, but save my mdb
as A2000 for compatibility. Perhaps that is the difference.
"Darryl Kerkeslager" <Ke*********@co mcast.net> wrote in
news:FL******** ************@co mcast.com: I have not seen this behavior (Thankfully). I use A2002, but save my mdb as A2000 for compatibility. Perhaps that is the difference.
The "dirty event" exists only *after* A2K, no (as opposed to the
"dirty property/method")?
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Darryl Kerkeslager wrote: The OnDirty event only fires for bound controls, and bound forms. Also, if VBA code makes any change to a bound form, it can prevent the Dirty event from firing unless you specifically set Dirty to False after your code executes.
Setting Dirty to false will force a save of the record, not good if
you're just starting out and there are required fields not yet entered.
--
This sig left intentionally blank
"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:Xn******** *************** ***********@24. 168.128.78... "Darryl Kerkeslager" <Ke*********@co mcast.net> wrote in news:FL******** ************@co mcast.com:
I have not seen this behavior (Thankfully). I use A2002, but save my mdb as A2000 for compatibility. Perhaps that is the difference.
The "dirty event" exists only *after* A2K, no (as opposed to the "dirty property/method")?
It's on Microsoft's "What's New" page for Access 2000. http://msdn.microsoft.com/library/de...a2000intro.asp
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
True. I usually fill all required fields in first by code, or set a default
value.
Darryl Kerkeslager
"Trevor Best" <no****@besty.o rg.uk> wrote: Darryl Kerkeslager wrote: The OnDirty event only fires for bound controls, and bound forms. Also,
if VBA code makes any change to a bound form, it can prevent the Dirty
event from firing unless you specifically set Dirty to False after your code executes.
Setting Dirty to false will force a save of the record, not good if you're just starting out and there are required fields not yet entered. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Noesis Strategy |
last post by:
When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles.
Recently, I have begun to design Access databases using an copy of Access
2002 from my previous laptop. It works fine, but I would like to have all
the office apps on the same version. So I have a few questions:
1) Is the file format the same as 2002? Can 2002 users read 2003 files?
2) What are the major reasons for upgrading to 2002 ?
|
by: Peter Frost |
last post by:
Please help
I don't know if this is possible but what I would really like to do is
to use On Error Goto to capture the code that is being executed when
an error occurs.
Any help would be much appreciated.
Thanks in advance
|
by: Bruce Dodds |
last post by:
I will be doing an app for a nonprofit. It would be useful for them to
have a good entry-level book on Access so that they don't have to pay
someone to design all their queries and reports. I'm not familiar with
those books. Does anyone have a recommendation?
TIA.
|
by: David Kistner |
last post by:
I'm fairly new to Access (I've worked with Oracle and MySQL in the
past). I was asked to build an application for a small office and told
that I had to use Access 2002. I was VERY uncomfortable with this, but
went ahead anyway. So two weeks ago we rolled out the new system and
I'm still wondering how robust Access is......I know it's not in the
same league as Oracle, but at the same time this isn't a real big
application. But I can't...
|
by: Neil Ginsberg |
last post by:
I have a strange situation using Access to automate a Word mail merge. Using
Access 2000 and Word 2000, the code opens Word, opens the document in Word,
sets a table
in the calling Access application as the data source, and then performs a
merge. Everything works fine.
However, when a user uses it in Access 2002 and Word 2002, an extra instance
of the Access application is opened and remains open at the end. Sometimes
it remains open
| |
by: Randy Harris |
last post by:
I'm using the Form_Dirty event to enable a Save button. There are quite a
few users using the app with no problem. One user is complaining that no
matter what she does the Save button doesn't get enabled. It looks as
though the Form_Dirty event isn't firing.
The application is developed in A2K, the user is using A2K3 (as are a bunch
of other users who aren't experiencing the problem).
Anyone have any idea what might be wrong on this...
|
by: Niklas Uhlin |
last post by:
Someone please explain why Session_Start fires multiple times /
retains SessionID values between sessions, when you open an ASP.NET
page from MS Word. For details of the problem, see below:
1. Create a new C# ASP.NET web application named "demo" and modify
Session_Start in Global.asax.cs as follows:
protected void Session_Start(Object sender, EventArgs e)
{
Response.Write("Session_Start event fired at "+
|
by: lindseyhansen |
last post by:
Access 2000 with linked tables to SQL Server 2000:
I have a form where I am trying to update a date field when any of the
fields for the current saved record get changed. I am using the
form_dirty event to set this date. I have one database (mdb) where
this works fine. I tried to duplicate the same behavior in a second
mdb, and it causes the form_dirty event to fire at least a hundred
times before it finally 'completes'. This is a...
|
by: Sebastian |
last post by:
Hello
I develop my applications in Access 2002. My development system is
running Windows XP SP2 and I have Microsoft Office XP Developer.
Microsoft Office XP is at SP3.
I used Inno Setup (great product) to install my applications.
When the Access Runtime was needed on the system I simply ran
'accessrt.msi' from Microsoft Office Developer discs.
When another version of Access (other than Access 2002) was on the
system then I simply...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |