Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106

    Unanswered: Calendar Lookup for a data field.

    Hi,

    Is there a way that we can make a calendar field on a form attached to a drop down with a calendar look? The goal is to avoid keying errors.

    Thanks.
    Mo

  2. #2
    Join Date
    Jan 2003
    Posts
    126

    Talking

    Sure can!

    Just insert the "Microsoft Date and Time Picker Control 6.0" onto your form. Works great!

    Ken

  3. #3
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106
    Hi Ken,

    When I went to the ActiveX Control list and tried to register it; I got a drive selection window so I took it to where my program is located. But, I could not save it. I am not sure I am doing it right. I went back and try it Unregistered it, it disappeared from the list.

    How can I bring back to the ActiveX Control list? And how can I incorporate it in the form?

    Thanks a lot.
    Mo

  4. #4
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    References

    Go to a module then tools . references

    Add microsoft activex

    Browse for plugin.ocx (probably c:\windows\system)

    Add calender control ? 9

    Browse for mscal.ocx (probably c:\windows\system)

    If you cant find in that directory, use file search on your hard drive
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  5. #5
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820

    Re: References

    i did something simalar and this is the code i used to run it

    Dim temp As TextBox

    Private Sub DatePicker_LostFocus()
    temp.SetFocus
    DatePicker.Visible = False
    End Sub

    Private Sub DateReported_DblClick(Cancel As Integer)
    DatePicker.ControlSource = DateReported.Name
    DatePicker.Visible = True
    Set temp = DateReported
    DatePicker.SetFocus
    End Sub


    Private Sub EstimatedFixDate_DblClick(Cancel As Integer)
    DatePicker.ControlSource = EstimatedFixDate.Name
    DatePicker.Visible = True
    Set temp = EstimatedFixDate
    DatePicker.SetFocus
    End Sub
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •