========= QUESTION --------- How can I get a good view of how much disk space is being used by each folder in my hierarchy? ========= ANSWER --------- Microsoft Windows http://www.jam-software.com/treesize_free/ http://windirstat.info/ http://www.freecommander.com/ --------- Mac OS http://grandperspectiv.sourceforge.net/ ========= EXAMPLES ---------see ANSWER ========= APPLIES TO / KEY WORDS --------- Disk Space Hard Disk Disk [...]
========= QUESTION --------- How do I make a MicroStrategy report populate a database table, rather than outputting to a static report? ========= ANSWER --------- This feature is called a DataMart. Edit the report in MSTR DesktopSelect Configure DataMart... from the Data menu Enter a new table name* in the Table Name field*Note: the table name [...]
========= QUESTION --------- How do I enable and show the Administrator account as a logon option on the Windows 7 or Windows Vista Welcome screen? ========= ANSWER --------- Windows 7 Run the following commands after running the Command Prompt as an Administrator as follows: Start, type in CMD, right-click the cmd.exe application and select [...]
========= QUESTION --------- Can you use the free and popular open source database system, MySQL when coding with ASP.NET, rather than the expensive Microsoft SQL Server database system? ========= ANSWER --------- Yes - see REF ========= EXAMPLES --------- ========= APPLIES TO / KEY WORDS --------- mysql MSSQL VB C# Web CodingCode [...]
========= QUESTION --------- ========= ANSWER --------- Download the SysInternals Suite here: http://technet.microsoft.com/en-us/sysinternals/bb842062.aspx ========= EXAMPLES --------- ========= APPLIES TO / KEY WORDS --------- Utilities Tools ========= REF --------- http://technet.microsoft.com/en-us/sysinternals/bb842062.aspx http://www.techrepublic.com/blog/five-apps/five-sysinternals-tools-no-admin-should-be-without/1056?tag=nl.e101 ---http://www.anysitesupport.com/sysinternals-utilities/http://anySiteHosting.com http://www.techrepublic.com/blog/five-apps/five-sysinternals-tools-no-admin-should-be-without/1056?tag=nl.e101
========= QUESTION --------- I use ODBC connections to link to Oracle databases. These connections use a TNS Name in their Service Name field. Can I simply PING these TNS Names as a simple connectivity test to the database? ========= ANSWER --------- Yes At the COMMAND PROMPT, type: TNSPING (SPACE and then the SERVICE NAME [...]
========= QUESTION --------- Can I manually lock my computer when leaving my desk for a bit? ========= ANSWER --------- Yes - simply hold down the Windows Logo key and press the L key. Another option is to do the classic Ctrl + Alt + Del combination and select Lock from the resulting options. [...]
========= QUESTION --------- Can I remap another key on my keyboard to act as the Windows Logo Key? ========= ANSWER --------- Edit the registry as follows: [HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlKeyboard Layout]"00000409"="KBDUS.DLL""Scancode Map"=hex:00,00,00,00,00,00,00,00,02,00,00,00,5B,E0,38,E0,38,E0,5B,E0 ========= EXAMPLES --------- ========= APPLIES TO / KEY WORDS --------- Windows Logo Key ========= REF --------- http://www.randyrants.com/2004/01/keyboard_remapp.html ---http://www.anysitesupport.com/remap-another-key-to-act-as-the-windows-logo-key/http://anySiteHosting.com
========= QUESTION --------- How can I use VBA to loop through and rename a long list of files in several sub-directories? ========= ANSWER --------- see EXAMPLES ========= EXAMPLES --------- Private Sub RenameFiles_Click() Dim fName As String Dim fName_New Dim myPath As String Dim myCounter As String DoCmd.Hourglass True DoCmd.SetWarnings False Set [...]
========= QUESTION --------- How do I format numbers, dates, etc in my VBA code? ========= ANSWER ---------see EXAMPLES ========= EXAMPLES --------- Format(rs!Store, "0000") Formats a number field that may contain only one digit (i.e. 2) to four digits with leading zeros (i.e. 0002) ---------= Format(Now(), "hh:mm AMPM")If the current time is 5:04:23 in [...]