Friday, February 28, 2014

Sort Listboxes

We must have order




"A nice way to enhance your application is to give your users the ability to sort the contents of listboxes.

If you have a listbox with many records, this feature could be much appreciated. It's easy to manipulate the listbox RowSource property to accomplish this.

A command button could be used to add an "Order By" clause to the SQL statement, and once the RowSource property is updated, the list is automatically sorted."


An example showing exactly how to do this is available for download as a Zip file here: Sortable Link Boxes

from Peter's Software



See all Topics

Thursday, February 27, 2014

Calendar Control

Click for Date



Office is full of ActiveX controls that provide extra gadgets in applications. One of these devices is a functioning calendar selection tool.

"Did you ever need to check a date before you typed it into a document?

This tutorial shows you how to create a pop-up calendar using the Microsoft ActiveX Calendar Control that is installed with Office.

You will be able to call up the calendar with a keyboard shortcut, from a toolbar button or menu, or from the right-click context menu.

When you select a date, it is automatically entered into your document at the insertion point."


A Pop-up Calendar for Word

Martin Green



See all Topics

Wednesday, February 26, 2014

1040 on a Spreadsheet

Free tax forms


All right, we spend our waking hours SUMming with Excel and then when one of the more stressful times of the year shows up, we turn it all over to TurboTax.

Here is a collection of IRS forms Glenn Reeves has done as interlocking spreadsheets.

The formulas are already set up; ready for data entry.
"No PASSWORD is needed!

If a cell is protected, it is because it contains a calculated value.

Many times, a manual override cell is provided if you need to override the calculated value.

After a while, you will figure out that the spreadsheet is completely functional without needing to unprotect it."



(Included on the site are forms back to 1996.)

http://www.excel1040.com



See all Topics

Tuesday, February 25, 2014

Other than Google

Info Tools


Add even more depth to your research than just the usual search engines.


Google, the largest search database on the planet, currently has around eight billion web pages indexed. That's a lot of information. But it's nothing compared to what else is out there.
Google can only index the visible web, or searchable web. But the invisible web, or deep web, is estimated to be 500 times bigger than the searchable web. The invisible web comprises databases and results of specialty search engines that the popular search engines simply are not able to index.


Have you heard of:
  1. Intute - A searchable database of trusted sites, reviewed and monitored by subject specialists.

  2. INFOMINE - A virtual library of Internet resources relevant to university students and faculty. Built by librarians from the University of California, California State University, the University of Detroit-Mercy, and Wake Forest University.

  3. Librarians' Internet Index - A search engine listing sites deemed trustworthy by actual human librarians, not just a Googlebot.

Topics Covered in this Article
  • Deep Web Search Engines
  • Art
  • Books Online
  • Business
  • Consumer
  • Economic and Job Data
  • Finance and Investing
  • General Research
  • Government Data
  • International
  • Law and Politics
  • Library of Congress
  • Medical and Health
  • Science
  • Transportation

And many more: Research beyond Google



See all Topics

Monday, February 24, 2014

Update the FUI Ribbon

Let the add-ins begin


It is said that the Office 2007 Graphical User Interface Ribbon cannot be as easily changed or modified like it has been in previous versions.

This may be partially true, but not all is lost.

Here is some information from the equine's mouth:


Learn how to customize the Ribbon user interface (UI) in the 2007+ Microsoft Office release. Also learn how new features in Microsoft Visual Studio 2005 Tools for the 2007+ Microsoft Office System support RAD development of Ribbon customizations. (40 printed pages)

Customizing the Office Ribbon


Monsieurs MS also have a downloadable spreadsheets with the Control IDs. There are files for 2003 as well.

Lists of Control IDs


2007 Office System Add-In: Icons Gallery



See all Topics

Sunday, February 23, 2014

More More Free Templates

Clean, professional layouts


Besides some intriguing enterprise PowerPoint solutions, PresentationPoint.com has some free designs that you can download and adapt to your own uses.

One of the designs is a timer:



PresentationPoint.com



See all Topics

Saturday, February 22, 2014

Properties Report

Record of Records



If you would like a report that includes all of the properties, relationships and permissions of the objects in your database, go to Tools>Analyze and choose Documenter...

Access will create a VERY detailed report.

Access Documentation


Ezy Documenter



See all Topics

Friday, February 21, 2014

Myths

Say it ain't so




