========= QUESTION --------- To keep my VBA code clean, I use quite a few line continuations ( & _ ). Recently, however, Access errored out on me with the note: Too Many Line Continuations. Is there a way to work around this? ========= ANSWER --------- Yep - just trick it by setting half your [...]
========= QUESTION --------- I use a table called Parms in my database to store application specific parameters.If a user accidentally added a record to this table, instead of simply editing the single record containing the appropriate values, it would cause major issues for the application. Is there a way to restrict a table to contain [...]
========= QUESTION --------- I need to do a find and replace in a large text file, but I want to replace the found text with a carriage return (as if I had hit the return key on the keyboard) instead of general text. ========= ANSWER --------- Use Notepad++'s Extended Search mode! Do a normal [...]
========= 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 --------- I want to plug my iPhone into my computer to charge the battery or sync to iTunes, but I do not want to use it as a Personal Hotspot, because I have a better wireless or wired network connection instead. How do I disable the Internet connection through my phone? ========= [...]
========= 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 --------- Our web site is hosted on anySiteHosting.com's web servers, and we need to access the MySQL or MSSQL database server from our local machines. ========= ANSWER --------- LINUX HOSTING PLAN Login to the Hosting Control Panel http://www.anysitesupport.com/how-do-i-logon-to-the-hosting-control-panel/ Scroll down and click the Remote MySQL icon in the Databases section Enter the your [...]