allen brownes audit trail

  • Thread starter jomara via AccessMonster.com
  • Start date
J

jomara via AccessMonster.com

I am using Allen's audit trail to keep a history of changes to my database.
Everything works great when updating from a form. My problem is i have an
update query that is used to move a contact to another sales person. My
query has 4 fields 1:Contact staus (updates to new lead) 2: rep (manually
enter new rep # to update to) 3:lead box (unchecks the box talking it out of
leadbox) 4: update lead (only moves the leads that are checked ) I would
like to change update lead from a yes/no box to a text box and enter the rep
number there so allen's audit trail would keep track of those changes is this
possible. I hired someone to help with my database and before i go back to
them i would like to try this on my own
 
A

Allen Browne

Execute a 2nd query (an append query) to write the values to the logging
table, using the same WHERE clause so you get the same records.
 
J

jomara via AccessMonster.com

i am new to programming how would i go about using the where clause
Allen said:
Execute a 2nd query (an append query) to write the values to the logging
table, using the same WHERE clause so you get the same records.
I am using Allen's audit trail to keep a history of changes to my database.
Everything works great when updating from a form. My problem is i have an
[quoted text clipped - 10 lines]
to
them i would like to try this on my own
 
A

Allen Browne

You have a query that runs your update?
Open that query in SQL View (View menu in query design).
Look at the query statement.
It consists of an UPDATE clause, SELECT clause, a FROM clause, a WHERE
clause, etc.

You need a similar WHERE clause in your INSERT query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

jomara via AccessMonster.com said:
i am new to programming how would i go about using the where clause
Allen said:
Execute a 2nd query (an append query) to write the values to the logging
table, using the same WHERE clause so you get the same records.
I am using Allen's audit trail to keep a history of changes to my
database.
Everything works great when updating from a form. My problem is i have
an
[quoted text clipped - 10 lines]
to
them i would like to try this on my own
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top