Clear Button in Bootstrap Input Group Component 06/03/2017 | jiangws By default, Internet Explorer 10 and 11 show an ‘X’ button (clear button) at the edge of non-empty text input. In this post, we’ll add such button for input group component in Bootstrap 3. It will look something like the following screenshot: HTML We use Bootstrap feedback icon and add 2 our custom CSS classes (.has-clear and.form-control-clear) as highlighted below.… Read More
MVC Bootstrap Input Group Button Space 01/03/2017 | jiangws MVC Bootstrap Input Group Button Space… Read More
Link a password protected excel spreadsheet to an access database 09/12/2016 | jiangws If the Excel workbook is protected by a password, you cannot open it for data access, even by supplying the correct password with your connection settings, unless the workbook file is already open in the Microsoft Excel application. so, you cán link it, but when you want to access the data, the excelsheet has to… Read More
100 Words Every Fourth Grader Should Know 14/11/2016 | jiangws2002 accommodate afterthought allegiance aloft ancestor anticipation antics apparel ascend beckon brink catastrophe coax compassion complexion content courteous cringe derelict dignity distaste dormant elaborate endure enforce exertion expanse extraordinary foliage foremost frank function futile gaze glimmer glimpse grimace headstrong hesitate hoist immense imperceptibly indication inscription instinctive intent interior jar keepsake knack literacy lurch makeshift malicious massive… Read More
AccessでExcelのROUNDUP・ROUNDDOWN関数に相当するものを作る方法 14/11/2016 | jiangws2002 ○分類 VBA ○解説 モジュールを新規作成して、以下のコードを入力して保存します。 Option Compare Database Public Function RoundUp(x As Currency, s As Integer) As Currency Dim w As Currency t = 10 ^ Abs(s) If x > 0 Then If s > 0 Then RoundUp = -Int(-x * t) / t Else RoundUp = -Int(-x / t) * t End If Else If… Read More
Descendant selectors And Group selectors 11/11/2016 | jiangws2002 1）Descendant selectors http://css.maxdesign.com.au/selectutorial/selectors_descendant.htm 2）You can also specify that only specific HTML elements should be affected by a class. In the example below, only “p” elements with class=”center” will be center-aligned: Example p.center { text-align: center; color: red; } 3）group selectors To group selectors, separate each selector with a comma. In the example below we have… Read More
Access 2007 SQL the default value for switch 20/03/2015 | jiangws2002 I am using switch statement in access 2007, i want to know how I can specify default value. select switch ( MyCol = 1, ‘Value is One’, MyCol = 2, ‘Value is Two’ ) from MyTable -> SELECT Switch(MyTable.[MyCol]=’1′,’Terrestrial’, MyTable.[MyCol]=’2′,’Value is two’,MyTable.[MyCol]=’3′,’Value is three’, True,’Error’) AS ColumnName FROM MyTable;… Read More
Get the NumSuffix(English) 29/12/2014 | jiangws2002 Function OrdinalSuffix(ByVal Num As Long) As String Dim n As Long Const cSfx = “stndrdthththththth” ‘ 2 char suffixes n = Num Mod 100 If ((Abs(n) >= 10) And (Abs(n)… Read More
如何提高Office 2013在Windows8或者8.1下的启动速度？ 25/10/2013 | jiangws2002 如何提高Office 2013在Windows8或者8.1下的启动速度？我试了很多办法，比如取消GPU加速拉，注册表的人为修改什么的，都没有用。 经过几个小时的试验，终于找到一个办法：就是： 对Office文件（Excel,Word等文件）在打开（Open With）里直接指定执行文件： “C:\Program Files\Microsoft Office 15\root\office15\EXCEL.EXE” 原来打开隐含用的是Excel(Desktop)),我估计是因为Windows 8.1里先看Windows Store里有没有程序可用，然后再去找Desktop里的程序，所以比较慢。… Read More
“If your boss forces you to work late, he/she may be ineffective and have a meaningless life too, so forward this to him/her” 14/03/2013 | jiangws Read More