Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Delta, Br. Columbia
    Posts
    116
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Date & Time Picker Ctl (2000 & XP)

    I am trying to use this tool from the toolbox and 2 issues arise:

    1) How can I get hold of the help file - cmctl298.chm. I would like to understand what the various options will allow. i.e. "Check Box" - I have had to set it to yes to make it work but I do not know why.

    2) I have (so far) a total of 13 of these controls. If I limit it to 12 then the form works. However when I add the 13th control I get the following error message:

    "An error occurred in a call to the Windows Date and Time Picker control"

    Is there a limit of 12 controls?

    I have found an alternative by using a popup form but in this case the user prefers the Date Picker ctl.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Date & Time Picker Ctl (2000 & XP)

    I believe there are some supplementary files (at least for 2000) that come on the CD, but aren't installed by default, that give some basic information about the extra controls that are available. There also used to be a substantial document available on the MS web site that described the ActiveX controls available in comctl32.ocx and mscomctl.ocx, but I wasn't able to find it tonight. I'll keep looking - in the mean time, I know that there are a number of limitations with the MS Date & Time Picker control. We normally use one from DBI Technologies. As to why you can't have more than 12 on a form, that's a mystery, but so is the concept of having 13 or more on one form, so . . . .
    Wendell

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Date & Time Picker Ctl (2000 & XP)

    I'm not sure if this will help, but check out this <!mskb=297381>Microsoft Knowledge Base Article 297381<!/mskb> - the download file may well include the help file.
    Wendell

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date & Time Picker Ctl (2000 & XP)

    The MSDN documentation for ActiveX controls in VB/VBA is here.

  5. #5
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Date & Time Picker Ctl (2000 & XP)

    Here is another MSDN link:

    DateTimePicker Control (VB 6.0 Reference)

    Also see this MSKB article - though applies to VB 6.0, not Access, and does not address this specific issue - it makes the general point that ActiveX controls are resource-intensive and that it is not a good design strategy to use an excessive number of them on a single form:

    PRB: Error 743 Adding ActiveX Controls to Control Collection

    I'm not aware of a specific limit when using the Date Time Picker control.

    HTH

  6. #6
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Delta, Br. Columbia
    Posts
    116
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Date & Time Picker Ctl (2000 & XP)

    Many thanks for all your replies. To answer one question from Wendell - There are 13 dates as it is a project management tool and the client wants this type of control for each date (e.g. project start, foundation start, Dwg Start, etc etc.)

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Date & Time Picker Ctl (2000 & XP)

    Clients can't always be allowed to drive interface design, especially when what they want is to shoot themselves in the foot. Create a single form with a datetime picker or calendar control on it and pop that up on the dblclick event of each date textbox. Then return the selected date to the textbox. It will be faster and less resource intensive. If the client objects, present them with their choices. <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
    Charlotte

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Date & Time Picker Ctl (2000 & XP)

    Here! Here! Clients make you jump through all these hoops to do something they think will solve a problem, and never look at alternatives that work better, faster and are cheaper to develop. Pray tell, why do they want a whole bunch of dates in one record? It seems to me each of those things is an event and could easily be a separate record, and you would only need one date and time picker then. Just display the data in a subform.
    Wendell

  9. #9
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Delta, Br. Columbia
    Posts
    116
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Date & Time Picker Ctl (2000 & XP)

    You are absolutely correct.- my head must be somewhere else. It was not the client saying 1 record - just me not thinking! 1 "job sheet" has many dates - it is a classic!!

    I have found a popup form from somewhere else (someone else has done the work) which I will keep in case, but will look further at the above.

Posting Permissions

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