Audit log for 1 field

Hi. I am trying to create an audit log for a "tasks" database.I used Allen
Browne's code and got it working on a very simple test database. When I try
to do the exact thing in my production database, it gets stuck at:

 'Remove any cancelled update still in the tmp table.
    Set db = DBEngine(0)(0)
    sSQL = "DELETE FROM " & sAudTmpTable & ";"
    db.Execute sSQL

My production form has alot on it (combo lookups, date pickers, option groups,
and some code behind some text boxes, etc). Would this affect it? I'm really
only interested in tracking changes from 1 field. How can I modify Allen's
code to do this and stop erroring out?

Thanks!

0
BenEl
11/24/2009 9:18:58 PM
access.forms 6864 articles. 2 followers. Follow

6 Replies
1113 Views

Similar Articles

[PageSpeed] 25

What does "gets stuck" mean? Do you get an error? If so, what's the error?

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"BenEl" <u56454@uwe> wrote in message news:9f9c5f2324d32@uwe...
> Hi. I am trying to create an audit log for a "tasks" database.I used Allen
> Browne's code and got it working on a very simple test database. When I 
> try
> to do the exact thing in my production database, it gets stuck at:
>
> 'Remove any cancelled update still in the tmp table.
>    Set db = DBEngine(0)(0)
>    sSQL = "DELETE FROM " & sAudTmpTable & ";"
>    db.Execute sSQL
>
> My production form has alot on it (combo lookups, date pickers, option 
> groups,
> and some code behind some text boxes, etc). Would this affect it? I'm 
> really
> only interested in tracking changes from 1 field. How can I modify Allen's
> code to do this and stop erroring out?
>
> Thanks!
> 


0
Douglas
11/24/2009 10:23:04 PM
"Syntex error in FROM clause".

I don't understand this error, because the code is copied straight from
Allen's website and worked perfectly in my test dbase.


Douglas J. Steele wrote:
>What does "gets stuck" mean? Do you get an error? If so, what's the error?
>
>> Hi. I am trying to create an audit log for a "tasks" database.I used Allen
>> Browne's code and got it working on a very simple test database. When I 
>[quoted text clipped - 14 lines]
>>
>> Thanks!

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200911/1

0
BenEl
11/25/2009 2:08:57 PM
If sAudTmpTable contains special characters (which includes spaces), try

sSQL = "DELETE FROM [" & sAudTmpTable & "];"

If it doesn't, what's the actual content of sSQL when the code fails?


-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"BenEl via AccessMonster.com" <u56454@uwe> wrote in message 
news:9fa530926c82e@uwe...
> "Syntex error in FROM clause".
>
> I don't understand this error, because the code is copied straight from
> Allen's website and worked perfectly in my test dbase.
>
>
> Douglas J. Steele wrote:
>>What does "gets stuck" mean? Do you get an error? If so, what's the error?
>>
>>> Hi. I am trying to create an audit log for a "tasks" database.I used 
>>> Allen
>>> Browne's code and got it working on a very simple test database. When I
>>[quoted text clipped - 14 lines]
>>>
>>> Thanks!
>
> -- 
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200911/1
> 


0
Douglas
11/25/2009 3:51:27 PM
So that worked! Now I'm getting the error:

" SELECT* can not be used in an INSERT INTO query where the source or
destination table contains a multivalued field".

I have a few of these. I don't want to capture the changes for these fields.
How can I adopt the code to only look at one specific field?

Thanks.


Douglas J. Steele wrote:
>If sAudTmpTable contains special characters (which includes spaces), try
>
>sSQL = "DELETE FROM [" & sAudTmpTable & "];"
>
>If it doesn't, what's the actual content of sSQL when the code fails?
>
>> "Syntex error in FROM clause".
>>
>[quoted text clipped - 9 lines]
>>>>
>>>> Thanks!

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200911/1

0
BenEl
11/25/2009 6:40:17 PM
In AuditEditEnd,  you have to change sSQL so that it picks selected fields, 
not *.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"BenEl via AccessMonster.com" <u56454@uwe> wrote in message 
news:9fa78f1eb9a06@uwe...
> So that worked! Now I'm getting the error:
>
> " SELECT* can not be used in an INSERT INTO query where the source or
> destination table contains a multivalued field".
>
> I have a few of these. I don't want to capture the changes for these 
> fields.
> How can I adopt the code to only look at one specific field?
>
> Thanks.
>
>
> Douglas J. Steele wrote:
>>If sAudTmpTable contains special characters (which includes spaces), try
>>
>>sSQL = "DELETE FROM [" & sAudTmpTable & "];"
>>
>>If it doesn't, what's the actual content of sSQL when the code fails?
>>
>>> "Syntex error in FROM clause".
>>>
>>[quoted text clipped - 9 lines]
>>>>>
>>>>> Thanks!
>
> -- 
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200911/1
> 


0
Douglas
11/25/2009 8:14:20 PM
Thanks. Unfortunately the user has decided that they would now like to be
able to modify past entries...Onto a new tactic!

Douglas J. Steele wrote:
>In AuditEditEnd,  you have to change sSQL so that it picks selected fields, 
>not *.
>
>> So that worked! Now I'm getting the error:
>>
>[quoted text clipped - 18 lines]
>>>>>>
>>>>>> Thanks!

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200911/1

0
BenEl
11/30/2009 6:17:22 PM
Reply:

Similar Artilces:

Multiple users/1 email address
Environment: Exchange 2003 SP1 on a Windows 2000 box and Outlook 2003. I have 5 users (each has his own active directory acct and log on as themselves) that need to share a common email address i.e. someone@somewhere.de.us. When each user opens Outlook, I need them to see any emails delivered to the shared email address. How can this be accomplished? Thank you in advance, L Moore You could either have a mailbox for someone@somewhere.de.us, give the users rights to it and set their Outlook to open that mailbox as well as their own mailbox. Or you could make a mail enabled public fo...

Cannot Promote E-mail from InBox in CRM 1.2
Hello! We have a successful installation of CRM 1.2, but we have been unable to use the "Promote to CRM Activity" feature in SFO. We have installed many of the updates and hot-fixes, but we continue to have this problem. The error shuts down Outlook, and points to the CRMADDIN.DLL add-in. We've removed it and re-installed it several times, but continue to have the same problem. Is there something we are missing, since I do not see many others with this type of problem. Thank you kindly, John what error do you get? also have you verified the problem the user is reporting...

add duration field of multiple appointments
I'm curious what the best method for adding duration fields of appointments. If the answer consists of exporting to excel....how can I manipulate the data effecitively. I've tried multiple ways but not getting good results. Thanks. Do you mean in recurring appointments or for several individual appointments? What is the desired result? The duration is calculated from the start and end date - its not something you'd change directly. If we know what your plan is, we might have other suggestions. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-...

How can I format a cell so date field only displays the Month?
I'd like to have cells with date fields only display the Month. Instead of MM-YY or MM-DD-YY...I'm looking for just MMMM. Thank you. On Fri, 3 Dec 2004 16:35:01 -0800, "tk_2u" <tk_2u@discussions.microsoft.com> wrote: >I'd like to have cells with date fields only display the Month. Instead of >MM-YY or MM-DD-YY...I'm looking for just MMMM. >Thank you. Format/Cells/Number Custom: mmmm --ron Right-click on the cell with the date in it > FormatCells > NumberTab > Custom > ..type MMMM in the window Vaya con Dios, Chuck CABGx3 "t...

=?iso-8859-1?Q?lost_email_message_in_=22Outlook_Today=22_folder?=
I accidentally dragged/dropped an email message into the "Outlook Today" (root) folder. It seems to have disappeared.does anyone know how to retrieve it? Thanks ...