My seven favorite myths about Outlook
Diane Poremsky




  1. Outlook is the reason we have so many email viruses

  2. Outlook is the "full version" of the free Outlook Express

  3. Outlook's HTML is bloated, especially if you use Word as the editor

  4. Outlook has a newsreader (pre 2007)

  5. The preview pane is unsafe

  6. Word is a slow, bloated email editor

  7. Attachments run automatically
Outlook Power Magazine



See all Topics

Thursday, February 20, 2014

Look for Bullets

Find lists


Unless you have used a style to create a bulleted list, it is difficult to search for them.

This macro locates any bulleted list (wdListBullet) in your document.


Sub FindBullet()
Dim rngTarget As Word.Range
Dim oPara As Word.Paragraph

Set rngTarget = Selection.Range
With rngTarget
Call .Collapse(wdCollapseEnd)
.End = ActiveDocument.Range.End

For Each oPara In .Paragraphs
If oPara.Range.ListFormat.ListType = _
WdListType.wdListBullet Then
oPara.Range.Select
Exit For
End If
Next
End With
End Sub

Other choices might be:
wdListListNumOnly
ListNum fields that can be used in the body of a paragraph.

wdListMixedNumbering
Mixed numeric list.

wdListNoNumbering
List with no bullets, numbering, or outlining.

wdListOutlineNumbering
Outlined list.

wdListPictureBullet
Picture bulleted list.

wdListSimpleNumbering
Simple numeric list.





See all Topics

Wednesday, February 19, 2014

Statistical Functions

Definitions and list


Excel contains a slew of functions relating to statistical analysis.

That's a slew not a skew.

SKEW(number1,number2,...)

Returns the skewness of a distribution. Skewness characterizes the degree of asymmetry of a distribution around its mean.

Positive skewness indicates a distribution with an asymmetric tail extending toward more positive values.

Negative skewness indicates a distribution with an asymmetric tail extending toward more negative values.


Statistical Functions

Training - Statistical



See all Topics

Tuesday, February 18, 2014

Speedy Net Stuff

How fast is it?


Your connection to the internet is based on a number of factors; your machines capability, connection mode, and sometimes even the weather.
Here are some sites that let you test your up and down speed.

Speakeasy.net

BandWidthPlace.com

CNET.com

And here's a cool one from SpeedTest.net:





See all Topics

Monday, February 17, 2014

Verbose Messages


The whole story


If you have trouble with slow startup, shutdown, logon, or logoff, you might try this procedure.


This setting allows you to configure Windows so that you receive verbose startup, shutdown, logon, and logoff status messages!




  1. Go to Run and enter Regedit


  2. Find or create the key in


    HKLM\SOFTWARE\Microsoft\CurrentVersion\Winlogon.

  3. To enable verbose status messages create a new DWORD value called "verbosestatus" and set it to "1".


  4. In order to see the messages, an additional value called "DisableStatusMessages" should be set to "0".


  5. Restart Windows.
VerboseStatus



See all Topics

Sunday, February 16, 2014

Speed Up the Show

Worth a try



If you have a slow machine, these tips from the Help file may speed things up:

If your presentation seems to be running slowly, try one or more of the following Settings

Reduce the resolution for the slide show presentation display.

  1. On the Slide Show menu, click Set Up Show.

  2. In the Slide show resolution box, click 640x480 in the list.
Note: Changing resolution may cause the slide image to be slightly shifted. If this happens, either choose a different resolution or click Use Current Resolution. Set the color depth to 16 bit for optimal performance.
  1. On the Microsoft Windows Start menu, point to Settings, and then click Control Panel.
  2. Double-click Display, and then click the Settings tab.
  3. Under Colors, click High Color (16 bit) in the list, and then click OK.
On the Slide Show menu, click Set Up Show, and then select the Use hardware graphics acceleration check box. If your computer has this capability, Microsoft PowerPoint will attempt to use it. Note: If you notice performance problems with the slide show after you change this setting, turn off the option. Your computer may not have this capability.

Also:
From Microsoft Office Online:
Improve slide show performance



See all Topics

Saturday, February 15, 2014

Home School Computers Available

Need PCs?



"Our economy is at a crucial turning point. Jobs in America require technological skills and computer expertise. The CFL program places computers in our classrooms and prepares our children to contribute and compete in the 21st century.

The CFL website connects the registered needs of schools and educational nonprofit organizations with available computer equipment. The program allows federal agencies and private sector entities to transfer unneeded computers and related equipment to schools and educational nonprofit organizations, while giving special consideration to those with the greatest need."

