![]() DateTimePicker Ctrl which has been published as VBA solution using Windows API for MS Access some years ago. ![]() ProgressBar, which is just nice to look at but can be substituted by displaying progress within StatusBar and changing Mouse Cursor to Wait (not that nice but works) - or were replaced by pure API solutions thanks Other controls are not that important - i.e. ImageList is required as supporter for both controls. Handy and required - otherwise you would not have included them in your "Common Controls". Controls like TreeView are not possible with pure VBA but Not to mention the possibility to display icons. Ĭommon Controls like ListView excel VBA's Listbox simply by having an included header, ability of being sorted and simplicity of being programmed. If it shows as # just make the column wider to show the date.Since being labeled "common controls" we expected them being available for ever. Now, put cellpointer in any cell, then click a date on the Calendar. If you can't see the 'Developer' tab in the top-panel Ribbon, do this:Ĭome out of 'Design Mode' by clicking 'Design Mode' in the top-panel Ribbon on the 'Developer' tab. Come out of 'Design Mode' by clicking 'Design Mode' in the top-panel Ribbon on the 'Developer' tab. Private Sub MonthView21_DateClick(ByVal DateClicked As Date) You should see something like this in the VBA editor window: So right-click the mouse, and select the option 'View code'. The 4-headed cursor shows you are still in 'Design Mode'. (Don't confuse the number of bits in the operating system with the number of bits in your copy of Office they are two different things.) A good overview of how to register the control can be found here: How you register the control depends on the version of Windows you are using and whether you are using a 32-bit or 64-bit version of the operating system. If it is, skip copying and just try to register it.) (Before copying it, do a Windows search to see if the file is actually on your system. If you are running a 32-bit version of Office, then you can try to copy the MSCOMCT2.OCX control from a like system and register it with Windows. When Microsoft actually comes out with versions of the controls that do work with 64-bit Office, they will likely have different names, a move sure to complicate the life of VBA programmers who rely on the controls. ![]() (In fact, none of the ActiveX controls work in 64-bit Office. The reason is because MSCOMCT2.OCX works only on 32-bit systems. If you are using a 64-bit version of Office, then you won't be able to install the control. If the tool doesn't show up in the More Controls dialog box, then it has not been installed on your system.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |