=========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/
=========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 [...]
=========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 [...]
=========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 [...]
=========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, [...]
=========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/
=========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 [...]
=========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 [...]
Scam: Domain Registry of America We have been getting more calls from clients receiving communication in the mail from an outfit by the name of "Domain Registry of America" looking to "help you" by offering to renew your domain name registration for you. This is a first class scam - shred these mailers as soon [...]
=========REF: http://office.microsoft.com/en-us/access-help/combine-the-results-of-several-select-queries-by-using-a-union-query-HA010206109.aspx#BM2a http://www.databasedev.co.uk/union_query.html =========NOTES / WARNINGS---------Union queries drop out duplicate records by default! If you want all records, including duplicates, you need to include the term ALL after the term UNION Example:<SQL from one Query>UNION ALL<SQL from another query>UNION ALL<SQL from another query> =========HOW TO---------Create the select queries in Design view first, and then combine [...]