Hi to all,
I am developing a database where, with time, it proved to be necessary
to keep track of the changes to the data. It is fairly easy to keep
track of the time when a record was changed (afterupdate event)
-> Is there there a smart way of finding out which field has been
changed? I don't want to set a procedure on every field on the edit
form for keeping track of that, because the forms will be changed from
time to time.
Thanks in advance!
Uwe
2  4188 
Use the BeforeUpdate event of the form, not its AfterUpdate event. There is
no point in dirtying the record again immediately after is is saved.
When you use Form_BeforeUpda te, you can also compare the Value of each bound
control to its OldValue, to pick up the differences.
--
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.
"Uwe Range" <ur****@gmx.d e> wrote in message
news:64******** *************** ***@posting.goo gle.com...
I am developing a database where, with time, it proved to be necessary
to keep track of the changes to the data. It is fairly easy to keep
track of the time when a record was changed (afterupdate event)
-> Is there there a smart way of finding out which field has been
changed? I don't want to set a procedure on every field on the edit
form for keeping track of that, because the forms will be changed from
time to time.
Thanks in advance!
Uwe
Uwe Range wrote: Hi to all,
I am developing a database where, with time, it proved to be necessary
to keep track of the changes to the data. It is fairly easy to keep
track of the time when a record was changed (afterupdate event)
-> Is there there a smart way of finding out which field has been
changed? I don't want to set a procedure on every field on the edit
form for keeping track of that, because the forms will be changed from
time to time.
You can loop the Controls collection of a form; every control that has a
controlsource property also has an OldValue property. If that is not
equal to its Value, the control has changed.
--
Bas Cost Budde, Holland http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: d.schulz81 |
last post by:
Hi all,
We have about 10 different domains that are linked very closely and we
want to identify and keep track of every single user that surfs our
websites by the use of sessions.
The problem is how to keep track of the session ID across domains.
- cookies don't work because not acepted by 40 % of or users and
cookies don't work across domains
|
by: SQLDBA |
last post by:
What would be the best practice to follow to keep track of MS SQL
server changes... Stroed procs, tables, views, triggers, indexes, DTS
and also jobs ect....
I am not quite sure how Source safe works with sql server. Any other
way to do this... Even if its manual work, its okey.. I would
appreciate if any of the DBA's let me know how they are facing this
issue....
Thanks in advance...
|
by: cliff |
last post by:
Folks:
I am trying to find a best solution of the task of tracking the changes of a
xml file.
The scenrio is like this: we have a original copy of xml data. Clients
submit a new copy of xml data with changes (like new nodes or change text
values etc). What is the best approch to get a complete list of the changes
by using .net/C# code?
|
by: Daniel Walzenbach |
last post by:
Hi,
I need to track all changes made to an object. Consider the following class:
Public Class Dog
|
by: metaperl |
last post by:
I'm actually taking Microsoft's 2779 and just finished a lab where we
kept track of our changes to the database.
However, I'm not happy with the scripts interface because it does not
tell me the chronological order of my changes to the database.
Could someone share with me their technique for keeping track of
database changes?
I'm actually thinking a set of tables would be best, because sometimes
| | |
by: l3vi |
last post by:
I have a new system Im building that stores entries of what people are
searching for on my sites.
I want to be able to keep records of how many times a keyword was
searched for daily, and from that I can calculate weekly and monthly.
At this point I have one entry per search phrase with the number of
hits the search phrase has gotten, and the last time it was updated.
As I start to take the program out of testing and move in more...
|
by: Don Hobson |
last post by:
I am building a website and I want to allow users to do certain things
without logging in. I would like to allow them to keep track of certain
items, by adding them to a list.
Like if they are viewing multiple job listings in Houston, they can add each
job they care about to a list and when they are done looking at all the
jobs, they can view the list of say, 10 jobs. They can print the list or
email the list to themselves or someone...
|
by: PJ6 |
last post by:
What's the best way to, in the general case, track changes to an object's
public fields and properties? In a lot of applicatoins I've seen bahavior
consistant with simple periodic checking from a timer, or checking otherwise
initiated from a user event. I don't believe I can make that approach work
in the project I'm working on... are there other ways to do this, where I
can actually get an event raised on a field change, that don't involve...
|
by: Ken Fine |
last post by:
Hi,
I'm using the VS.NET 2008 website copy tool. It is supposed to keep track of
whether files are new, changed, or unchanged relative to a site on my
"remote" server. Most of the time it does not maintain that information
between sessions and the local and remote window indicates a "?" for the
state of each file. Can anyone speculate why this behavior happens? It
definitely makes the tool less easy to use.
Off-topic, but I wish...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
