Avatar of anthonytr
anthonytr
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Run an action on recently added records to a table

Hi,

I have an INSERT SQL query which is contained within a LOOP action.  When the LOOP is completed I need to ask the user if they want to run a task relating to the new records which were just inserted.

My plan at the moment is to have a new field added to the table which the data is being inserted and name it NEW (yes/no).  When new records are inserted, the insert query will assign them YES.  At the end of the process when the user is asked if they want to see/print the newly inserted records I can then run a select query based on that table where the NEW field = true/1.  Once this has run I will set all TRUE fields to FALSE.

Does this method make sense?  Am I going about this totally wrong?  Is there a better and cleaner way of approaching this?  Really happy to see suggestions of simpler coding.

Thanks
Anthony
Microsoft AccessVBAMicrosoft SQL Server

Avatar of undefined
Last Comment
skullnobrains

8/22/2022 - Mon