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    
post Jan 23 2020, 01:20 AM

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
post Jan 23 2020, 01:30 AM

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
post Jan 23 2020, 07:56 AM

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