UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Automatic Insertion, Access 2007    
 
   
shah1419
post Jan 23 2020, 01:20 AM
Post#1



Posts: 71
Joined: 10-January 13



Dear all
i have table name inout fields(id,checktime,verification,verifytype) and data in (empolyeeid,inouttime,1,(I/O)). and a query1 table . my requirement is when a user update or insert in inout table some data it will create a record in query1 table. i am not using any form. is there any option or trigger which can insert record in query1 table when a user insert/update any data in inout table. please advised.
This post has been edited by shah1419: Jan 23 2020, 01:21 AM
Go to the top of the page
 
June7
post Jan 23 2020, 01:30 AM
Post#2



Posts: 1,220
Joined: 25-January 16
From: The Great Land


Are you asking for audit trail procedure? Review http://allenbrowne.com/AppAudit.html

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Go to the top of the page
 
projecttoday
post Jan 23 2020, 07:56 AM
Post#3


UtterAccess VIP
Posts: 11,592
Joined: 10-February 04
From: South Charleston, WV


You're not using any form. What are you using?

--------------------
Robert Crouser
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    19th February 2020 - 09:24 AM