Notice: Undefined offset: 2 in /home2/icentarb/public_html/icentar/classes/class.permissions.php on line 735
Sub P_InsertDate(PDT As Date)
' Inserts Date/Chair/TimeSlot Values In Table T_Plan
On Error GoTo ErrTrap
Dim QST As String
Dim Datum As String
Datum = "#" & Format(PDT, "mm-dd-yyyy") & "#"
If DCount("*", "T_Plan", "PDate =" & Datum) > 0 Then
GoTo ExitPoint ' This Date Already Exists
End If
QST = "INSERT INTO T_Plan (PDate, TimeSlot) " & _
" SELECT " & Datum & " AS PDate, TimeSlot " & _
" FROM T_TimeSlot ;"
DoCmd.SetWarnings False
DoCmd.RunSQL Q