Thursday, October 19, 2017

Place Controls Where You Want

Works with other apps as well


The Snap To Grid feature is an invaluable tool for aligning controls when you're designing forms and reports. However, when you fine-tune the placement of some controls, you'll probably want to move some of them to positions that aren't exactly aligned with the design grid.

You can temporarily disable the Snap To Grid feature by holding down the [Ctrl] key. Then, you can use your mouse or the cursor arrows to place the controls exactly where you want them.



See all Topics

Wednesday, October 18, 2017

Create a Template

More of a good thing


After putting together the ultimate proposal, or dunning notice, you can save the document as a template so that you don't have to re-invent the whole thing.

Here's how to do it in Word 2007-13.
(Earlier versions also use "Save As")


  1. Click the Microsoft Office Button , and then click Open.

  2. Open the document that you want.
    Make the changes that you want to appear in all new documents that you base on the template.

  3. Click the Microsoft Office Button , and then click Save As.

  4. In the Save As dialog box, click Templates if your computer is running Windows or Vista, or click Trusted Templates if your computer is running Windows XP.

  5. Give the new template a file name, select Word Template in the Save As type list, and then click Save.
Note You can also save the template as a Word Macro-Enabled Template (.dotm file) or a Word 97-2003 Template (.dot file).

Create a new template

Also:
Templates are digital stencils  



See all Topics

Tuesday, October 17, 2017

Read All About IT

Excel reading


Bastien Mensink, from the Netherlands, runs ASAP-Utilities.com.

He has aggregated the headlines from a number of Excel Blogs.

If you don't have them as part of your RSS list, you should.

Weblog Headines



See all Topics

Monday, October 16, 2017

Synch Time

Time Server


Things I've forgotten or never knew.

  1. Double click on the date and time on the taskbar to open the time applet.

  2. Click on the Internet Time tab.

  3. Choose a time server, and click on the Update Now button.

As long as you are connected to the internet, Windows will attempt to synchronize the time once per week.
You can type the name of a time server if you want to use one that is not listed. Only time servers that use the Simple Network Time Protocol (SNTP) will work. Inserting an Internet address that uses the Hypertext Transfer Protocol (HTTP) will not work. The time server time.windows.com is operated by Microsoft. The time server time.nist.gov is operated by the U.S. government. Other time servers provided by your computer's manufacturer might also be listed.



Also:
Time Flies Like an Arrow



See all Topics

Sunday, October 15, 2017

Foley Sounds

Clip Clop


Here's a subject you have heard about:

A Foley Artist 'recreates' sound effects for film, television and radio productions on a Foley Stage in a Post Production Sound Studio.
Using many different kinds of shoes and lots of props - car fenders, plates, glasses, chairs, and just about anything found at the side of the road - the Foley Artist can replace original sound completely or augment existing sounds to create a richer smoother track.
Almost every motion picture and television show you have ever seen and heard contains a Foley track!


NPR presented this story:
Jack Foley: Feet to the Stars

Also:
Art of Foley

Film Sound Q&A



See all Topics

Saturday, October 14, 2017

Hardcopy Relationships

Document database


When you're documenting your database applications, you may want to include the same visual diagram of your table relationships that's available through the Relationships window.
In Access 2000 thru 2003, this is easy. Simply display the Relationships window as usual and then choose File>Print Relationships from the menu bar. Doing so displays a report preview that you can then print or save.

In 2007-13, to just print out a report, find Database tools on the Ribbon and click on Database Documenter.

Relationships are at the bottom of the All Object Types tab





See all Topics

Friday, October 13, 2017

Life with PowerPoint

Cruel tips


" Don McMillan is "Technically Funny". Before he became a nationally known stand-up comedian, Don spent 10 years as an engineer at IBM, AT&T, and VLSI Technology. He knows what corporate life is all about. His show is funny, smart, clean, AND he is the ONLY comedian working in PowerPoint.


Life After Death by PowerPoint



Don McMillan



See all Topics

Thursday, October 12, 2017

Specifications for Excel 2007-2016

More flexibility


Lots of limits have been changed with 2007. The size of a worksheet is now 1,048,576 rows by 16,384 columns. The number of undo levels has gone up to 100.

Here are some more changes:

  • Worksheet and workbook specifications and limits

  • Calculation specifications and limits

  • Charting specifications and limits

  • PivotTable and PivotChart report specifications and limits

  • Shared workbook specifications and limits

Excel 2007-2016 Specifications



See all Topics

Wednesday, October 11, 2017

Piggyback on Gmail

An added tool


Google's Gmail is free and offers some features you can use in conjunction with your email program.


  • Send email to Gmail

  • Forwarding

  • Gmail spam control

  • Centralized Email

  • Additional email storage
"As well as a backup, it means you can easily access your messages via Internet terminal or mobile phone. Gmail is easily searched online or indexed offline using Google Desktop Search."
Here's a YouTube:
Gmail as your spam filter

Here's GMail's Fetch gadget:
How to set up Mail Fetcher



See all Topics

Tuesday, October 10, 2017

Use the Ruler

Measure by Measure


Here is an article that explores the use of Word's Rulers.

About the only thing I don't see is that you can bring up the Page Setup dialog box by double clicking in the dark area of the ruler that indicates the margin.

Once again this tip comes from the Microsoft Word MVP site:

Ruler of all you survey:
How to make the best use of Word's rulers

Here's the spot to click to show rulers in Word 2007-13:





See all Topics

Monday, October 09, 2017

Clippy and Friends

Office Assistants


They were in the background, waiting to pounce.

Chris Pratley was there in the beginning:
Clippy and User Experiences


Stanford University:
Bob and the assistants
Social science research influences computer product design
..."They have found that to a very considerable extent people treat their computers and other computer-driven technology in the same ways that they treat people - as if the computer possessed reason, feelings, etc. People also treat pictures on screens as real objects, rather than as representations of real objects. This is relevant to anyone who wants to design technology or content that is as effective as it can be ..."


Also see:
Microsoft Bob
Clippy's Revenge



See all Topics

Sunday, October 08, 2017

Undo Excel

Level talk


In Excel 2007+. the number of levels of the "undo stack" was increased from 16 levels to 100.

Setting AutoFilters, showing/hiding detail in PivotTables, and grouping/ungrouping in PivotTables are now reversible.

And the undo stack is not cleared when Excel saves, be it an AutoSave or a Save by the user.

If you think the number of undos should be changed, here's how:


  1. Close any programs that are running.

  2. Click Start, click Run, type regedit in the Open box, and then click OK.

  3. In Registry Editor, expand one of the following registry subkeys, as appropriate for the version of Excel that you are running:

    Microsoft Office Excel 2010
    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options

    Microsoft Office Excel 2007 uses Office\12.0\
    Microsoft Office Excel 2003 uses Office\11.0\
    Microsoft Excel 2002 uses Office\10.0\
    Microsoft Excel 2000 uses Office\9.0\


  4. On the Edit menu, point to New, and then click DWORD Value. Select New Value #1, type UndoHistory, and then press ENTER.

  5. On the Edit menu, click Modify.

  6. In the Edit DWORD Value dialog box, click Decimal under Base. Type a value between 0 and 100 in the Value box, click OK, and then exit Registry Editor.

  7. Start Excel. Excel stores an undo history for the number of actions that you specified in step 6.


Modify the number of undo levels
 

If you want to clear the undo stack, just run a macro such as:


Sub ClearUndo()
Range("A1").Copy Range("A1")
End Sub

Allen Wyatt:
Clearing the Undo stack



See all Topics

Saturday, October 07, 2017

Leaf Automation

Animation tip


This tutorial will walk you through the steps you can use to display a leaf as it floats and swirls across the screen.

There is also a file that you can download to see how its done.

PowerPoint Heaven:

Leaf Motion



See all Topics

Friday, October 06, 2017

Startup Switches for Access

Your choice


"This article shows you how to customize the way that Microsoft Office Access 2007+ starts by adding switches and parameters to the startup command. For example, you can have Office Access 2007+ open a specific file or run a specific macro when it starts."


Office.Microsoft.com

Also:

Support.Microsoft.com

and

VB123.com



See all Topics

Thursday, October 05, 2017

Screen Capture Gear

Better than PrtScn


You can add graphics to instructions using the built in PrtScn button, but there's not much versatility.

WritersUA by WinWriters, Inc has a discussion on some available apps that can help.



"Almost all of us need to include screen captures in our user assistance from time to time.

Of course, it's possible to do almost all of this by pressing + to copy the active window to the clipboard, and then pasting it into your favorite image-editing application.
However, for each screen capture this requires you to go through the same set of actions in order to crop, set the color depth, add borders or edge effects, and finally save it.
If you only take the occasional screen capture, then this is fine. But it can become extremely tedious and time-consuming if you have a large number of screens to capture."


Capture Tools



See all Topics