Computers for Learning (CFL) FAQ


"Schools and educational nonprofit organizations can participate in the CFL program.

A school is eligible to participate if it is a public, private, parochial, or home school serving pre-kindergarten through grade 12 students. Day care centers must provide a state approved preschool curriculum in order to participate. "




See all Topics

Friday, February 14, 2014

Define Relationships by Keyboard

It's not a drag


If you've played with Access, you know that you can create relationships by dragging fields from one table to another.

There is another way to do it using just the keyboard.

I don't know why you would do it this way, but let's assume you lent your mouse to your brother-in-law for the week-end. (?)


  1. Close any open tables.

  2. Use F11 to switch to the Database window.

  3. Press ALT+T to select the Tools menu, and then press R to open the Relationships window.

  4. If the Show Table dialog box does not appear, press ALT+R to select the Relationships menu, and then press T to open the Show Table dialog box.

  5. In the Show Table dialog box, select the first table that you want to relate, and then press ENTER to add it to the Relationships window.

  6. Repeat step 5 for any other tables you want to relate, and then press ALT+C to close the Show Table dialog box.

  7. Press ALT+R to select the Relationships menu, and then press R to open the Edit Relationships dialog box.

  8. Press ALT+N to open the Create New dialog box.

  9. In the Left Table Name box, select the name of the table that contains the primary key.

  10. In the Right Table Name box, select the name of the table that contains the foreign key.

  11. In the Left Column Name box, select the primary key field, and in the Right Column Name box, select the foreign key field.

  12. Press ENTER.

  13. In the Edit Relationships dialog box, use the arrow keys to make sure that the two columns contain the field names you want.

  14. Press ALT+C to create the relationship.
Support.Microsoft.com:
Define relationships by using the keyboard  



See all Topics

Thursday, February 13, 2014

Font Properties Plus

Everything you need to know


To embed a font in a document or slide show so it can be displayed on any other machine, the font must support that action. The standard Windows properties statement does not show all the needed information.

The bottom of this illustration shows the standard information shown when you right-click a font file, and choose properties. The two views at the top are what appear when the Microsoft Font properties extension is installed.


Font Properties

If you right click on a font file in Windows its basic properties are displayed. The Font properties extension adds several new property tabs to this properties dialog box. These include information relating to font origination and copyright, the type sizes to which hinting and smoothing are applied, and the code pages supported by extended character sets.

It also will tell you if the font can be embedded and/or edited in a document.



Protected
The font may not be embedded, copied, or modified. If you use a protected font in a document and if the document is opened on a computer that does not have the font installed on it, a font substitution occurs. Word substitutes the closest font available on the computer for the missing protected font.
Print/Preview
The font is embedded and temporarily loaded on the target computer. Documents that contain print/preview fonts must be opened read-only, and no edits are stored in the document. Embedding a font of this nature has the least impact on file size increase.
Editable
The font behaves just like the print/preview fonts, except that you may also apply the font to other text in the same document.
Installable
The font is installed on the target computer permanently when you open the document. This allows you to use the new fonts as if you installed the fonts directly into Windows yourself. This type of embedded font has the greatest impact on file size because the entire font or fonts are included with the document.


Versionand Features tabs
The Version tab includes version and date information. The Features tab describes the font in terms of number of glyphs, number of kerning pairs, the possible existence of a euro symbol and the presence of embedded bitmaps within the font.

Linkstab
If a font doesn't include a Web site URL, but does include a 'vendor ID code' a link will be provided to Microsoft's font vendor database.

Font properties extension, version 2.3
(32-bit only)



See all Topics

Wednesday, February 12, 2014

Results as a Picture

If 4, show kumquat


Allen Wyatt has a cool procedure that will let you show a picture of an object on your spreadsheet depending on a value.

Maybe a snow suit when it's 29 or, say, a pair of bloomers when the computed temperature is 70.

The procedure does not use any VBA, just equations and bright thinking.

ExcelRibbon.Tips.net

Display Images based on a Result



See all Topics

Tuesday, February 11, 2014

Send Large Files

Surpass Attachments


Some email services such as Hotmail and Yahoo mail only allow email attachments up to 10 MB in size.

If you need to send larger files take a look at services such as YouSendIt.

