Variables in Batch Files and Commands

=========REF---------http://www.computing.net/answers/programming/batch-script-for-setting-up/12506.html  http://www.msfn.org/board/topic/37472-username-in-batch-file/ =========EXAMPLES---------Test the following by typingECHO %username%, etc at the command prompt %username% %computername% %systemroot% =========APPLIES TO / KEYWORDS---------Microsoft DOSMS-DOSBatchCommandsVariables ---http://www.anysitesupport.com/variables-in-batch-files-and-commands/

By |2011-04-08T11:15:48+00:00April 8th, 2011|Computers, Documentation, Microsoft, MS-DOS / Batch|Comments Off on Variables in Batch Files and Commands

Do you offer web site design?

Yes! We do offer web site design in addition to our hosting services, consulting, email, and many other technical services, we do of course do web design as well! We have staff on hand ready to:--Update or maintain an existing site--Add content or copy writing--Complete re-designs--Templated builds to allow you to do further updates on your [...]

By |2017-12-01T23:47:51+00:00April 7th, 2011|anySiteSolutions.com, Services, Web Design|Comments Off on Do you offer web site design?

What password do I need to publish my web site?

=========QUESTION---------I am trying to publish my web site to my hosting account.What password do I need to publish my web site? =========ANSWER---------This will normally be your FTP username and password that were delivered to you in your welcome email. FTP Host/Server: FTP.YOURDOMAINFTP User: YOURDOMAINFTP Pass: YOURPASSWORD   =========RELATED TOPICS---------How do I reset my FTP Password? [...]

By |2011-04-07T10:57:48+00:00April 7th, 2011|anySiteSolutions.com, FTP, Linux Hosting, Web Design, Windows Hosting|Comments Off on What password do I need to publish my web site?

How do I query the top X of something?

=========QUESTION---------I have TABLE-A with 19000 records in it.Each record contains REGION, DISTRICT, STORE, NAME, and that person’s SALESHow do I find the top sales per Region, or per District, or per Store, etc...   =========ANSWER---------OPTION 1 All it takes is three simple MAKE TABLE* queries: In this example, we will find the top SALES per [...]

By |2017-12-01T23:47:51+00:00April 7th, 2011|Access, Documentation, Microsoft|Comments Off on How do I query the top X of something?

VBA: Check if table exists

=========QUESTION---------In Microsoft Access 2007, using VBA, how can you check to see if a table exists? =========EXAMPLES---------On Error Resume Next --------- Public Function dbsTableDelete(DBName)    Count = 0    tblNotFound = False    Do Until tblNotFound        If DBName = dbs2020.TableDefs(Count).Name Then            dbs2020.TableDefs.Delete (DBName)            Exit function        End If        Count = Count + 1        'Determine if we are at the [...]

By |2017-12-01T23:47:51+00:00April 7th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off on VBA: Check if table exists

How do I create a PayPal button?

=========QUESTION---------How do I create a PayPal button? =========ANSWER---------Create a new button: Logon to your account at PayPal.comClick the Merchant Services tabClick the Buy Now Button linkFill in the specifics, and click Create ButtonCopy the code shown, and paste it into your web site code. ---------Re-use a previously created button: Logon to your account at PayPal.comClick the Merchant [...]

By |2017-12-01T23:47:51+00:00April 7th, 2011|Internet/Web, PayPal|Comments Off on How do I create a PayPal button?

Microsoft Excel: Transpose Columns and Rows

=========QUESTION---------You have a spreadsheet where you want the data you have entered as rows to now be in columns and the data you have entered as columns to now be in rows. =========ANSWER---------Select your data, copy.Select where you would like to paste the newly transposed dataSelect the the dropdown arrow under Paste in the toolbar, [...]

By |2011-04-06T14:54:50+00:00April 6th, 2011|Computers, Documentation, Excel, Microsoft|Comments Off on Microsoft Excel: Transpose Columns and Rows

Keyboard shortcuts for Microsoft Excel

=========QUESTION / DESCRIPTION---------Keyboard shortcuts for Microsoft Excel =========EXAMPLES---------F2Puts the current cell into edit mode, just as if you clicked the Formula Bar ---------. =========REFERENCE---------http://www.mvps.org/dmcritchie/excel/shortx2k.htm =========APPLIES TO / KEYWORDS---------Microsoft Excel ---http://www.anysitesupport.com/keyboard-shortcuts-for-microsoft-excel/

By |2011-04-05T09:56:54+00:00April 5th, 2011|Computers, Documentation, Excel, Microsoft|Comments Off on Keyboard shortcuts for Microsoft Excel

How do I FTP using DOS Commands?

=========REF: http://www.nsftools.com/tips/MSFTP.htm  http://rotterdam.ics.uci.edu/info/DosFtp.htm =========ANSWER: Open a command prompt on your PC:Click the Start button, select RunType: COMMANDClick [OK] At the command prompt: ("text" to be entered at the command prompt is in quotes ; <keystrokes> to be typed are in carats)"FTP"<enter>"open anysitehosting.com"<enter> Enter your username  and hit <enter>Enter your password and hit <enter> =========EXAMPLES ---------"cd [...]

By |2017-12-01T23:47:51+00:00April 4th, 2011|anySiteSolutions.com, Computers, Documentation, FTP, FTP, Internet/Web, Microsoft, MS-DOS / Batch, Windows|Comments Off on How do I FTP using DOS Commands?

How can I find large files on my hard drive?

=========REF: http://windows.microsoft.com/en-US/windows-vista/Tips-for-finding-files =========QUESTION / PROBLEM I am running out of diskspace on my hard drive, and have no idea how to find the files that are taking up the most room. =========ANSWER / SOLUTION In Windows XP, simply right click your C: drive, and select Search.This will will bring up the Windows Search tool.Click the [...]

By |2017-12-01T23:47:51+00:00April 4th, 2011|Computers, Documentation, Microsoft, Windows|Comments Off on How can I find large files on my hard drive?
Go to Top