Wednesday, October 04, 2017

Non Stop Show

Stop the breakout


If a PowerPoint show is running, it can be stopped by using the escape key. Here's a way to prevent that from happening.

A User can exit out of a show accidentally/intentionally by pressing the ESC key. This add-in disables the functionality of the ESC key.

Note: If the show is set to run in Kiosk mode, disabling the ESC key will provide no way of getting out of a slide show, hence please ensure that you have provided an escape route (e.g an invisible shape set to End show) to exit the show.


No ESCape Add-in
by Shyam Pillai



See all Topics

Tuesday, October 03, 2017

Continued

More to come



You can place the word "More" or "Continued" at the bottom of every page except the last one.
The field, for those of you who know how to use them is:

{ IF { PAGE } = { NUMPAGES } "" "more" }

You can't just type in the brackets, you must use Insert>Field or Ctrl+F9.

Here is a more sophisticated formula:

{ IF { PAGE } < { NUMPAGES } "Continued on page {={PAGE} + 1}" "Last Page"}

Also see the Word MVP site:

How to control the page numbering in a Word document



See all Topics

Monday, October 02, 2017

Cmabrigde

Crorcet Sllipneg



"Aoccdrnig to a rscheearch at Cmabrigde Uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht the frist and lsat ltteer be at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae the huamn mnid deos not raed ervey lteter by istlef, but the wrod as a wlohe."


Spanish:
"Sgeun un etsduio de una uivenrsdiad ignlsea, no ipmotra el odren en el que las ltears etsan ersciats, la uicna csoa ipormtnate es que la pmrirea y la utlima ltera esten ecsritas en la psiocion cocrrtea. El rsteo peuden estar ttaolmntee mal y aun pordas lerelo sin pobrleams. Etso es pquore no lemeos cada ltera por si msima preo la paalbra es un tdoo."

Russian:



See: Matt Davis - Cmabrigde, for a full discussion.

True or fsale?

TheSpellingBlog



See all Topics

Sunday, October 01, 2017

Use a Table Alias

to change names in a query


When you need to change the table name referenced in an existing Access query, it can be a pain. This is especially true if the query contains a large number of fields.

You typically might use an alias when you need to relate a table to itself or tables have long or unwieldy names.

If you make a practice of always using aliases in your queries, you can easily change which table is used by changing the one occurrence of the original table name in the query's FROM clause.
  1. To set a table alias in the query's Design view,
  2. Right-click on the table field list and choose Properties.
  3. Then, enter the alias name you want to use in the Alias text box.





See all Topics

Saturday, September 30, 2017

Google Shows

Presentation alternative


Google Docs now has a presentation element.

You can create documents, spreadsheets and presentations online.

They're a bit restricted and simplex at this point, but you can also import files and convert them for sharing or publication.

Google Docs

Review of Google presentation



See all Topics

Friday, September 29, 2017

And then there was Word

Remember the past



As one writer put it:
"Before the development of personal computers and word processing software, documents were produced on typewriters."

Chris Pratley, a Microsoft Program Manager, started with the Excel team in 1994 and then worked with the Word team. He has written about the early days:
Let's talk about Word


Also see:
WordStar Resource Site
(Includes a WordStar emulator for Word)


And:
In Search of Stupidity



See all Topics

Thursday, September 28, 2017

How to Start a Blog

Step-by-step tutorials

"If you’re like most people, you may not know where to get started. Starting a blog can be intimidating if you don’t have the required technological skills. Not to mention that the number of options available for starting a blog can be just plain confusing. The good news is that the free step-by-step guide on this site removes any confusion from the process, and requires only the most basic computer skills. So whether you’re 8 or 88, you can have your blog ready to go in less than 20 minutes."

Theblogstarter.com

See all Topics



See all Topics

Wednesday, September 27, 2017

Horrific Stories

What did your Grandparents do?


"Unsuspecting visitors in crime-infested Port Townsend, victims of shanghaiing, are sold to the highest bidder
Bunco Kelly, Spider Johnson and fourteen dead men on the deck of the Flying Price.
Urban East Hicks surrounded by Indians in 1886.
Earthquakes, riots, robberies, murders and a host of other terrifying events which created panic in the streets of communities throughout the Pacific Northwest.
Selected from the Clippings File of the Tacoma Public Library's Northwest Room /Special Collections, these true-life tales chillingly capture the dark side of our state's history."

Unsettling Events!



See all Topics

Tuesday, September 26, 2017

IE Spells

Missing feature found



