Posted 28 February 2022, 5:48 am ESTHello, 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.
Date picker, Calendar
Posted by: meickholtz1 on 28 February 2022, 5:48 am EST
Replied 19 April 2022, 7:14 am ESTHello.
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).
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.
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.