Hello All
Can you please help me with a problem, I'm only looking for a starting point
as I am a long way from even knowing exactly what I want to do. Here's the
basics anyway, any help much appreciated.
I have a database table containing a schedule, Dates, Locations, Who, Job
Details etc.This information can be entered in a variety of ways, via forms,
queries, and directly into the table. Records can be edited, added or
deleted as the plan changes.
I would like to be able to run a query that lists all the changes made to
the table since a certain date and time. (i.e. list all the records that
have been deleted, added or changed since yesterday)
I have a feeling that I may have to change the way we enter data so that it
is always in a form, thus enabling a way of coding actions when items are
changed, deleted or added ? Also I imagine this code would in fact be
populating a new table with the changes so that deleted record information
can be copied to it? But though I would check first to see if I am
reinventing a wheel that Bill has already built in to the guts of access?
Regards
Steve
1  1719 
"Steve Lilley" <st******@nospa m.hotmail.com> wrote in message news:<xm******* **********@news .cpqcorp.net>.. . Hello All
Can you please help me with a problem, I'm only looking for a starting point
as I am a long way from even knowing exactly what I want to do. Here's the
basics anyway, any help much appreciated.
I have a database table containing a schedule, Dates, Locations, Who, Job
Details etc.This information can be entered in a variety of ways, via forms,
queries, and directly into the table. Records can be edited, added or
deleted as the plan changes.
I would like to be able to run a query that lists all the changes made to
the table since a certain date and time. (i.e. list all the records that
have been deleted, added or changed since yesterday)
I have a feeling that I may have to change the way we enter data so that it
is always in a form, thus enabling a way of coding actions when items are
changed, deleted or added ? Also I imagine this code would in fact be
populating a new table with the changes so that deleted record information
can be copied to it? But though I would check first to see if I am
reinventing a wheel that Bill has already built in to the guts of access?
Regards
Steve
Steve,
yes, you'll have to disallow users direct access to tables, and
probably action queries too. Then you'll have to write to a log table
before your events do anything. I think Allen Browne has code for it
on his website. It's like "event Logger" or something.
HTH,
Pieter This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Ben |
last post by:
I have looked around for this but I seem to be missing something. I
have a forum based on a query that brings display some table info in
tabular form. What I would like to do is prevent the user from adding
records or modifying certain columns.
Example: My headings are: First Name, Last Name, Time, Penalty, and
Total.
The First and Last Should not be edited in this form. Only Time and
Penalty should be edited here. The total column just...
|
by: Scott |
last post by:
In my database, I have a form with a subform. I had everything working
correctly - the correct records would display on the subform for each
record on the form. I could edit, add, and delete on the subform.
I added a field to my table, and modified the design of my subform. Now,
data is not getting displayed on the subform for any form records. I did
not change any properties.
I'm on XP Pro and using MS Office 2000 Pro.
|
by: ethanj /personal/ |
last post by:
We are using Access 2000 database, with the following settings.
Tool > Options > Advance >
Default Record Locking = Edited Record
Open databases using record level locking = True
Form property >
RecordLock = Edited Record.
However, the record is still NOT locked. Multiple users can still open
|
by: cbremar |
last post by:
Is there a way to do this. Currently, you can have multiple users
editing the same record and not until they try to save it does it tell
you that the record is being edited by another person. I want to make
the record 'non-viewable' is it's already being edited by another user.
Can anyone help?
|
by: AA Arens |
last post by:
Hi,
I have a database with 2 main forms. Contacts and companies. I share
the base with two others via LAN. On the companies form I have buttons
to navigate throught the records
(>400). We are mostly handling let say 5 companies. Every time I have
to navigate or choose the find record button to get the right company.
I am looking fo a feature to have listed in a combo list the last 5
visited records ("recently visited records").
| | |
by: JA |
last post by:
Hi,
I asked this in an MS Access newsgroup, but no one has answered. Since it
also applies to SQL Server, maybe someone in here has an answer? I actually
do have the same problem in both SQL Server 2000 and Access 2000.
When I click in certain records in a memo field, I get the error message
"text too long to be edited", and I can't get into the record to make any
changes.
|
by: DanThMan |
last post by:
The situation:
* I have a ButtonColumn in a DataGridView.
* When the user preses one of the buttons, a dialog appears.
* Based on what the user selects in the dialog, data is entered
programmatically into the the underlying cell (i.e., I'm setting Value
property of the cell based on user input, but the user is not directly
entering any data).
The problem:
|
by: =?Utf-8?B?UHJhdmlu?= |
last post by:
We are using .net Framework 1.1
We are having one page on which we are using this Grid component.
From this page we open a popup for adding new record as well as for editing
an existing record (For Edit we want to pass the ID of that particular row)
And when user clicks on 'SAVE' button in popup window, those changes need to
be reflected onto the parent (into the Grid). This happens by refreshing the
parent page. But in that case all...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
