========= 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 --------- I am using PayPal's IPN (Instant Payment Notification) service to interface with a payment form on my website. However when a user attampts to pay using the form, and selects to pay using a credit card on the resulting PayPal.com web page, they are forced to either sign in to an existing [...]
========= QUESTION ---------I just received a payment via PayPal, how do I transfer the funds from PayPal to my bank account? ========= ANSWER --------- Logon to http://PayPal.com Click Withdraw under My Account Click Withdraw funds to your bank account Type in the amount in the Amount field, select which bank account from the To field [...]
========= 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 [...]
========= 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 [...]