========= QUESTION --------- All of a sudden when I am running a query that includes the standard Microsoft Access function Right(), it is erroring out on me with the error: "Undefined function "Right" in expression" ========= ANSWER --------- Apparently functions like this can go missing from time to time for varying reasons. To get [...]
========= QUESTION --------- Can you copy over the directory structure from one folder to another without copying the files in those directories? ========= ANSWER --------- Use XCOPY from the Command Prompt using the /t and /e switches to include empty directories and subdirectories. See EXAMPLES ========= EXAMPLES ---------xcopy "Q:PRODDATAReports" "C:UsersmyUserDocumentsSubDirSystemsQReports" /t /e [...]
========= QUESTION --------- We just switched to your hosting services, and we are still seeing our old web site at our past hosting provider, how do we fix this? How do I clear my DNS Cache? How to Flush DNS Cache ========= ANSWER --------- When a site is switched over from one hosting company [...]
========= QUESTION --------- How do I find my web site's IP Address? ========= ANSWER --------- Logon to the Hosting Control Panel http://www.anysitesupport.com/how-do-i-logon-to-the-hosting-control-panel/ --------- Windows Hosting Accounts Click Domains Click the domain you are interested in working with Click Web Site Settings The third line down: Website IPThis is your web site's IP Address --------- [...]
========= QUESTION --------- How do I setup my email client software? ========= ANSWER --------- We will use Microsoft Outlook 2010 and 2003 as examples (see EXAMPLES) to give you an idea of the steps involved for whatever email client or software you may be using. --------- You may also use webmail instead of an [...]
========= QUESTION --------- When I am setting up my email software, it is asking me to choose an account type: POP or IMAP? What is the difference, or which one should I choose? ========= ANSWER --------- To offer the best customer service, anySiteHosting.com has always supported both IMAP and POP protocols for accessing your [...]
========= QUESTION --------- I don't understand the difference between a domain name or domain name registration, and my web site hosting account? Can you please explain? ========= ANSWER --------- A domain name is simply the address to reach your web site. Think of your domain name as your home address, for example: 1234 Main [...]
========= QUESTION --------- How do I ignore an error for one section of code, but then disable ignoring errors for other sections of code? ========= ANSWER --------- See EXAMPLES ========= EXAMPLES --------- To ignore errors: On Error Resume Next To turn off ignoring errors: On Error GoTo 0 ========= APPLIES TO / [...]
========= QUESTION --------- Every time I open an Access Database from the network using Access 2010, I can't work in it until I click the [Enable Content] button. Is there a setting somewhere I can change to avoid this? ========= ANSWER --------- Access 2010Select File, Options Select Trust Center, Trust Center Settings… --Macro Settings: [...]
========= QUESTION --------- How to copy a web site in its current layout or format. ========= ANSWER --------- See REF ========= EXAMPLES --------- ========= APPLIES TO / KEY WORDS --------- Web Design Import Copy ========= REF --------- http://www.maximumsoft.com/products/wc_pro/overview.html ---http://www.anysitesupport.com/import-or-copy-website/ http://anySiteHosting.com