Outlook 2000 SR-1 POP3 Server Error Number: 0x800ccc0d
I have the following setup. 1. Laptop with Windows XP Professional SP1 2. Outlook 2000 SR-1 3. Mail Server: Merak Mail Server 4. Three email-ids@xx.com with one domain(SMTP: mail.xx.com; POP3: mail.xx.com) 5. One email-id@yy.com with second domain (SMTP: mail.yy.com; POP3: mail.xx.com) ; 6. Merak is configured for both the domains(for multiple domains) Till two days ago everything was fine. From 9/8/2004 my Outlook 2000 started giving problems in receving emails for one of four email-ids with the following error: Unable to connect to the server. (Account: 'MY SERVER INFORMATI...

Error installing Lookout 1.2
Downloaded Lookout 1.2 from MS website, and installed it. Opened Outlook 2K3 SP1, and get the following error: "You may have recieved an error message about "Exchange Extensions". Lookout can try top repair this file for you by repairing your HKLM\SOFTWARE\Microsoft\Exchange\Client\Extensions\Exchang e Extensions setting. Details will be logged in case you want to undo the repair. Would you like to repair it now? y/n" The install for Lookout went fine, with no errors, and Outlook was not loaded at the time. Can't find this error referenced anywhere. Should I ha...

Query keeps looking for Query1 field
Okay... so I have this bad habit of saving queries as Query1, Query2, etc if I have not completed them and I get interrupted. It helps me get back to the incomplete work faster/easier. I have a DB that began as an Access 2007 DB (.accdb) and was converted down to an Access 2003 DB (.mdb). Since then, these queries that began their life as Query1, Query2... keep asking for fields from their old query name. I have looked in the SQL, the Parameters, etc but can find no reference to the old query name. One solution is to copy and paste the SQL into an empty query and save it w...

How can I create a multiple field search box? (corrected post)
Hi, I need assistance in creating a multiple field search box, i have a screen shot but i couldn't find a way to include it in this message. I have been battling with this problem for weeks. the search box was created in foxpro, i'm trying to create a similar search box in ms access 2003. it searches only one table so each table has a search box for it. Here is a description for the search box for the community table which is one of the tables in the database. It has a drop down list that selects all the fields in the table such as area code for the community, community code, and com...

MS Outlook worked for 3 yrs 11 mos... then 550 5.7.1 ERROR. Fix??
MS Outlook 2003 Pro worked for 3 yrs 11 mos... then yesterday, 01/08/2010: 550 5.7.1 <e-mail address>... Relaying denied. Proper authentication required. As a result, I cannot send e-mail to anyone. My newer computer's OS is Windows XP Pro. Also, the SAME error occurred on my older computer (also MS Outlook 2003 Pro) when I booted it up to send e-mail, also under Outlook 2003 Pro. My older computer's OS is Windows 2000 Pro. The two computers are NOT connected. I haven't changed anything on either computer. The last successful 2003 Outlook update was mo...

2 columns -> 1 column
Hello all I have 2 columns and i want to make a 1 column as follows: a b a c d b e f => c g h d i j e .. f .. g .. h .. i .. j Any help would be appreciated. Danny Hi Danny, On another worksheet you can refer to the first by it's s...

starting OL 2000 with the /prefetch:1 command line switch
I have just become aware of the: /prefetch:1 command line switch to make applications start faster. For some reason, it works on my OE 6 program (and many others I have installed on my Pentium IV PC running XP Home SP2) but not on my OL 2000 program. When I start OL2000 with the following command line: "E:\Microsoft Office\Outlook2000\Office\OUTLOOK.EXE" /prefetch:1 I get an error message that says: the command line argument is not valid. Verify the switch you are using. Any ideas? Jay J <sonrisa322@comcast.net> wrote: > When I start OL2000 with the follo...

Delete persons from the to field i Outlook 2002
Hello, How do I delete a name from my automatic drop down menu in the to field. If I send a mail to fx. microsoft@microsoft.com, the next time I write mic... in the to field, the drop down menu keeps the address in the list. How do I delete this name again. Best regards Kim ...

RMS 1.0
I am intereseted in hearing from those using RMS Version 1.0 and their expereince with PCI compliance. I note that Version 2.0 is listed as a validated PCI application and that Version 1.0 is not (http://usa.visa.com/download/merchants/validated_payment_applications.pdf). Specifically, I would like to know if anyone is using Version 1.0 and has successfully configured the application to be fully compliant with PCI. Alternatively, has anyone concluded that it is impossible to make Version 1.0 PCI compliant (e.g., lack of encryption, inadequate auditing/logging)? Finally, I would be int...

Extracting the Contents of a Field
Is there a simple way to extract the text contents from a field and paste as text while retaining the formatting? What works is selecting half the text, copy, paste. Select the other half, copy, paste. If I select it all and paste, I get the field against. I thought paste special might work but has given me no joy. Paste the field and then unlink it (Ctrl+Shift+F9). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org <faceman28208@yahoo.com> wrote in message news:0c5874a2-14fa-4242-8331-bb2c9abdaa13@h12g2000vbd.g...

Switch Language for fields.
Hi, I am working on an English Document in an English version of Office on a German PC. My citations use S. instead of p. for pages in citations. How can I change that? Regards In the "Edit Source" dialog, there is a Language dropdown list at the top right corner where you can set your source's language. The available choices depend on your settings. Also, right click on a citation or bibliography field and select "Edit Field...". You will see a format string containing \l followed by a 4 digit number. The latter is the locale used to represent yo...

CRM upgrade from 1.2 to 3.0 12-11-07
We have a CRM 1.2 installation which we would like to upgrade to CRM 3.0. I believe this is a free upgrade but I don't know how I can obtain the key. While installing CRM, it is asking for a license key and if we do not provide the right key, it is going to be in demo mode in 30 days. Is there a way to obtain the key from microsoft? Microsoft CRM upgrades are usually free if you have valid Software Assurance. I would suggest you check your CustomerSource account https://mbs.microsoft.com/CustomerSource and/or contact the licensing reseller you bought CRM 1.2 from. Paul Velgos GNC...

Make active contract/contractdetails fields read/write
By default MS CRM makes invoice/Active Contract and it's Contract Lines read-only. Is there a way to make some of Contract Lines/contractdetail fields read-write again ? ...

Concatenate same field records into one.
I have a query call QryFind that produces one field with many records. Simply I need to Concatenate the results to display in a text box on a form. From A B C I need A, B, C How do I do this? I seem to recall a "concatenate" function that Duane H. posted a while back. Try searching on-line with those as keywords... -- Regards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. An...

How do i modify the contact field lists in Access 2007?
Access comes with a generic Contact template that I would like to modify. How do I add / remove some of the fields in the Contact template (for example the web field). Thank you. When this template first opens, it displays the Contact List form, with the Navigation Pane reduced in size (for lack of a better term). Try following these steps: 1.) Click on the small double arrow, on the left-hand side, to expand the Navigation Pane. You can also close the Contact List form at this time. You will likely see a grey space where this form was opened. 2.) With the Navigation Pane expanded, ...

