Tracking changes/additions for another user

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, all. I am a _relative_ newbie (good with Access, new to VB) and cannot figure out the best way to handle this

I have a main table Contracts with related table Contract Details. A number of people enter data into both for their own area of work. We now have two areas that are 'partners', and a 'programID' and a 'partnerID' field are both in the main Contracts table. When times,locations, and dates change for Area1 they *almost always* change the same way for Area2. For example, Kroger orders programs for 10 of its stores, and later adds 15 more stores, and changes one of the original's dates to a later date. This time/date/store data is all stored in Contract Details.

I need to have a fairly simple way to add the new/changes for both program and partner. I am good with macros, and devised a quick one for now (on a form for an UpdateContracts table, strictly for this use) to just to add new Contract Details to the main program, but I'd like to have a way to choose a bunch of records and add to program and partner at the same time, also a way to make changes to both at the same time. Add and Change need to be done separately, because sometimes there is only an addition, sometimes there are only changes in records that already exist. It would be REALLY great if I could run this from the forms they already use for data entry, but how would it track changes and additions

Sorry so lengthy, but I wanted to give enough description. I have been thinking til my brain hurts and trying stuff for 2 weeks (on and off, of course :). Please help!! Thanks!
 
Hi,

Check out:
ACC2000: How to Create an Audit Trail of Record Changes in a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;197592

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: Tracking changes/additions for another user
| thread-index: AcQNCTPylRI5qS4HT3yOqNg5xDtyUw==
| X-Tomcat-NG: microsoft.public.access.formscoding
| From: "=?Utf-8?B?Q2F0IFdpbnNsb3c=?=" <[email protected]>
| Subject: Tracking changes/additions for another user
| Date: Thu, 18 Mar 2004 08:51:05 -0800
| Lines: 7
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.formscoding
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.formscoding:225176
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.formscoding
|
| Hi, all. I am a _relative_ newbie (good with Access, new to VB) and
cannot figure out the best way to handle this.

I have a main table Contracts with related table Contract Details. A number
of people enter data into both for their own area of work. We now have two
areas that are 'partners', and a 'programID' and a 'partnerID' field are
both in the main Contracts table. When times,locations, and dates change
for Area1 they *almost always* change the same way for Area2. For example,
Kroger orders programs for 10 of its stores, and later adds 15 more stores,
and changes one of the original's dates to a later date. This
time/date/store data is all stored in Contract Details.

I need to have a fairly simple way to add the new/changes for both program
and partner. I am good with macros, and devised a quick one for now (on a
form for an UpdateContracts table, strictly for this use) to just to add
new Contract Details to the main program, but I'd like to have a way to
choose a bunch of records and add to program and partner at the same time,
also a way to make changes to both at the same time. Add and Change need to
be done separately, because sometimes there is only an addition, sometimes
there are only changes in records that already exist. It would be REALLY
great if I could run this from the forms they already use for data entry,
but how would it track changes and additions?

Sorry so lengthy, but I wanted to give enough description. I have been
thinking til my brain hurts and trying stuff for 2 weeks (on and off, of
course :). Please help!! Thanks!
|
 
Thanks, Eric! I actually found a similar item from Allen Browne to do this part, and it is working. I now have a tracking of what has been changed already.

My issue is really more than that. When the person adds or changes records for their own Program1, I'd like to give them a button to click that will *also* copy the additions (fairly simple) and the changes (not, for me) to the table a second time so that the Program2 guy doesn't have to change all his data manually. The main form has fields Program (Program1....Program5) and Co-Program (currently only Program2) fields that are in the same table Contracts. The changes are in the subform fields such as Date, TimeSlot, Truck#, etc, that both programs use, and these fields are in the related table ContractDetails. So, I can now _track_ the changes, but I still need to be able to copy them to the second guy's data..

Any help is sooo appreciated! Ca
(PS - i am getting veerrrry sleeeeeepy.. i'll check back in the mornin' :
 
Back
Top