Wednesday, May 09, 2018

List Box Filter

Multiple selections



Filter a Report based on List Box
Fabalou.com:
"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."


Microsoft KB:
How to Use a Multi-Select List Box to Filter a Form




See all Topics

Tuesday, May 08, 2018

Click to Trigger

Make it so



A trigger is an object on your PowerPoint slide - a picture, a shape, a button, or even a paragraph or text box. When you click on it an action is initiated. The action might be a sound, a movie, an animation, or text becoming visible on the slide.

Microsoft Office Online has a tutorial:
Use triggers to create an interactive slide show in PowerPoint

"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."

Indezine.com:
Trigger Animations




See all Topics

Monday, May 07, 2018

Canada/US Postal Codes

Automatic Input masks



If you have a mix of Canadian and US postal codes, you might play with the following code inserted as a Country control "After Update" Event property.

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 Sub



As a rule, if you won't be performing numeric calculations on the data, entries should be stored as text. Social Security numbers, Phone numbers and postal codes should be stored as text.


You can use alphabetic characters in an input mask. For example, one of the sample input masks is >L0L\ 0L0 used to represent a Canadian postal code.

The ">" character in the input mask converts all the characters that follow to uppercase.

The "L" character requires an alpha entry; the "0" (zero) requires a numeric entry.

A "\"character causes the following character to be displayed as a literal character rather than a mask character.

A space appears between the three character pairs.
For example, V5P 2G1 is one valid postal code that the user could enter. The mask would prevent the user from entering two sequential alphabetic characters or numbers.
See:

You can manipulate postal codes in Access by changing the data type, input mask, or format of a postal code field.

Microsoft KB 207829:
ZIP Codes in Microsoft Access.

Also see:
Postal Codes



See all Topics

Sunday, May 06, 2018

Alphabetize Your Keyboard

Eat your heart out Dvorak


The Microsoft Keyboard Layout Creator


Ever 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!

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.
Global Development and Computing Portal:
Windows Keyboard Layouts
(many different language keyboards)


Belarusian keyboard

Also see: Dvorak anyone?



See all Topics

Saturday, May 05, 2018

Share Outlook

Share it nicely


"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."

Here is one of the clearest expositions of multiple users' cooperative use of Outlook, even in a very small environment.

Sharing your Outlook information
By Crabby Office Lady


For up to date information on Outlook, SharePoint, and very little about waffles, see
Eric Legault My Eggo - Making Office Rock blog.

Also see:

Slipstick.com:
Sharing Microsoft Outlook Calendar and Contacts

Sharing Microsoft Outlook on One PC



See all Topics

Friday, May 04, 2018

Usable Ultimate Utensils

Great Gear


Kevin Kelly:
Cool Tools
"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."


Here are a few of the tools mentioned:
Disposable Suture Set
Micro tools
"The next time you or a friend are in the ER getting stitched up, ask your provider if you can have the suture set when he or she is done. Most places will hand them over if they are the disposable type. Hospitals use disposable suture sets since they are fairly inexpensive and decontamination of the reusable ones can be costly. The curved hemostat, the toothless needle driver, small surgical scissors and the pickups (tweezers) come in handy around the house." -- Fritz Araya
Ikea Tote Bag
Cheap huge tote bag
"Ikea sells these near the cash register. They are large -- about 4 feet by 2 by 2, with two clever lengthened (short & long) handles, made of some nearly indestructible nylon-plasticy mesh fabric in Ikea blue. For a buck, they're amazing. We put a mess at home, in the car, garden, garage. Great for dragging stuff from Sam's Club, or dirt in the garden, hauling firewood or just whenever you've a lot of loose stuff to move." -- Vince Crisci
NoTubes
Puncture-proof bike tires
"Stan's NoTubes system. In the NoTubes system you remove your inner tube from your tire. No tubes! You add a rim strip that seals your spoke holes. Since there is no tube you need a filling stem to put air into the tire.....this is built into the NoTubes rim strip. Then you add some white liquid inside the tire that seals it airtight. It's one of those things that seems like it would never work, but it works amazingly well. I will never go back to tubes." -- Alexander Rose




See all Topics