Recent content by digiext

Sorry it took me so long to respond. Here is the output of debug.print: INSERT INTO tblCurrentShift (ShiftName, ShiftStart, ShiftEnd, DaysOfTheWeek, Ord) SELECT tblShifts.ShiftName, tblShifts.ShiftStart, tblShifts.ShiftEnd, tblShifts.DaysOfTheWeek, tblShifts.Ord FROM tblShifts WHERE...

I just tried this code out and it should be selecting Day shift but now is selecting Night Shift. Thank you for the attempt to fix this! Chris

Hello, I am looking to get some help with a VBA function that would select a shift from a table based on the current date and time. It would then write this data out to another table to be used by other items. I currently have something that works most of the time but has problems...