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

Can I work with Microsoft Office documents on my iPhone, iPad, iTouch?

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

By |2011-03-30T13:37:54+00:00March 30th, 2011|Apple, Cell Phone, Computers, Documentation, iOS|Comments Off on Can I work with Microsoft Office documents on my iPhone, iPad, iTouch?
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

How do I add a PayPal button to a DotNetNuke web site?

=========REF: http://blogs.snapsis.com/PermaLink,guid,94277650-bd4c-445f-badf-b84646ecc8eb.aspx =========QUESTION: When I add a PayPal Buy Now, Donate, Add To Cart, etc button to my DotNetNuke web site, the button simply refreshes the page, nothing happens. =========ANSWER: 1. Remove the <Form> </Form> tags from your PayPal code.2. AddonClick="this.form.action='https://www.paypal.com/cgi-bin/webscr'; this.form.submit();" to the Buy Now input button. Example:<input onclick="this.form.action='https://www.paypal.com/cgi-bin/webscr';this.form.submit();" alt="Make payments with PayPal - it's [...]

By |2017-12-01T23:47:52+00:00March 27th, 2011|DNN, Documentation, Internet/Web, PayPal|Comments Off on How do I add a PayPal button to a DotNetNuke web site?
Read More

How do I setup Google as an Exchange account on my iPhone?

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

By |2011-03-11T13:53:46+00:00March 11th, 2011|Apple, Cell Phone, Computers, Documentation, Google, iOS|Comments Off on How do I setup Google as an Exchange account on my iPhone?
Read More

How do I block my phone number from telemarketers?

Cell phone numbers are being released to telemarketing companies. You could start to receive sales calls and these calls will go towards your monthly usage. To prevent this, call the following number from your cell phone: 888-382-1222.It is the National DO NOT CALL list. It blocks your number for five (5) years and you must call [...]

By |2011-03-11T12:51:57+00:00March 11th, 2011|Articles, Cell Phone, Documentation|Comments Off on How do I block my phone number from telemarketers?
Read More

Why can’t I send outgoing email through Qwest/CenturyLink?

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

By |2017-12-01T23:47:52+00:00March 11th, 2011|anySiteSolutions.com, Computers, Documentation, Email, ISPs|Comments Off on Why can’t I send outgoing email through Qwest/CenturyLink?
Read More
Go to Top