Results 1 to 7 of 7

Thread: Date Picker Control - Access VBA

  1. #1

    Thread Starter
    Member
    Join Date
    Jan 2005
    Posts
    41

    Date Picker Control - Access VBA

    Hello,

    I have a simple access 2003 form with a few textboxes bound to a table. I have added the Microsoft Date and Time Picker Control 6.0 (sp4) control to my form and when bound or unbound I get the following error when I run the form.

    P.S. There is no code in my project apart from the add and delete buttons I created. I have double checked all of the events and there is no mouse_move code anywhere in the project.


    Please see attached image.


    Any help would be appreciated.

    Thanks.
    Attached Images Attached Images  

  2. #2
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Date Picker Control - Access VBA

    According to the error message you have code in theMouseMove event of your form? If so can you post it.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  3. #3

    Thread Starter
    Member
    Join Date
    Jan 2005
    Posts
    41

    Re: Date Picker Control - Access VBA

    I can send the project. But there are NO MOUSE MOVE events anywhere.

  4. #4
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Date Picker Control - Access VBA

    How about in the Properties window for either the form or the dtp?
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  5. #5

    Thread Starter
    Member
    Join Date
    Jan 2005
    Posts
    41

    Re: Date Picker Control - Access VBA

    huh????
    Attached Files Attached Files

  6. #6
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Date Picker Control - Access VBA

    Ok, I checked out your db breifly and your Carriers form seems to be having a problem communicating with
    the dtp. The dtp on your other forms work ok. I tried removing the dtp on the Carriers form and replacing it with
    one from a form that works, but still errors. I checked the props, code, etc. and all looks fine. A compact and
    Repair did not help either. About the only thing left to do is to try to recreate the form using all new controls etc.

    I have successfully recreated a test form with a copy of a dtp from the Generators form and no problems.
    Your form may just be corrupted or ???
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  7. #7

    Thread Starter
    Member
    Join Date
    Jan 2005
    Posts
    41

    Re: Date Picker Control - Access VBA

    Thats what I feared.

    I am doubtful that there is a lot of work involved, I just fear that without knowing what cause the "corruption" I may have the same problem, and have to keep re-creating the form.

    Thanks for your input and the time you have taken to investigate.

    I really appreciate it.

    I will let you know how it all turns out.

    Kid Coke

Posting Permissions

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



Click Here to Expand Forum to Full Width