=========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 [...]
=========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 [...]
Yes! You can work with (Open, Edit, Save, Create New, etc) Microsoft Office documents on your iPhone, iPad, iTouch, any iOS device. The best app we have found for doing so is Quick Office Connect Mobile Suite.This app hooks up to your DropBox account and allows you complete access to any Word, Excel, or PowerPoint [...]
=========REF:---------http://www.access-programmers.co.uk/forums/showthread.php?t=200804 =========EXAMPLES:---------Me.StatusBox.SetFocusMe.StatusBox.SelStart = Len(Me.StatusBox.Value) ---http://www.anysitesupport.com/vba-automatically-scroll-to-bottom-of-text-box/
=========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 [...]
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 [...]
=========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 [...]
=========REF:---------http://www.google.com/support/mobile/bin/answer.py?answer=138740&topic=14252 =========How do I setup Google as Exchange account on my iPhone, iPad, or other iOS device? --Settings--Mail, Contacts, Calendars�--Add Account--Select Microsoft Exchange --In the Email field, enter your full Google Account email address. If you use an @googlemail.com address, you may see an "Unable to verify certificate" warning when you proceed to the next [...]
=========ERROR MESSAGES:---------Outlook cannot connect to your outgoing smtp email serverIf you continue to receive this message contact your server administrator or Internet Service Provider =========RESOLUTION / NOTES:---------Several of our customers who utilize Qwest DSL as their ISP (Internet Service Provider) have called with issues where their email client is coming up with errors like cannot [...]
=========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 [...]