For years, I've filled out forms on the net and then had to copy and paste into Word to check doubtful spelling.

Now there is a tool that should have been included in the first place.

"ieSpell is a free Internet Explorer browser extension that spell checks text input boxes on a webpage. It should come in particularly handy for users who do a lot of web-based text entry (e.g. web mails, forums, blogs, diaries).

Even if your web application already includes spell checking functionality, you might still want to install this utility because it is definitely much faster than a server-side solution. Plus you get to store and use your personal word list across all your applications, instead of maintaining separate ones on each application."


ieSpell



See all Topics

Monday, September 25, 2017

Access Tutorials

Learning Sites



Microsoft has created a web site for Office. Part of the site is devoted to tutorials touching on:

Word, Access, Publisher , Outlook, PowerPoint, InfoPath , Excel, Visio, OneNote, Expression, and Project.

The Access lessons are located here:

2013 Access Tutorials

Here's another site:

FunctionX Access tutorials




See all Topics

Sunday, September 24, 2017

Put IE Back on the Desktop

Regedit ahead


  1. Click Start, Run.

  2. Type "regedit.exe" (Without quotes).

  3. Navigate to the following registry key
    HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel

  4. In the right hand pane, double-click {871C5380-42A0-1069-A2EA-08002B30309D} key.

  5. Enter dword value as 0 to enable the Internet Explorer icon on the Desktop.





Internet Explorer Desktop icon missing



See all Topics

Saturday, September 23, 2017

Wrist Time

Ding dong bling


Face it, you're never going to wear these watches. Some of them are just concepts, others are just too.

They are fun to look at.


Wrist Fashion is a Weblog that publishes the latest news, trends and products from the Wristwatch Industry in bite size morsels.


Brand: Venexx
Movement: Swiss Ronda Calibre 1063.1.90 quartz movement
Perfume: Approximately 60 sprays
Water Resistant: 30 metres


Perfume Watch

WristFashion.com



See all Topics

Friday, September 22, 2017

Flag Access Controls

Tag Property


The TAG property allows you to associate up to 2,084 characters of text with any form, report, section, or control. This is especially helpful when you want to single out a specific subset of controls.

For instance, say that you want to hide certain controls on a form when a user clicks a button.
You can flag which controls will be hidden by entering the word "Hide" (or any other consistent word) in each control's Tag property. Then, attach the following code to the command button's Click event procedure:

Dim ctl As Control
For Each ctl In Me.Controls
If ctl.Tag = "Hide" Then
ctl.Visible = False
End If
Next





See all Topics

Thursday, September 21, 2017

Convert Anything

Four pecks to a bushel



Convert
"Convert is an easy to use unit conversion program that will convert the most popular units of distance, temperature, volume, time, speed, mass, power, density, pressure, energy and many others, including the ability to create custom conversions!"

Convert



OnlineConversion.com does more conversions online.
(A Hogshead is 63 Gallons)


Also:
Convert between bits/bytes/kilobits/kilobytes/megabits/megabytes/gigabits/gigabytes



See all Topics

Wednesday, September 20, 2017

Vidler Video Storage

Player and free video storage

"You can upload many videos at once, and in various formats, too.(mov .avi .wmv .mpeg).

You also won't have to worry about file size - just keep any video you upload under 500 Mb.

Timed Tags
Moments on the timeline of your video are taggable, so you can classify and share instances in time. Timed tags are searchable, too - a great way to explore the content on viddler.com

Timed Comments
Your position in the timeline of a video determines where your comment will be posted to, which brings the discussion to a whole new level!

Use Your Webcam
Got a web camera? You can use Viddler to record footage directly from the camera to the website. There's no third-party software



"Viddler is very different from other video-delivery based websites, because we stream our videos instead of having the user download it.

That means you get to watch videos without having to wait for the entire video to load.

This is especially useful when you want to view the last few minutes of a very long video.

It's a secure system and prevents other people from watching the video (in ways they're not supposed to) or ripping the video off the site.

Video that you host with Viddler cannot be stolen, or used in any fashion, unless you set your sharing options to allow it."


Vidler.com



See all Topics

Tuesday, September 19, 2017

Great Collection

Examples and ideas


The experts show you how they have developed some pretty spectacular animations and designs using PowerPoint out of the box.


"PowerPoint Heaven is a website providing PowerPoint showcase, artworks, PowerPoint games, animation templates, PowerPoint animations and tutorials on animating Microsoft PowerPoint."


PPTHeaven.mvps.org



See all Topics