Not sure what's happening; I do have some criteria where it makes sure it picks the correct data by stating this time is between a start and end time on the other table.
Code:
SELECT [SP-Pick].DDate, [SP-Pick].EmpNo, [SP-Pick].TTime,
SELECT [SP-Pick].DDate, [SP-Pick].EmpNo, [SP-Pick].TTime,
Dim Day As Integer
Dim db As Database
Dim tdf As TableDef
Dim X As Integer
Set db = CurrentDb()
Set tdf = db.TableDefs("tblPTO")
Set X = 1
If tdf.Fields("Day") = X Then
Dim strsql As String
strsql = "UPDATE [Action]" _
& "SET [Action] = (" & "054846" & ")"
DoCmd.RunSQL strsql
On Error GoTo ErrorHandler Dim rsLoop As Recordset Dim strSQL As String Dim db As Database Dim stDocname As String
Leave a comment: