Using MySQL with ASP.NET

========= 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   [...]

By |2017-12-01T23:47:36+00:00September 29th, 2011|ASP.NET, Computers, Documentation, Microsoft, MySQL|Comments Off on Using MySQL with ASP.NET

PayPal: Payment forcing logon or new account signup

========= 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 [...]

By |2011-09-27T10:21:22+00:00September 27th, 2011|Internet/Web, PayPal|Comments Off on PayPal: Payment forcing logon or new account signup

PayPal: Transfer funds to my bank account

========= 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 [...]

By |2011-09-27T10:00:56+00:00September 27th, 2011|Documentation, Internet/Web, PayPal|Comments Off on PayPal: Transfer funds to my bank account

Sysinternals Utilities

========= 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

By |2017-12-01T23:47:37+00:00September 19th, 2011|Computers, Documentation, Microsoft, Windows|Comments Off on Sysinternals Utilities

Can you ping a TNS Name?

========= 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 [...]

By |2017-12-01T23:47:37+00:00September 19th, 2011|Computers, Documentation, Microsoft, ODBC, Oracle|Comments Off on Can you ping a TNS Name?

How do I lock my computer?

========= 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.   [...]

By |2011-09-16T11:06:45+00:00September 16th, 2011|Computers, Documentation, Microsoft, Windows|Comments Off on How do I lock my computer?

Remap another key to act as the Windows Logo key

========= 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

By |2017-12-01T23:47:37+00:00September 16th, 2011|Computers, Documentation, Microsoft, Windows|Comments Off on Remap another key to act as the Windows Logo key

VBA: Rename Files

========= 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 [...]

By |2011-09-14T10:59:47+00:00September 14th, 2011|Computers, Documentation, Microsoft, VBA|Comments Off on VBA: Rename Files

VBA: Format Function

========= 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 [...]

By |2011-09-14T10:31:22+00:00September 14th, 2011|Computers, Documentation, Microsoft, VBA|Comments Off on VBA: Format Function

Outlook: Disable Add-Ins

========= 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 [...]

By |2011-09-14T06:39:47+00:00September 14th, 2011|Computers, Documentation, Microsoft, Outlook|Comments Off on Outlook: Disable Add-Ins
Go to Top