========= 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 [...]
========= QUESTION --------- How do I disable an individual Outlook Add-In? ========= ANSWER --------- Outlook 2010: File, Options, Add-InsSelect COM Add-Ins from the Manage drop down list at the bottom of the window, and click [Go...]Un-Check the box next to the add-in you wish to disable and click [OK] ========= EXAMPLES --------- see [...]
========= QUESTION --------- I noticed a new Plug-In in my Microsoft Outlook Add-In Manager called Redemption Helper Outlook Extension - what is it? --------- I found a pop-up error waiting for me on my computer this morning as follows: Microsoft Office OutlookOutlook experienced a serious problem with the 'redemption helper outlook extension' add-in. If you [...]
========= QUESTION --------- When attempting to ADD or EDIT an ODBC connection from the ODBC Data Source Administrator in Windows, I receive the following error: Microsoft ODBC Administrator The setup routines for the X ODBC Driver could not be loaded due to system error code 126: The specified module could not be found. (C:......dll). [...]
========= QUESTION --------- How do I add a record to a table using SQL? ========= ANSWER --------- see EXAMPLES ========= EXAMPLES --------- SQLTxt = "INSERT INTO 0000T_Log (Dt, Log) VALUES (#" & Now() & "#, '" & Me.CurrentStatus & "')"CurrentDb.Execute SQLTxt ========= APPLIES TO / KEY WORDS --------- Microsoft Access SQL Insert [...]
========= QUESTION --------- Windows Logo Key keyboard shortcuts ========= ANSWER ---------see EXAMPLES ========= EXAMPLES --------- Windows logo key: Open or close the Start menu. Windows logo key + Pause: Display the System Properties dialog box. Windows logo key + D: Display the desktop. Windows logo key + M: Minimize all windows. Windows logo [...]