"The Services provide a user the ability to send a file to one or more recipients identified by a valid email address. The Services operate by storing the specified User File on a YouSendIt server and then sending to the recipient(s) an email that contains a link to the User File.
The recipient(s) can then access and download the User File by clicking on the link."


Hightail.com

Also:

DropSend.com

Top 6 Services to Send Large Files



See all Topics

Monday, February 10, 2014

Back Me Up

Tomorrow is too late



There is a company called the Argentum Corporation. They produce some commercial products to help organize files and facilitate backups.

They, also, provide a free Back up guide


"This backup guide focuses on backing up in general, assists you in finding important data on your computer, explains you how to locate the proper paths, files and folders that may be recommended for regular backup.
The following topics are covered in detail:


  • My Documents backup,
  • Outlook data backup,
  • E-mail backup (Outlook Express),
  • registry backup,
  • messenger backup (ICQ, MSN, Yahoo!, AOL),
  • system folders backup and more"




See all Topics

Sunday, February 09, 2014

Create Animation Schemes

Roll your own



When you click on Slide Show>Animation Schemes, the task pane will display pre-set animations.

You can create your own Animation Schemes.

Shyam Pillai from PowerPoint MVPS.org details the steps to take and a downloadable template.

Animation Schemes in PowerPoint

"The best part is that you can add/modify and distribute animation schemes of your own.
All the schemes are present in a read-only file quikanim.ppt located in
C:\Program Files\Microsoft Office\Office10\1033 

(the path may vary depending on the drive and installation folder).
This file is essentially a normal PowerPoint file. You can open the file in PowerPoint directly. However it is best to remove the read-only flag before opening it."




See all Topics

Saturday, February 08, 2014

Tiny Trebuchet

Pumpkin (seed) flinger


Something there is that is fascinated by hurling things through the air. The medievals tossed oil and rocks.
Today it's mostly Fall vegetables.

Here's away to bring the machine down to desk level and make cubical living even more dangerous.



Build your own 3" trebuchet out of paperclips

Also:
Build a Trebuchet in your backyard



See all Topics

Friday, February 07, 2014

Search the Way You Want

It's your choice


Using Find in Access can be frustrating when you forget to change the search options.

You can change the defaults to something closer to your personal search preferences.

To do so, select Tools>Options from the menu bar (the Office Logo in 2007).

Then, click on the Edit>Find tab (under Advanced in 2007) and select the option button you want from Default Find>Replace Behavior.


  • Fast Search is the default, and causes Access to search the current field for an exact match to your criteria.

  • General Search, searches all fields and matches any part of the field.

  • Start Of Field Search, searches the current field for matches between your search string and the beginning characters in the field.

When you've made your selection, click OK.



See all Topics

Thursday, February 06, 2014

Make Sender Safe

Vouch for your friends


Add names to your Safe Senders List.

If the Junk E-mail Filter mistakenly marks an e-mail message as junk, you can add the sender of that message to the Safe Senders List. E-mail addresses and domain names that appear in the Safe Senders List are never treated as junk.

  1. On the Tools menu, click Options.

  2. On the Preferences tab, under E-mail, click Junk E-mail.

  3. Click the Safe Senders tab.

  4. Click Add.

    In the Enter an e-mail address or Internet domain name to be added to the list box, enter the name or address that you want to add. For example, you can add the following types of addresses:

    All@Once.com
    @Once.com
    Once.com

  5. Click OK. .



Information About the Safe Senders Option



See all Topics

Wednesday, February 05, 2014

Large Documents

Plan ahead


Jack M. Lyon has prepared a list of steps to be considered when working with large documents:
"I can't leave the topic of typesetting without explaining some of the things I learned on the last book I typeset--in Microsoft Word. The book had more than 400 pages and several hundred footnotes, and Word would have handled it better if I'd been more particular about the following:"

Typesetting Tips for Word



See all Topics

Tuesday, February 04, 2014

Worksheet Name

Formula construction


There may come a time when you need to display the name of a worksheet.

This formula will do the job:
=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,31)

=CELL("filename",$A$1) 
returns the path, the Workbook name and the Worksheet name. (C:\Documents\[April.xls]\Costs)
=MID(text,start_num,num_chars) 
selects the text that starts at a certain point and goes on for a certain number of characters.

The formula, as written, looks at the full path and selects the first time a closing bracket (]) is found.

It then moves 1 character to the right and displays the results up to 31 characters.
(A worksheet name cannot be more that 31 characters long.)

You could include a reference to that cell on other worksheets.



See all Topics