Solved Temp Dynaset subform (1 Viewer)

oxicottin

Learning by pecking away....
Local time
Yesterday, 19:49
Joined
Jun 26, 2007
Messages
666
Hello, I have a series of Public Subs that run and collect data to a table tbl_Delay like below. How do I add saving the same data to a temp table called tbl_TempDelay and I can figure out the clearing of the temp table before the new cycle runs.

What needs added to save the same data to the temp table as well?


Set db = currendDB
Set rst = db.OpenRecordset("tbl_Delay", dbOpenDynaset, dbSeeChanges)
With rst
.AddNew
!TimeDeayBegin = plcDelayStart
!TimeDelayEnd = plcDelayFinish
!delayHours = delayHours
.Update
End With
 

CJ_London

Super Moderator
Staff member
Local time
Today, 00:49
Joined
Feb 19, 2013
Messages
12,926
same code, different recordset - tblTempDelay rather than "tbl_delay"
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 16:49
Joined
Oct 29, 2018
Messages
14,594
Or maybe something like.
SQL:
INSERT INTO tbl_TempDelay
SELECT * FROM tbl_Delay
 

Users who are viewing this thread

Top Bottom