=========CALENDAR---------[Ctrl]+2: Go to Calendar view from any other view. [Alt]+1-9: View specific number of days, beginning with the selected day. For instance, if April 14 is selected and you press [Alt]+4, Calendar will display April 14 through 17. I use this one often. [Ctrl]+G: Go to a specific date. When you press [Ctrl]+G in Calendar [...]
=========EXAMPLES:---------SELECT Last(wp_terms.name) AS LastOfname, wp_posts.post_title, wp_posts.post_content, wp_term_taxonomy.taxonomy, wp_posts.post_type, wp_posts.post_statusFROM ((wp_posts LEFT JOIN wp_term_relationships ON wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) LEFT JOIN wp_terms ON wp_term_taxonomy.term_id = wp_terms.term_idGROUP BY wp_posts.post_title, wp_posts.post_content, wp_term_taxonomy.taxonomy, wp_posts.post_type, wp_posts.post_statusHAVING (((wp_term_taxonomy.taxonomy)="category") AND ((wp_posts.post_type)="post") AND ((wp_posts.post_status)="publish")); ---------$querystr = "SELECT * FROM $wpdb->posts LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id) LEFT [...]
=========QUESTION---------How do I ping a web site address? =========ANSWER---------In Microsoft Windows: Start button, Run, type COMMAND, click [OK]A black window titled Command Prompt should openAt the prompt type the following:PING WEBSITENAME (replace WEBSITENAME with your domain name) --------- In Macintosh OS X: Launch Terminal (open Spotlight by pressing Command + Space bar, and type Terminal)A small [...]
=========NOTES---------Create a form to house the controls (ControlPanel) Create buttons on the form and a CurrentStatus text box Write VBA Code tied to the buttons to update the CurrentStatus text box and to execute Macros that execute Queries ---http://www.anysitesupport.com/access-application-best-practices/
=========EXAMPLES---------Set rst = CurrentDb.OpenRecordset("Parms")EOW = rst.EOWDateMe.CurrentStatus = "EOW Date set to " & EOW & vbcrlf rst is simply a name to hold your recordset where you are opening the table ParmsEOW is simply a name to hold the field you are querying ---http://www.anysitesupport.com/access-vba-how-do-i-display-a-field-value/
=========ERROR / MESSAGE---------The database has been placed in a state by <user> on <machine> that prevents it from being opened or locked. =========SCENARIO---------You are pasting a table, query, form, etc from Access Database file to another, and this error pops up stopping you from pasting. =========NOTES---------Standard answer:This error occurs when the new passive shutdown/connection control [...]
=========EXAMPLES---------Phone Number:If numbers stored as text:Format([field],"@-@@@-@@@-@@@@") If numbers stored as numbers:Format(2127851212,"(000)000-0000") ---------Format([Store],"0000") Input Mask for Table Field:!(999)000-0000 --------- ZIP: IIf(Len([ZipCode])<6, Format([ZipCode],"@@@@@"),Format([ZipCode],"@@@@@-@@@@")) ---http://www.anysitesupport.com/access-format-fields/
We get a lot of questions from our clients trying to figure out the pros and cons of purchasing a netbook versus a full power laptop. What is a netbook? Think iPad with a keyboard. Why? Well, it is quite obvious if you think about it - What does the world run on again? Oh [...]
=========EXAMPLE---------=Today()-1 =DATE(2011,4,15)-1 =========REF---------http://www.excelforum.com/excel-worksheet-functions/570878-today-minus-1-day.html http://www.cpearson.com/excel/datearith.htm ---http://www.anysitesupport.com/excel-date-minus-1/
This content is password-protected. To view it, please enter the password below. Password: