Results 1 to 2 of 2
  1. #1
    FJM is offline Competent Performer
    Windows 98/ME Access 2003
    Join Date
    Jun 2010
    Posts
    117

    Calendar9 and datepicker6

    I am in the position of upgrading computers at work from Access 2008 to Access 2013 and then Access 2016


    One problem I am encountering seems to be where I have used a Calendar control on forms.

    I have a form where the operator currently chooses a date from a combo box which is linked to a calendar control.

    The code is as follows:-
    Private Sub Combo42_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Calendar9.Visible = True
    Calendar9.SetFocus
    If Not IsNull(Combo42) Then
    Calendar9.Value = Combo42.Value
    Else
    Calendar9.Value = DATE
    End If
    End Sub

    When I run the databade initially, I am getting the following warning message
    "Your access database contains a missing or broken reference to the file MSCAL.OCX v7"

    I have looked up this probelm and from what I can make out, the calendar control needs to be replaced by an updated version.
    I see that DTPicker6 is available.
    I have tried to simply replace Calendar9 with DTPicker6 in the code but it will not run.
    Can anyone point me in a direction ......?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,938
    you don't need anything - ensure the control's format property is set to a date format (e.g. short date or dd/mmmm/yyyy) and 'show datepicker' is set to 'for dates'. A small calendar icon will appear when the control has focus which the user can select

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums