IVANKA TRUMP: Think Big Again 15/08/2020 | jiangws2002 3年前看到Ivanka Trump的这个演讲，想到能培养出这样优秀的女儿的父亲应当是多么的伟大……现在想来是多么的幼稚。 伊万卡·特朗普，1981年10月30日生于美国纽约，美国总统唐纳德·特朗普的女儿，世界超级名模，美国纽约房地产巨鳄特朗普集团副总裁，连续两年登上美国《福布斯》杂志的全球十大未婚女富豪排行榜榜首，她是美国总统唐纳德·特朗普与他第一任妻子所生的孩子。以下是伊万卡为她老爹特朗普竞选总统的助选演讲，情真意切，感人至深，看完之后，真是不得不服她的演讲魅力！Good evening. Thank you.One year ago, I introduced my father when he declared his candidacy. In his ownway, and through his own sheer force of will, he sacrificed greatly to enterthe political arena as an outsider. 晚上好。谢谢。一年前，当我父亲宣布参选时，我为他进行了介绍演讲。作为一个门外汉，我的父亲用自己的方式，凭借一腔热血，牺牲付出，进入了政坛。 And he prevailed against afield of 16 very talented competitors.For more than a year, Donald Trump… Read More
The Bang! (Exclamation Operator) in VBA 02/08/2020 | jiangws2002 One of the most peculiar aspects of Visual Basic for Applications in the ! operator, called the “bang”. There’s a lot of confusion about the bang operator, and nowhere have I seen the correct whole story about it. So, I present it here! The bang is particularly common in code for Microsoft Access, where you may see… Read More
MS Access Select top n query grouped by multiple fields 26/07/2020 | jiangws2002 Sample output: | STUDENTID | YEAR | SUBJECT | AVGSCORE | |———–|——|———|———-| | 1 | 2012 | 1 | 91 | | 1 | 2012 | 2 | 84 | | 2 | 2012 | 1 | 94 | | 2 | 2012 | 3 | 95 | Data Source StudentID, Test ID, Score1,1, 951,… Read More
对数据进行分组的SQL 26/07/2020 | jiangws2002 Table： id score 1 56 2 91 3 67 4 54 5 56 6 69 7 61 8 83 9 99 Subject_table MS Access MySQL SELECT (case when score < 60 then "less 60" when score < 80 then "60 - 80" when score < 100 then "80-100" else "other" end) as score_type,count(id) as stu_cnt… Read More
Move your iPhone Contacts to Google Contacts with the Google Drive app 25/07/2020 | jiangws https://www.piesync.com/help/want-to-learn-more/setting-up-your-iphone-to-sync-with-google-contacts/… Read More
transfering an export/import specification from one database to another (1 Viewer) 24/07/2020 | jiangws In Access 2007, display the “External Data” tab. Click on the “Access” option. Use the Browse button to locate the file you want to import the saved import-export specification. Once a database has been specified, the “OK” button will become available. Clic the OK button to display the Import Objects dialog box. Click the “Options… Read More
How to solve: chm can’t be open in windows 10 over network(NAS or Shared folder) 20/07/2020 | jiangws run cmd in Administrator use mklink from NAS to local For examples: mklink /d d:\jiangws \NASnew\jiangws… Read More
How do I simulate Excel’s Ceiling/Floor Functions in VBA? 18/07/2020 | jiangws To simulate these two Excel functions in Access Visual Basic, paste the following code into a new module and save it: CODE Public Function Ceiling(ByVal X As Double, Optional ByVal Factor As Double = 1) As Double ‘ X is the value you want to round ‘ is the multiple to which you want to… Read More
Buffalo NAS external drives & Windows 10 will not connect 13/06/2020 | jiangws Control Panel – Programs and Features – Turn Windows features on and off and enabled: SMB 1.0/CIFS File Sharing Support Restarted and everything worked. https://docs.microsoft.com/en-us/windows-server/storage/file-server/troubleshoot/detect-enable-and-disable-smbv1-v2-v3… Read More
Pad single-digit numbers with a zero 04/06/2020 | jiangws VBA has a Format() function that you can use to pad numbers. animal = “sinani-” & Format$(i, “00”) This will pad single-digit numbers with a 0. Your two- and three-digit numbers will continue to work as expected. From:https://stackoverflow.com/questions/31628535/pad-single-digit-numbers-with-a-zero… Read More