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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thanks, Eric. Let me give that a shot.
ck |
#4
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |