Hi Experts,
I had asked a question about First Monday & Third Monday of the week couple week ago and Expert Gustav Brock gave me the Public Function which works but when I tried to place to another form, it does not work as it suppose.  I know I did something wrong, but did not what I miss.  below is my code on a datefield:
Private Sub PDFIRSTCRTDATE_Exit(Cancel As Integer)
Dim DateInMonth As Date
DateInMonth = Date

    If Me.HoldCalA = "Cal 24" Or Me.HoldCalA = "Cal 42" Or Me.HoldCalA = "Cal 54" Then
       If Me.PDFIRSTCRTDATE = DateWeekdayInMonth(DateInMonth, 1, vbMonday) Or Me.PDFIRSTCRTDATE = DateWeekdayInMonth(DateInMonth, 3, vbMonday) Then
       Else
          MsgBox "You have schedule on the wrong Monday for the " & Me.HoldCalA & "."
       End If
    End If
  End Sub



Here is the Public Function from Gustav Brock:
' Calculates the date of the occurrence of Weekday in the month of DateInMonth.
'
' If Occurrence is 0 or negative, the first occurrence of Weekday in the month is assumed.
' If Occurrence is 5 or larger, the last occurrence of Weekday in the month is assumed.
'
' If Weekday is invalid or not specified, the weekday of DateInMonth is used.
'
' 2016-06-09. Gustav Brock, Cactus Data ApS, CPH.
'
Public Function DateWeekdayInMonth( _
    ByVal DateInMonth As Date, _
    Optional ByVal Occurrence As Integer, _
    Optional ByVal Weekday As VbDayOfWeek = -1) _
    As Date
   
    Const DaysInWeek    As Integer = 7
   
    …

We currently use Visual Studio 2008 v9.0.  When one user opens a proc on Monday (but does not check it out as they have no intention at that time to make changes) if another user checks out the proc on Tuesday , makes changes and checks it in.  There is nothing to stop the first user from making changes to the proc as he/she  has it in front of him (fro  Monday) and overwrite the changes that user 2 made on Tues.
Is there a way to prevent this - e.g. automatically refresh, or not allow changes checked in if not using the latest file or the problem seems to be that if you have a proc open, you can directly make changes and it will then get flagged as checked out, perhaps if this could be disabled so that the only way to check out a proc would be to reopen from scratch