========= QUESTION --------- How do I convert a file in Microsoft Publisher to a Microsoft Word Document? ========= ANSWER --------- Apparently the best way to do this is to save the TEXT of the Publisher file to a Word document first, and then copy over any images, etc... There does not appear to be [...]
========= QUESTION --------- How do I tell which edition (32 bit / x86 or 64 bit / x64) of Microsoft Office I have installed? ========= ANSWER --------- From any Microsoft Office application, select File, HelpOn the right side, you will see a version number in the following format:14.0.####.#### (##- bit)If the application version number [...]
========= QUESTION ---------I want to disable a button after the user has clicked it in my Form - is this possible? ========= ANSWER --------- Very simple - see EXAMPLES ========= EXAMPLES --------- clickedButton.Enabled = false ========= APPLIES TO / KEY WORDS --------- Microsoft Access VBA Button Command Button Enable Disable ========= [...]
========= 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 --------- 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 [...]