========= QUESTION --------- We need to add a firewall exception for one of our client's dedicated IPs to avoid the CPanel auto lockouts, etc. ========= ANSWER --------- > To remove an IP from the block list and add it to the allow/ignore lists:-- Log in to WHM with your root account-- In the find [...]
========= QUESTION --------- All I am doing is trying to do a calculation or manipulation on a field in my query, and it comes up with #Error rather than the results. If I do the calculation in a test field, it works just fine - what's going on? ========= ANSWER --------- Obviously, this could [...]
========= 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 [...]