Loading...

Excel: Use Format Cells to replace numbers with text

========= QUESTION --------- I have  a spreadsheet where I need to have a number in a cell for the calculations being done on that cell, but I want TEXT to actually display in that cell, not the number. For example, I have a spreadsheet showing a per line item cost, and the per line item [...]

By |2017-12-01T23:47:41+00:00June 10th, 2011|Computers, Documentation, Excel, Microsoft|Comments Off on Excel: Use Format Cells to replace numbers with text

Access: Run-time error 13 Type MisMatch

========= QUESTION --------- I converted a Microsoft Access database from .mdb to .accdb format, and now when I run my usual VBA code to export a report to PDF, it gives me the error: Run-time error ‘13’: Type mismatch   ========= ANSWER --------- If you are not using an ADO object library, clear the reference to [...]

By |2017-12-01T23:47:41+00:00June 7th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off on Access: Run-time error 13 Type MisMatch

Access VBA: Export to Spreadsheet

========= QUESTION --------- How do I export to a spreadsheet using VBA?   ========= ANSWER --------- See EXAMPLES   ========= EXAMPLES --------- MyFilePath = "C:Test" Me.Status = "Creating Spreadsheet file" Me.Repaint DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "ReportOrQueryName", MyFilePath & "FileName.xls" --------- Me.CurrentStatus = _ "Exporting to Excel for Distribution" & vbCrLf & _ Now() & vbCrLf & _ vbCrLf & _ [...]

By |2011-06-07T17:47:17+00:00June 7th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off on Access VBA: Export to Spreadsheet

How do I renew my Domain Name Registration?

========= QUESTION --------- How do I renew my Domain Name Registration? I just received a "Upcoming Domain Renewal Notice" email - what do I do now?   ========= ANSWER --------- Logon to the Client Portal (How to logon to Client Portal: http://www.anysitesupport.com/how-do-i-logon-to-the-client-portal/) Click the Domains in the navigation barClick Renew DomainsSelect the checkboxes next the domains you [...]

By |2017-12-01T23:47:41+00:00June 1st, 2011|anySiteSolutions.com, Domain Name Registration|Comments Off on How do I renew my Domain Name Registration?

WordPress Shopping Cart Options

========= QUESTION ---------   ========= ANSWER ---------   ========= EXAMPLES --------- http://www.zingiri.com   ========= APPLIES TO / KEY WORDS --------- WordPress Shopping Cart PayPal   ========= REF ---------   ---http://www.anysitesupport.com/wordpress-shopping-cart-options http://anySiteHosting.com

By |2011-06-01T18:22:59+00:00June 1st, 2011|Documentation, Internet/Web, WordPress|Comments Off on WordPress Shopping Cart Options

How do I add an SPF record in DNS for my domain?

========= QUESTION --------- How do I add an SPF record in DNS for my domain?   ========= ANSWER --------- Logon to your control panel http://www.anysitesupport.com/how-do-i-logon-to-the-hosting-control-panel/ Navigate to the DNS Settings area http://www.anysitesupport.com/how-do-i-access-my-dns-settings/ Be sure to review the DNS records already listed to make sure there isn't already an SPF record you should edit. Click Add NewSelect [...]

By |2011-06-01T06:50:40+00:00June 1st, 2011|anySiteSolutions.com, Control Panel, DNS, Documentation, Domains / DNS, Internet/Web, Windows Hosting|Comments Off on How do I add an SPF record in DNS for my domain?

Windows XP Screen Print Utility

========= QUESTION --------- What utility can I use to mimic the Snipping Tool from Windows 7 on Windows XP?   ========= ANSWER --------- ScreenPrint32   ========= EXAMPLES ---------   ========= APPLIES TO / KEY WORDS --------- Snipping Tool Screen Print PrtScPrint Screen Screen SnipPrintScreen   ========= REF --------- http://www.screenprint32.com/ ...or just google it - this [...]

By |2011-05-31T14:05:06+00:00May 31st, 2011|Computers, Documentation, Microsoft, Windows, XP|Comments Off on Windows XP Screen Print Utility

WordPress: How to add a More link

========= QUESTION --------- How do I add a More or Read More link to my content? How do I split content using the More tag?   ========= ANSWER --------- Switch to HTML view, scroll to the section where you want to split the content and enter the tag shown in the EXAMPLES section of this [...]

By |2011-05-30T07:32:06+00:00May 30th, 2011|Documentation, Internet/Web, WordPress|Comments Off on WordPress: How to add a More link

How do I add a redirect to my web page?

========= QUESTION ——— How do I add code to my web page to redirect the browser to another page, web site, or subdirectory?   ========= ANSWER ——— Enter the code in the EXAMPLES section in the <HEADER> section </header> of your web page.   ========= EXAMPLES ——— HTML <meta http-equiv="REFRESH" content="0;url=http://www.anySiteHosting.com/Welcome/index.html"> PHP <?php // Permanent [...]

By |2011-05-30T06:13:23+00:00May 30th, 2011|Documentation, HTML, Internet/Web|Comments Off on How do I add a redirect to my web page?

How do you view the DNS records for a domain?

========= QUESTION --------- How do you view the DNS records for a domain?   ========= ANSWER --------- If you are a client: http://www.anysitesupport.com/how-do-i-access-my-dns-settings/  If you are simply looking in general, you can do so on a Windows PC by opening the command prompt and typing the commands in the EXAMPLES area.   ========= EXAMPLES --------- [...]

By |2017-12-01T23:47:42+00:00May 27th, 2011|Computers, Documentation, Domains / DNS, Internet/Web, Microsoft, MS-DOS / Batch|Comments Off on How do you view the DNS records for a domain?
Go to Top