A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Keeping Track of Revisions



 
 
Thread Tools Display Modes
  #1  
Old September 15th, 2004, 08:07 PM
CK
external usenet poster
 
Posts: n/a
Default Keeping Track of Revisions

I have 2 tables that are linked: Proforma Invoice and Items Ordered. For one
Proforma Invoice, there could be many items ordered. The challenge is that I
need to maintain some kind of revision when any of those information are
changed like additional items, change in color, change in delivery dates, etc
and they could be in any of those 2 tables.

Is there any way I can do a "snapshot" of the data and store that into
another table since changing the values in the fields means overwriting the
previous info? Or is anyone able to suggest a better way? Thanks.
ck
  #2  
Old September 16th, 2004, 01:52 AM
Eric Butts [MSFT]
external usenet poster
 
Posts: n/a
Default

Hi,

Why not use solution similar to following:

How to create an audit trail of record changes in a form in Access 2000
http://support.microsoft.com/?kbid=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

"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: Keeping Track of Revisions
| thread-index: AcSbVzHBtxTVYozjSzC0N1pLfW5Pvg==
| X-WBNR-Posting-Host: 192.169.41.40
| From: "=?Utf-8?B?Q0s=?="
| Subject: Keeping Track of Revisions
| Date: Wed, 15 Sep 2004 12:07:07 -0700
| Lines: 10
| Message-ID:
| 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.tablesdbdesign
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:83960
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| I have 2 tables that are linked: Proforma Invoice and Items Ordered. For
one
| Proforma Invoice, there could be many items ordered. The challenge is
that I
| need to maintain some kind of revision when any of those information are
| changed like additional items, change in color, change in delivery dates,
etc
| and they could be in any of those 2 tables.
|
| Is there any way I can do a "snapshot" of the data and store that into
| another table since changing the values in the fields means overwriting
the
| previous info? Or is anyone able to suggest a better way? Thanks.
| ck
|

  #3  
Old September 16th, 2004, 08:11 AM
CK
external usenet poster
 
Posts: n/a
Default

Thanks, Eric. Let me give that a shot.
ck


  #4  
Old September 16th, 2004, 08:33 AM
CK
external usenet poster
 
Posts: n/a
Default

Eric,
I've copied and pasted the code but I keep getting this error when I changed
a field and save the form:

Error#: 2447
Description: There is an invalid use of the .(dot) or ! operator or invalid
parentheses.

ck



  #5  
Old September 19th, 2004, 09:03 PM
Eric Butts [MSFT]
external usenet poster
 
Posts: n/a
Default

Hi,

You may need to step through the code to see where it's failing. It might
be failing on

Select Case C.ControlType

You might have a Control on your Form that does not have .ControlType as
it's property.

Regards,

Eric Butts
Microsoft Access Support

"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: Keeping Track of Revisions
| thread-index: AcSbv2i5vEGuBspKQ9eCvwfMmNyXGg==
| X-WBNR-Posting-Host: 192.169.41.40
| From: "=?Utf-8?B?Q0s=?="
| References:

| Subject: Keeping Track of Revisions
| Date: Thu, 16 Sep 2004 00:33:07 -0700
| Lines: 12
| Message-ID:
| 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.tablesdbdesign
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:83975
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Eric,
| I've copied and pasted the code but I keep getting this error when I
changed
| a field and save the form:
|
| Error#: 2447
| Description: There is an invalid use of the .(dot) or ! operator or
invalid
| parentheses.
|
| ck
|
|
|
|

  #6  
Old September 21st, 2004, 11:13 AM
CK
external usenet poster
 
Posts: n/a
Default

Thanks Eric,
I think you are pretty close with your observation. Only problem is: how do
I know which controls have the .ControlType property and which ones do not
have?
ck


  #7  
Old September 21st, 2004, 10:43 PM
Eric Butts [MSFT]
external usenet poster
 
Posts: n/a
Default

Hi,

Put a break point on the line
Set MyForm = Screen.ActiveForm

and step through the code until you get to the error.

- To add a break point right click on the above line and select Toggle
Breakpoint
- Run the code
- Once you get to the breakpoint press F8 until you get to the error

Regards,

Eric Butts
Microsoft Access Support

"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: Keeping Track of Revisions
| thread-index: AcSfw5PmUQeyxfzLQSiESgRQCOoS9A==
| X-WBNR-Posting-Host: 192.169.41.40
| From: "=?Utf-8?B?Q0s=?="
| References:



| Subject: Keeping Track of Revisions
| Date: Tue, 21 Sep 2004 03:13:02 -0700
| Lines: 7
| Message-ID:
| 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.tablesdbdesign
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:84133
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Thanks Eric,
| I think you are pretty close with your observation. Only problem is: how
do
| I know which controls have the .ControlType property and which ones do
not
| have?
| ck
|
|
|

  #8  
Old January 12th, 2005, 07:49 PM
Dougm
external usenet poster
 
Posts: n/a
Default

Hello, I also have this same issue, however I need the changes recored in a
seperate audit table. the code you referenced above inserts the data into a
memo field. how would you go about adding the records into a seperate table.

"Eric Butts [MSFT]" wrote:

Hi,

Put a break point on the line
Set MyForm = Screen.ActiveForm

and step through the code until you get to the error.

- To add a break point right click on the above line and select Toggle
Breakpoint
- Run the code
- Once you get to the breakpoint press F8 until you get to the error

Regards,

Eric Butts
Microsoft Access Support

"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: Keeping Track of Revisions
| thread-index: AcSfw5PmUQeyxfzLQSiESgRQCOoS9A==
| X-WBNR-Posting-Host: 192.169.41.40
| From: "=?Utf-8?B?Q0s=?="
| References:



| Subject: Keeping Track of Revisions
| Date: Tue, 21 Sep 2004 03:13:02 -0700
| Lines: 7
| Message-ID:
| 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.tablesdbdesign
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:84133
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Thanks Eric,
| I think you are pretty close with your observation. Only problem is: how
do
| I know which controls have the .ControlType property and which ones do
not
| have?
| ck
|
|
|


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
keeping track of "Escaped" Autonumber records Paul James Using Forms 7 September 28th, 2004 12:06 AM
Keeping track of changes Thrava General Discussion 1 August 18th, 2004 01:33 AM
Track changes show up after accepting changes pd General Discussion 1 June 18th, 2004 11:14 PM
Keeping track of hours Tom Hines Worksheet Functions 1 October 16th, 2003 04:56 AM


All times are GMT +1. The time now is 12:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.