Microsoft Archives - Page 7 of 13 - Technology Solutions Provider

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 AdmAny9348|2017-12-01T23:47:37+00:00September 16th, 2011|Computers, Documentation, Microsoft, Windows|Comments Off

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 AdmAny9348|2011-09-14T10:59:47+00:00September 14th, 2011|Computers, Documentation, Microsoft, VBA|Comments Off

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 AdmAny9348|2011-09-14T10:31:22+00:00September 14th, 2011|Computers, Documentation, Microsoft, VBA|Comments Off

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 AdmAny9348|2011-09-14T06:39:47+00:00September 14th, 2011|Computers, Documentation, Microsoft, Outlook|Comments Off

Outlook Add-In: Outlook Redemption

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

By AdmAny9348|2011-09-14T06:31:11+00:00September 14th, 2011|Computers, Documentation, Microsoft, Outlook|Comments Off

ODBC Error: The setup routines for the X ODBC Driver could not be loaded

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

By AdmAny9348|2017-12-01T23:47:37+00:00September 13th, 2011|Computers, Documentation, Microsoft, ODBC, Windows|Comments Off

SQL: Insert Statement

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

By AdmAny9348|2017-12-01T23:47:37+00:00September 2nd, 2011|Access, Computers, Documentation, Microsoft, SQL, VBA|Comments Off

Keyboard Shortcuts: Windows Logo Key

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

By AdmAny9348|2017-12-01T23:47:37+00:00August 31st, 2011|Computers, Documentation, Microsoft, Windows|Comments Off

Outlook Error: Outlook cannot display this view

========= QUESTION --------- When I click a folder or my inbox in Microsoft Outlook, I get an error pop-up stating "Outlook cannot display this view" with nothing but an OK button. How do I fix? ========= ANSWER --------- Shutdown Outlook, then go to Start, Run, and type: Outlook.exe /CleanViews ========= EXAMPLES ---------see ANSWER [...]

By AdmAny9348|2017-12-01T23:47:37+00:00August 28th, 2011|Computers, Documentation, Microsoft, Outlook|Comments Off

Access VBA: Open a database or file using VBA

========= QUESTION --------- I have a database that I use on a regular basis, and when I am finished working with that database, I invariably always move on to the same second database file. Is there a way for me to open another file using a button or sub within VBA? ========= ANSWER --------- [...]

By AdmAny9348|2017-12-01T23:47:38+00:00August 25th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off