Selecting 1 column left from active Cell
I know this should be so simple, but what would be the code to backstep 1 column from the active cell? Rob Rob, activecell.Offset(0,-1).Select John "rob nobel" <robnobel@dodoNOGOOBS.com.auNOGOOBS> wrote in message news:eLanqh%232DHA.1264@TK2MSFTNGP11.phx.gbl... > I know this should be so simple, but what would be the code to backstep 1 > column from the active cell? > Rob > > Hi Rob! Try: ActiveCell.Offset(0, -1).Select -- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Excel and Word Function Lists (Classifications, Synt...

How do I spell check a field in a table that is in a template?
I added a table to a template and then added data fields in the table. However, I can't get the spell check to work in the table fields when I remove the lock on the template. Is there a way to spell check table data? ...

Form Customization
Dear All, Can anyone help me? I want to make a field cannot be editted by user. Like Quote ID. But I dun know how. I am a new comer. I hope all of you can understand what I am saying, cause my English not so good. Thx, Monalisa Hi Monalisa, As far i know you cannot make a form field non-editable. I guess Microsoft will come up in the future releases. Regards Vijay "Monalisa" wrote: > Dear All, > Can anyone help me? I want to make a field cannot be editted by user. > Like Quote ID. But I dun know how. I am a new comer. > I hope all of you ca...

How to view each row as a "record" or 1-screen ??
We have a spreadsheet with about 26 columns per row. We want to display each row as a record or "screen" Is there anyway to do this without becoming a VBA programmer? Or, is there any sample code we could use as a model and tweak? thanks for any help. You can use the built-in data form: Select a cell in the list Choose Data>Form tmb wrote: > We have a spreadsheet with about 26 columns per row. > > We want to display each row as a record or "screen" > > Is there anyway to do this without becoming a VBA programmer? > > Or, is there any samp...

is there a template for a field guide
I am In year 8 at school and need to make a field guide compairing 2 coastal habitats. Are there any sugestions on a suitable template. Might try this one, it is in Word http://www.angelfire.com/ok2/sustevens/biology.html There are templates on the Office site you could possibly edit to fit your needs. http://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=field+guide -- Mary Sauer MS MVP http://office.microsoft.com/ http://www.msauer.mvps.org/ news://msnews.microsoft.com "Marc Little" <Marc Little@discussions.microsoft.com> wrote in message news:B8D91CE0-CC2D-...