Date picker, Calendar

Posted by: meickholtz1 on 28 February 2022, 5:48 am EST

  • Posted 28 February 2022, 5:48 am EST

    Hello, I am currently using the ComponentOne FlexGrid control within an Access form. I am needing a way to pop-up with a Date-picker that the user can then select their date and it would populate in that cell. I had some VBA Coding but this appears to not be compatible with Office365. Any assistance would be much appreciated.
  • Replied 19 April 2022, 7:14 am EST

    Hello.

    Unfortunately, our ActiveX Controls are intended to be used by VB6 or C++ developers in Visual Studio.

    https://www.grapecity.com/componentone-system-requirements#activex

    Access VBA is not a supported environment and thus we don't have any samples or documentation regarding using vsFlexGrid in VBA.

    That said, vsFlexGrid has a column data type of FlexDTDate. This is mostly to allow proper sorting or filtering of date information (otherwise it gets treated as strings).

    https://help.grapecity.com/componentone/NetHelp/vsflexgrid8/coldatatypeproperty.html

    Also, in VB6, there is a sample included with the studio called "DTPick" which shows how to invoke a DateTime editor when editing a cell in vsFlexGrid.

    https://help.grapecity.com/componentone/NetHelp/vsflexgrid8/visualbasicsamples.html

    If you don't have Visual Studio 6, you probably can't open the sample (It should be in your documents folder C:\Users\[USERNAME]\Documents\ComponentOne Samples\ActiveX\VS FlexGrid Pro 8.0\Vb\DTPick) but you can open the form1.frm in a notepad and about halfway down you can see the VB6 code used for the KeyDown, StartEdit and other events they use to make it work. I can't say for sure if the same would working VBA because we've never tested it since it's not a support environment but it might be worth a try.

    Thank you.

    Andy
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels