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?
Read More

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?
Read More

Consolidate multiple Query Results into a single datasheet

=========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 [...]

By |2017-12-01T23:47:52+00:00March 30th, 2011|Access, Computers, Microsoft|Comments Off on Consolidate multiple Query Results into a single datasheet
Read More

VBA: Table Record Count

=========REF: http://www.pcreview.co.uk/forums/vba-table-record-count-t1104006.html�http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26940281.html�http://classicasp.aspfaq.com/general/why-does-recordcount-return-as-1.html =========NOTES---------Be careful with the use of CurrentDb.TableDefs("TABLENAME").RecordCount option. It's only available to the system when it is using a certain cursorType in your calls to the database. The default cursorType is Forward-Only and will not show the RecordCount. The best option is to open a record set:     Set rst = CurrentDb.OpenRecordset ("6050c__DrawingWinners")Then check [...]

By |2017-12-01T23:47:52+00:00March 30th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off on VBA: Table Record Count
Read More

Outlook: Filling in Date fields

When you are filling in a date field in Microsoft Outlook, you can literally type in "Two Weeks" in the date field, rather than a formatted date like "03/28/2011" and it will automatically update the date in that field to the two weeks out date for you. ========= "next week" "2 weeks" "3 days" "2 [...]

By |2011-03-28T09:46:18+00:00March 28th, 2011|Computers, Documentation, Microsoft, Outlook|Comments Off on Outlook: Filling in Date fields
Read More

VBA: Time and Date Functions

=========QUESTION: How do I add date  and/or time values to Access queries, VBA, etc...?   =========EXAMPLES:---------Day of the week of a given Date:Day: Weekday([TransDate])Day: IIf(Weekday([TransDate])=1,"Sun", IIf(Weekday([TransDate])=2,"Mon", IIf(Weekday([TransDate])=3,"Tue", IIf(Weekday([TransDate])=4,"Wed", IIf(Weekday([TransDate])=5,"Thu", IIf(Weekday([TransDate])=6,"Fri", IIf(Weekday([TransDate])=7,"Sat","nada"))))))) ---------The current month:DateSerial(Year(Date()), Month(Date()), 1) The next month:DateSerial(Year(Date()), Month(Date()) + 1, 1) The last day of the current month:DateSerial(Year(Date()), Month(Date()) + 1, 0) The [...]

By |2011-03-28T09:27:22+00:00March 28th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off on VBA: Time and Date Functions
Read More

Access: All table columns showing in query results

=========Error Message(s):---------Error message when you run a query in Access: "Cannot group on fields selected with '*'" ---------All fields showing in query results even though you only stipulated a few =========REF:---------http://www.pcreview.co.uk/forums/asterisk-automatically-added-end-query-sql-vie-t3283725.html  ---------http://support.microsoft.com/kb/835414  =========ANSWER(S): ---------To resolve this problem, set the Output All Fields property of the query to No, and then run the Access query that [...]

By |2017-12-01T23:47:52+00:00March 9th, 2011|Access, Computers, Documentation, Microsoft|Comments Off on Access: All table columns showing in query results
Read More

How do I logon to webmail?

Q. How do I logon to webmail? How do I access my email via the web site, rather than using email software? -- A. anySiteSolutions.com Smartermail If your email is hosted with anySiteSolutions.com, simply open a web browser and visit: https://smartermail.anySiteSolutions.com At the logon screen, please enter your full email address for the username and [...]

By |2020-03-13T13:14:12+00:00February 24th, 2011|anySiteSolutions.com, Email, Outlook, Outlook Web Access, SmarterMail|Comments Off on How do I logon to webmail?
Read More
Go to Top