"How to open a report based on a multiple selection in a list box. For example, you may have a list of makes of car and a report that shows various details for each make of car. You want to allow the users to select a range of cars and pull up the report according to that selection."
"Here's a Power User column for teachers. Want to involve your students more in a presentation? Set up "triggers" for them to click as they go through the show. Triggers (related to animations) lets you add surprise to your slides while inviting your viewer to take part and have fun."
Private Sub Country_AfterUpdate()
Dim strCountry As String
strCountry = Me.Country
Select Case strCountry
Case "Canada"
Me.[PostalCode].InputMask = ">L0L\ 0L0;;_"
Case "USA"
Me.[PostalCode].InputMask = "00000-9999;;_"
Case Else
'If the country is not Canada or USA no input mask will be used
Me.[PostalCode].InputMask = ""
End Select
End SubEver wanted to quickly and easily define your own keyboard layout for a language Microsoft doesn't support? Or define your own keyboard layout so you can quickly and easily enter your favorite symbols with a simple keystroke? Well, want no more: the Microsoft Keyboard Layout Creator is here!Global Development and Computing Portal:
The Microsoft Keyboard Layout Creator (MSKLC) extends the international functionality of Windows 2000+, Windows XP, Windows Server 2003 or Windows Vista (MSKLC will not run on Windows 95, Windows 98, Windows ME or Windows NT4) by allowing users to:
- Create new keyboard layouts from scratch
- Base a new layout on an existing one
- Modify an existing keyboard layout and build a new layout from it
- Multilingual input locales within edit control fields.
- Package the resulting keyboard layouts for subsequent delivery and installation.
"Many home users and small businesses don't use Exchange. Fortunately, there are a variety of ways to share your e-mail, appointments, contacts, tasks, and notes with other Outlook users."
"Cool tools really work. A cool tool can be any book, gadget, software, video, map, hardware, material, or website that is tried and true. I am chiefly interested in stuff that is extraordinary, better than similar products, little-known, and reliably useful for an individual or small group. There are plenty of places to read about stuff that should be cool, or that looks new and cool, and that might be useful. The recommendations here, on the other hand, are based on people who have used this item and have come to see its superiority. I post things I like and I ignore the rest."
"QDE is a fully-functional Excel Add-in that provides quick input of dates, in all international formats. It handles quick data entry interpretation and reflects the three interacting issues of Date System, Day, Month Year ordering, and number of digits used in the quick date entry. With QDE you enter just as many digits as needed to clearly identify the date, QDE will do the rest."
Wacky Uses
- "Relieve itching from chicken pox, poison ivy, poison oak, or pain from sunburn. Pour two cups Cheerios in a blender and blend into a fine powder on medium-high speed. Put the powdered Cheerios into a warm bath and soak in the oats for thirty minutes. It's a soothing oatmeal bath.
- Make "Cheerios Chicken." Preheat oven to 400 degrees Fahrenheit. Line a jelly-roll pan (15.5 inches by 10.5 inches by 1 inch) with aluminum foil. Mix two cups finely crushed Cheerios (from the yellow box), one-quarter teaspoon pepper, one teaspoon parsley flakes, one-quarter teaspoon garlic powder, one-quarter teaspoon dried oregano leaves, and one-half teaspoon salt. Dip four chicken-breast halves (skinned and boned) into one-quarter cup milk, then roll in cereal mix until well coated. Place chicken in pan and drizzle with two tablespoons melted margarine. Bake until done, about twenty to twenty-five minutes. (Above 3,500 feet elevation, bake about thirty minutes.) Makes four servings."
"Sparks talks like Lucinda Williams sings; low, bed-headed and husky with sin, either remembered or imagined. In the syncopated monologues on her new spoken-word album, THIS DRESS, your gas-pumping mama, your fellow Baptists and your unmentionable relatives occupy every slot on the Waffle House jukebox, and when musical guests like Keb'Mos' and Maura O'Connell chime in, you can even dance to 'em.
---Jim Ridley Nashville Scene
With a voice born for gospel and a word artistry that makes you laugh and weep by turns, Sparks offers poems sorrowful and hilarious about the land of the double-wides.
---SANTA BARBARA INDEPENDENT-June 2005
SYMPTOMS
When you print on an LPT printer port, 100 percent CPU usage occurs until the print job is completed. This slows down other programs until the print job is completed. In some case, other programs may slow down enough that they seem completely unresponsive. This behavior affects all power users who have many programs running at one time.
CAUSE
This behavior occurs because Windows 2000/XP does not have interrupt support for LPT printers.
WORKAROUND
To work around this behavior, print to a Universal Serial Bus (USB) printer port. If the printer does not have this capability, use a parallel-USB cable.
STATUS
This behavior is by design.
"Under the International Organization for Standardization (ISO) standard 8601, a week always begins on a Monday, and ends on a Sunday. The first week of a year is that week which contains the first Thursday of the year, or, equivalently, contains Jan-4.
While this provides some standardization, it can lead to unexpected results - namely that the first few days of a year may not be in week 1 at all. Instead, they will be in week 52 of the preceding year! For example, the year 2000 began on Saturday. Under the ISO standard, weeks always begin on a Monday. In 2000, the first Thursday was Jan-6, so week 1 begins the preceding Monday, or Jan-3. Therefore, the first two days of 2000, Jan-1 and Jan-2, fall into week 52 of 1999.
An ISO week number may be between 1 and 53. Under the ISO standard, week 1 will always have at least 4 days. If 1-Jan falls on a Friday, Saturday, or Sunday, the first few days of the year are defined as being in the last (52nd or 53rd) week of the previous year.
Unlike absolute week numbers, not every year will have a week 53. For example, the year 2000 does not have a week 53. Week 52 begins on Monday, 25-Dec, and ends on Sunday, 31-Dec. But the year 2004 does have a week 53, from Monday, 27-Dec , through Friday, 31-Dec."
"The function WEEKNUM() in the Analysis Toolpack addin calculates the correct week number for a given date, if you are in the U.S. The user defined function shown here will calculate the correct week number depending on the national language settings on your computer."
- Aspirin
- The inventor of this modern miracle drug saw no use for it. Luckily, aspirin's formula was rediscovered nearly fifty years later and the rest is history. But, did you know that aspirin was included as part of the Treaty of Versailles?
- Band-Aids
- I'm stuck on Band-Aid 'cause Band-Aid's stuck on me. Millions of these little adhesive strip have been sold over the years. Yet, their existence may never have been if it weren't for Listerine.
- The Brassiere
- Mary Phelps Jacob is widely credited with inventing this article of clothing way back in 1913. Did she really invent this garment? Better yet, did you know that it could possibly kill you? Check out the real answers.
"In Microsoft Office Access 2007+, by default, users are not prompted to confirm changes after modifying and saving records on a form. But often you might want to prompt users to confirm their changes before the record is saved.
You can use a BeforeUpdate event procedure to display a confirmation prompt and handle a user's response to either cancel or continue with the save.
This visual how-to topic illustrates how to display a custom dialog box to prompt users to cancel or continue with saving changes to a record."
" This study sought to determine if certain personalities and uses are associated with various fonts. Using an online survey, participants rated the personality of 20 fonts using 15 adjective pairs. In addition, participants viewed the same 20 fonts and selected which uses were most appropriate.
Results suggested that personality traits are indeed attributed to fonts based on their design family (Serif, Sans-Serif, Modern, Monospace, Script/Funny) and are associated with appropriate uses.
Implications of these results to the design of online materials and websites are discussed."
- Cross-referencing: Using MLA Format
- This presentation teaches your students the purposes of MLA documentation, as well as methods for using parenthetical citations and a Works Cited page. This presentation is an important addition for the beginning of a research unit in a humanities course or any assignment that requires MLA documentation. (Writer and Designer: Jennifer Liethen Kunka)
Purdue University
- Documenting Sources: Using APA Format
- This presentation reviews the purposes of APA documentation, as well as methods for effectively using parenthetical citations and a reference page. This presentation is ideal for the begin ning of a research unit in a science course or any assignment that requires APA documentation. (Writer and Designer: Jennifer Liethen Kunka).
"If you have a table that contains a date field, and you want to make sure that something happens on that date, one way is to create an Outlook task with a reminder that will pop up on the specified date; you can even use the Outlook reminder to create an email message that will be sent on the specified date.
This article will show how to create an Outlook task from Access VBA code, and send an email message when the task's reminder fires."
Helen Feddema has been working with Word since v. 1.1, Access since the beta of v. 1.0, and Outlook since the beta of v. 8.0 (that's where Outlook started its version numbering).
"But what might not be evident in the simplicity of this slide is what happens when the audience experiences it along with your verbal explanation. Because the slide design is simple, the audience can quickly scan the headline and visual and understand the idea. Then their attention turns to the place you want it. — to you, the words you're saying, and the way the information relates to them. Instead of making everything explicit and obvious on the slides, you can leave the slides open to interpretation so the audience is dependent on you, and you on them.
What (the experts are) saying, basically, is that slides filled with bullet points create obstacles between presenters and audiences. You might want to be natural and relaxed when you present, but people say that bullet points make the atmosphere formal and stiff. You might aim to be clear and concise, but people often walk away from these presentations feeling confused and unclear. And you might intend to display the best of your critical thinking on a screen, but people say that bullet points "dumb down" the important discourse that needs to happen for our society to function well.
Somewhere in our collective presentation experience, we're not connecting the dots between presenters and audiences by using the conventional bullet points approach. This issue is of rising concern not only to individuals and audiences - even the major players of large organizations are taking notice of the problem. It seems that in every location where people meet, from small meeting rooms to board rooms to conference halls, people want a change."
"While working with forms, a split form can be a very useful view because you simultaneously get two views of the form that are connected to the same data source.
This demo shows you how to create a split form view where you can use the datasheet part of the form to quickly locate a record and the form portion to view or modify the record.
You will also learn how to enhance and customize a split form view to suit your needs."
Don't assume that the ZIP code (or postal code, as it is referred to in many countries outside the United States) has any particular format or length, or that it comprises only digits. For instance, Canadian postal codes consist of two groups of three characters, such as "M5R 3H5"; a French postal code is a five-digit number, as in 92300. In some places, people might add a country or region code in front of the postal code (for example, F-92300)
"The Federal Government's writing must be in plain language. By using plain language, we send a clear message about what the Government is doing, what it requires, and what services it offers. Plain language saves the Government and the private sector time, effort, and money."
Plain language can be understood by YOUR reader at first reading. It doesn't mean writing for a certain grade level - it means organizing and writing for your reader. Writing in plain language saves time and money for writers and readers.
Plain language matches the needs of the reader with your needs as a writer, resulting in effective and efficient communication. It is effective because the reader can understand the message. It is efficient because the reader can read and understand the message the first time.
Websites have both a "friendly" address, called a Uniform Resource Locator (URL) and an IP address. People use URLs to find websites, but computers use IP addresses to find websites. DNS translates URLs into IP addresses (and vice versa). For example, if you type http://www.microsoft.com into the address bar in your web browser, your computer sends a request to a DNS server. The DNS server translates the URL into an IP address so that your computer can find the Microsoft web server.