Date picker, Calendar

Date picker, Calendar

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

• 

  meickholtz1

  • Post Options:
  • Link
    Copy

  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.

• 

  andrew.paxinos

  

  • Post Options:
  • Link
    Copy

  Posted 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.

  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