========= QUESTION --------- I have been having a lot of trouble lately with my Microsoft Access database files being corrupted and losing all of my code. (a sometimes fix for this: http://www.anysitesupport.com/error-microsoft-access-has-stopped-working/) The scary thing is even when I attempt to open the backups, they may work, but the code still disappears! Is there a [...]
========= QUESTION --------- What are some ways I can manipulate strings within VBA? ========= ANSWER --------- see EXAMPLES ========= EXAMPLES --------- Title field has values like: Company Manager, Company Assoc, Company Director, etc...Remove Company: =IIf([Title] is null,"",Replace([Title],"Company ","")) ========= APPLIES TO / KEY WORDS --------- Microsoft Access String Manipulation Strings VBA [...]
========= QUESTION --------- I want to use Windows to configure my wireless network connections, but my computer or network hardware manufacturer's software has disabled this feature. How do I re-enable it? ========= ANSWER --------- Windows XP The issue is the Wireless Zero Configuration service has been disabled or stopped. Open the Services applet from [...]
========= QUESTION --------- When opening a Microsoft Access database file, Access crashes with a pop up message stating: -------------------------------------------------------------------- Microsoft Access -------------------------------------------------------------------- Microsoft Access has stopped working Windows is checking for a solution to the problem... [Cancel] -------------------------------------------------------------------- Finally resulting in the following message: ---------------------------------------------------------------------------------------Microsoft Access ---------------------------------------------------------------------------------------Microsoft Access has stopped working A problem caused the [...]
========= 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 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. [...]