Microsoft Access Tutorials
January 27, 2006, 11:52 pmMicrosoft Access Tutorials:
http://mis.commerce.ubc.ca/courses/comm391/tutorials.html
Calculating Fields in Access:
http://mis.commerce.ubc.ca/courses/comm391/calcfields.html
Filters and Queries (S.Hui):
http://mis.commerce.ubc.ca/courses/comm391/tutorials/access1/access1.htm
Excel to Access Tutorial:
http://mis.commerce.ubc.ca/courses/comm391/tutorials/presentation/excel_to_access.htm
MS Access Whitepaper:
http://mis.commerce.ubc.ca/courses/comm391/tutorials/download/dbback.pdf
Notes on Relationships:
http://mis.commerce.ubc.ca/courses/comm391/tutorials/download/relations.html
Excel 2003 Tutorials and Free Video Training
January 25, 2006, 10:56 pmExcel 2003 Tutorials:
1. Introduction. Excel Elements2. Starting to work with Excel
3. Operations with files
4. Formulas and Functions
5. Manipulating cells
6. Cell formats
7. Structure changes
8. Insert and eliminate elements
9. Spelling correction
10. Printing
Free Excel Video Training Tutorials
1. Basic Excel2003 environment
2. Introduce and modify text
3. Save a workbook
3. Close a workbook
3. Create a new workbook
3. Open a workbook
4. Insert functions
5. Selecting rows, cells, and columns
5. Copy cells
5. Copy cells with the mouse
5. Special paste
5. Move cells
5. Delete cells
6. Change the font
6. Align the contents of cells
6. Borders
6. Colouring cells
6. Cell formatting
7. Row height
7. Hide rows
7. Column width
7. Hide columns
7. Change the name of a sheet
8. Insert rows
8. Insert columns
8. Insert sheets
8. Copy and move a worksheet
8. Eliminate elements
9. Autocorrect spelling
9. Spelling correction
10. Page setup
10. Print
"How to Use" Outlook Tutorials from Outlook-tips.net
January 24, 2006, 9:45 pm"How to Use" Outlook Tutorials from Outlook-tips.net
- Outlook 2003's Junk E-mail
- Outlook's Icons
- Backup Master Categories
- Countdown to a Specific Date
- List Upcoming Birthdays
- Missing Holidays
- Creating Custom Views
- Copy Custom Views
- Disable Group Views
- Use Custom View Data
- Create Rules for a Domain
- Create a New Profile
- Create a Profile (*.PRF)
- Delete Ghost PSTs
- Newsgroups in Outlook?
- Changing the Office CD Key
- Delete a Stuck Message
- Delete Read Receipts
- Replace MSNBC Outl Today
- Edit Outlook Today
- Use Custom Forms
- Publishing Custom Forms
- Use Command Lines
- Display Maps
- Read as Plain Text
- Use Mail Merge
- Minimize to Tray
- Add MS Mail Support
- Recover Deleted Items
- WinXP Unread Mail Count
- Send Link by Email
- View Message Source
- View Internet Headers
How to Tutorials and Articles for Office 2003
January 23, 2006, 3:29 pmHow to Tutorials and Articles for Office 2003
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
| ||
|
The PowerPoint FAQ - Part 2
January 20, 2006, 9:08 pmThe PowerPoint FAQ - Best Powerpoint Help and Tutorial Site
Programming PowerPoint
MacFAQs
Stupid PPT-TRIX
Troubleshooting
PROGRAMMING POWERPOINT
These code samples come from various authors and are here for purposes of illustration. We can't (and don't) guarantee that they'll work on all systems, or that they are free of harmful side effects. It's your responsibility to verify the appropriateness and safety of any code you find here.
We don't offer tech support for the code here. If you have any problems or questions, please post a detailed description on the PowerPoint newsgroup. Whether the author chooses to respond is entirely up to them.
VBA code only works in PowerPoint 97 or later. It doesn't work at all in the free PowerPoint Viewer.
For VBeginners
- How do I use VBA code in PowerPoint?
- Will VBA solve my presentation problem?
- Where can I learn more about VBA programming in PowerPoint?
- VBA in PowerPoint / Mac vs. Windows
Creating and Installing Add-ins, Toolbars, Buttons
- How can I get my code to run automatically when a presentation opens?
- Create an ADD-IN with TOOLBARS that run macros
- Put icons on toolbar buttons
- Make PPT respond to events
- PowerPoint Event Handling Oddities
- Add an addin via the registry
- Working with toolbar buttons
- Problems adding add-ins
- Is VBA available?
Show Me
- Show me the built in properties and their values
- Get a reference to a placeholder on a slide
- Show Me: The hyperlinks in my presentation
- What add-ins are loaded?
- Show me the .Type of each object on a slide
- Show the .Type of each shape (including shapes in groups)
- Show me the transition time of each slide and total running time of the show
- Determine which shape was clicked
- The names of all main menu commands
- The SlideIndex of the current slide
- How many lines in the text box?
- Make links and action settings visible
Exporting stuff
- General-purpose routine for writing a string to a text file
- Export Slide Number and Title Text to a text file
- Export Text to a text file (Mac or PC)
- Export the notes text of a presentation
- Export the PowerPoint presentation outline to a tabbed text file
- Export the names and coordinates and type of all shapes
- Export slides as graphics
- Export Shapes as graphics
- Put an image on the clipboard to use as a custom toolbar icon
Adding stuff
- Insert all slides from a group of presentations into the current presentation
- Add a random phrase from a text file to a text box on each slide
- Add new slides with titles and text from a text file
- Add a "thermometer" progress bar to each slide
- Insert a picture at the correct size
- Batch Insert a folder full of pictures, one per slide
- Add the current path and file to every slide
- Read in text from an ascii file?
- Add a text box with scrollbars; populate it with text
- Insert a symbol or other character at the insert cursor position
- Add shape with text to "flag" hidden vs unhidden slides
- How many slides can a presentation hold?
- Toggle a design grid on and off
Deleting stuff
- Delete embedded sounds
- Delete shapes with no fill and no line
- Delete notes page text (or text and shapes)
- How do I GET RID OF MACROS I've added?
- Ungroup all the OLE objects in a presentation
- Remove all text shadows
Changing stuff
- Reapply the Notes Master to each Notes Page in a presentation
- Change OLE links
- Convert PowerPoint tables to HTML
- Convert all OLE objects to grouped MSDraw objects
- Changing shapes within groups (without ungrouping)
- Create "proper" fractions
- Edit the name of a shape
- Change the font color of text
- Show me the link and let me edit it
- Working with pictures on slides
- Create agenda slides with a "moving highlight"
- Convert PowerPoint 2002/2003 comments into PowerPoint 2000 comments
- Make subscripts and superscripts larger
- Bringing certain shapes on top of others in your slides
- Changing underline style
Printing
Batch Tricks
- Do something to -- every shape on a slide, every slide in a presentation, every presentation in a folder
- Batch: Do something to every file in a folder
- Batch re-save presentations
Animations and Transitions
- Use VBA to make text appear and disappear
- Use VBA to create popup text
- Apply a random transition to every slide in a presentation
- Where can I find information about animation in PowerPoint 2002 (XP) and 2003?
Working with Excel
- Exel-lent Excel Sites
- Excel code to modify Excel chart palette colors
- Excel Charts to PowerPoint and other goodies
Automating one app from another
- General info on Office Automation
- Automate Excel from PowerPoint. Automate PowerPoint from Excel. And so on.
- Automating the Viewer
- How to automate PowerPoint using VB
- Invoke PPT and run a macro from VB
- Server Office Automation Issues
- ShellExecute Example
Working with MSGraph charts
- Automate MSGraph
- Programmatically add an MSGraph chart as a user-defined custom graph type
- Extract data from MS Graph Chart
Other
- Using Tags
- Ungroup and ReGroup all pictures and OLE objects
- Reset the size of the slide images on notes pages to a single standard size
- Convert slide titles to shapes to solve hyperlink limit problems
- Hide and Unhide Slide Titles
- How do I distinguish the special page number characters on masters?
- Keep Score with Static Variables
- Recolor or hide "key" text in a presentation
- Convert key text into underscore characters (ie, make them into Fill In The Blanks)
- Use ShellExecute to sidestep certain linking problems
- Put your macro to Sleep
- Use DIR to get a list of files
- Manipulating Listbox and Combobox controls on slides
- Randomize the order of a PowerPoint presentation
- Go there, Come back
- Call a macro in another presentation and pass it parameters
- Substitute one string for another in text
- Fill the MRU (Most Recently Used) list with bogus file names
- Single macro that can manipulate any shape that's clicked in slide show view
- Slide number, SlideID, SlideIndex and all that jazz
- Hide PowerPoint while I automate it
- Macros I record in Normal/Slide view don't work in Slide Show
- Get DOCUMENT PROPERTIES without opening each file
- Get the Document Properties of a PPT file
- Determine the first CD ROM drive letter
- All about Macro Security in Office 2000
- Where can I learn about the PowerPoint FILE FORMAT
- Hyperlink .SubAddress - How to interpret it
- Where are the hyperlinks?
- PowerPoint and Viewer Object Models
- Create an index with links to a folder full of PPT files
- Convert PowerPoint's color values into grayscale
- SmartTags
Known VBA/Programming-related Bugs
- Checking for autoshape text produces text
- Message: "PowerPoint found an error it can't correct" when starting PowerPoint97 under Win2000
- Querying Picture Properties crashes PPT XP
MAC FAQS
Troubleshoot Problems, Interpret Error Messages
- Mac: General troubleshooting suggestions for Office
- Mac: QuickTime Movies don't play well in PowerPoint 2004
- PowerPoint crashes / complains about missing fonts
- Mac: Certain presentations crash PowerPoint 98 and 2001
- Avoiding "Converting Metafile" dialogs in PowerPoint Mac
- Error: "Memory was too full to draw everything..." or Red X in PowerPoint 98/2001 Mac
- Mac: How do I recover corrupt or unreadable PowerPoint presentations?
- Animations don't work in PowerPoint X after updating to Jaguar
- Presentations lose animations in Mac PowerPoint X / Windows PowerPoint 2000 and previous
- Mac: I can't import Windows Media Files into my presentation
- PowerPoint X crashes on startup
- PowerPoint Viewer for Mac keeps insisting on being reinstalled
- Mac PowerPoint prints in B/W to my color printer
- Mac: Notes no longer match slides
- Mac: Temp files eating my hard drive!
- Mac: Can't import CIL files into Clip Gallery
- Mac: MPEG movies unreliable - don't always play
- PowerPoint 98 or 2001 crashes with a 'Type 2' error when I open it
- Mac: Error 2/Crash when printing to Epson 740
- Mac: Type 2 or 3 errors after customizing toolbars in PowerPoint 2001
- Mac: When I select a font, PowerPoint uses a different font
Downloads, Contact Microsoft
- How do I send feedback and suggestions on PowerPoint for Mac?
- Mac Office/PowerPoint Downloads, Tutorials and FAQs from Microsoft
- Mac: PowerPoint Updates
- Free PowerPoint Viewers for Mac
- What happened to the Mac PowerPoint newsgroup?
How-Tos
- How do I enable Quartz Text Smoothing/anti-aliasing in PowerPoint X?
- How do I optimize Mac presentations for Windows PowerPoint?
- Mac: Use Make Movie to create a QuickTime presentation for use on Windows
- Mac: Insert a picture from file/camera/scanner and size it to fit the slide in one step
- How to create PDFs from Mac PowerPoint
- Mac: How to create a presentation for distribution on CD
- Mac: How do I customize the Office Manager?
- How does PPT Mac store graphics internally?
Other Mac PowerPoint Resources
STUPID PPT-TRIX
TROUBLESHOOTING
Troubleshooting Tips and Procedures
- General PROBLEMS and solutions
- General PC Troubleshooting
- How to select a default printer
- How to install a local printer driver
- How to set graphics hardware acceleration back
- How to start Office in Safe Mode
- How to start Windows in Safe Mode
- Using Office 2000 Installer
- Completely uninstall Office - Office Erasers / Registry Cleaners
- Using System Information to gather troubleshooting info
- Norton Anti-Virus and Office
- Find and Delete PowerPoint's PCB file
- Are you on a network?
- About User Permissions
- General information about Windows Printing
- What add-ins are loaded?
- How to disable add-ins
PowerPoint Crashes Without Error Message
- PowerPoint 2002 / XP crashes while running add-in
- PowerPoint 2002 / XP crashes when renumbering slides
- PowerPoint crashes while opening certain presentations
- PowerPoint won't start
- PowerPoint starts then immediately quits
Specific Error Messages
- Error message: Microsoft Office PowerPoint can't display clip art.
- Could not load an object because it is not available on this machine
- "\\Server\Share does not have enough free space" error when using Pack and Go
- Message re "installing Microsoft Graph" when you doubleclick a graph to edit it
- Error message: The address of this site is not valid. Check the address and try again.
- AUTOEXEC.NT The system file is not suitable for running MS-DOS and Microsoft Windows applications
- Security warning message when clicking hyperlink in PowerPoint 2003: "files might harm your computer"
- "Hidden Console of WOW VDM" error messages when installing under NT4
- "Can't Display the Template Used in This Document. Windows Installer Error 1605."
- Internet Explorer Cannot Download error message
- "Unable to read PRES0.PPZ"
- QuickTime and a XXX - decompressor are needed to see this picture
- PowerPoint Has Encountered an Error and Must Close
- "PowerPoint can't create a hyperlink to" or message about hlink.dll
- What DLL came with which software?
- CLSCentralAddInn - run-time error '5' Invalid procedure call or argument
- "Some files can contain viruses ..." message when clicking a hyperlink
- Microsoft Visual C++ Runtime Library error messages
- Files open as Read-Only after installing Windows XP SP1, Other file/path related problems
- This command is not available because the document is locked for edit
- "Server Not Found" messages after installing Office XP SP2 or Office 2000 SP3
- Warning messages about PDFMaker after installing SP2 for Office XP
- Registration wizard appears every time you start PowerPoint
- "R6025 - pure virtual function call" message when starting PowerPoint
- FretrySdmError SDM Alert error message
- MSO9.DLL error messages
- Can't edit Org Chart, Graph, Excel (error msg: "server application, source file, or item can't be found")
- PowerPoint can't open the type of file represented by [FILENAME]
- PowerPoint found an error that it can't correct
- "PowerPoint couldn't translate this file" when opening presentation in PPT97
- The file "xxx" is stored on a disc named [something cryptic]. Please insert this disc.
- Unable to launch software component to play [sound name]
- Unable to Insert a Movie from the Selected File
- Create MPEG 32 task_cmd is not successful
- Insufficient Memory message when adding an Organization Chart
- Org Chart and error messages referring to GDI
- Macro security warning when no macros are present
- "Insufficient memory to perform this operation" message when printing from Photo Editor
- "IE 3.0 or higher is required" message when accessing help via the Office Assistant
- MSO97.DLL ERRORS
- Run-time error '429': ActiveX component can't create object
- This application must be installed to run. Please run Setup ...
- Path to the Proplus.msi file (you receive a prompt for this)
- The system cannot open the device or file specified
- The Windows Installer Service could not be accessed.
- This patch package could not be opened. Verify that ...
- This presentation might contain Far East (or Asian) text and formats that PowerPoint can't display
- "An unexpected error occurred - I/O Error 0" or "An unexpected error occurred - I/O Error 6"
Graphics Problems
- Flipped images, upside-down images
- Can't crop pictures (or make them transparent)
- Graphics turn black
- Transparent areas of graphics turn black
- PNG images appear too dark or too light
- Can't make white colors become transparent in PowerPoint 2002/XP
- Clip Art/Clip Gallery/Design Gallery problems
- Problems with EMF (Enhanced Metafile) graphics
- EPS graphics don't print or don't print correctly
- Microsoft Office Picture Manager Opens Slowly
- TIFFs exported from PowerPoint won't open in other applications
Display, Screen Show & Multimedia Problems
- Can't open modify password protected presentation in Viewer
- Mysterious text appears, slides advance unexpectedly (Ghosties Ex Machina)
- Grid appears in pasted/linked Excel worksheets
- Pen doesn't work during slide show in PowerPoint 2003
- Video/Movie plays full screen when projected
- PowerPoint displays a presentation in B/W, won't show it in color
- Sounds/Movies don't play, images disappear or links break when I move or email a presentation
- Videos play correctly on computer but not on projector (black box)
- Animated text goes jagged in Screen Show
- Can't run slideshow / screen show won't start
- Solving MultiMedia problems
- PowerPoint gets the SLOWS
- PowerPoint locks up when running a presentation non-stop
- Can I play DVDs in PowerPoint?
- Problems with movies in PPT presentations
- Animations, Sounds, Movies play only once
- Animated GIFs don't animate
- AVIs don't play or don't play all the way through
- MUSHY/BLURRY GRAPHICS in PowerPoint
- Slide View is gone. I want it back!
- I don't like PPT2000's 3-pane view. I want my old view back.
- Problems with Organization Chart (OrgChart)
- Missing menu items
- Expand Slide missing
- Lines in PowerPoint 2000 tables have arrowheads
- White line appears at bottom of screen during slide show
Corrupted or unopenable PPT files
- Can't remove password in PowerPoint XP
- Recovering a corrupt presentation
- RED X instead of graphics
- NOTES text disappears
- Images that appear corrupted, image files that won't import
- HTML "Round-tripping" to repair corruption
Printing & File Saving Problems
- Gradient transparency doesn't print properly
- Can't print password protected PowerPoint files from PowerPoint 2002 (XP)
- Why are my PowerPoint files so big? What can I do about it?
- B/W printouts don't look right
- Margins are wrong, printout is off-center, I don't want any margins
- PowerPoint prints landscape slides in portrait mode (or vice versa)
- Slides don't print on notes pages
- Can't print or save from PowerPoint 2002 (XP) or 2003
- PowerPoint hangs when I save a file
- Printed presentations don't match what I see on screen
- Pictures print blue on Canon Laser Copier
- A particular slide won't print
- Pictures/Images print twice
Link & Copy/Paste Problems
- Troubleshooting Link Problems: links that break, sounds/movies that don't play, etc.
- JAGGIES in pie charts
- Excel info cut off or cropped when pasted into PowerPoint
- Making WORD TABLES look good in PowerPoint
- Problems with LINKED EXCEL CHARTS in PowerPoint
- Resizing info pasted from Excel makes text sizes go crazy
- Problems with fonts in embedded charts/spreadsheets, etc.
- Graphs don't update automatically
- Lost hyperlinks, hyperlinks link to wrong place, hyperlinks stop working
- Hyperlinks don't work after copy/paste
File Import / Export Problems
Problems with PowerPoint on the Web
- I can't save as HTML from PowerPoint 97
- Animations don't animate
- Graphics are missing, replaced with white box
Text or Font Problems
- Troubleshoot font problems
- Text shrinks or grows after saving and reopening a file
- Text disappears when I edit it
- Backspace key produces empty square box character
- PowerPoint adds space before apostrophe
- Text disappears when ungrouping WMFs or pasted drawings
Cross-Version / Cross-Platform Problems
- Page Size changes between PowerPoint 2002 and older versions
- Prevent PowerPoint XP from converting OrgCharts to XP format
Missing Features
- Where is the Carnegie Coach in the AutoContent Wizard?
- Animation, Password, Multiple Master features unavailable in PowerPoint 2002/2003
Misc. Nuisances
- Table cells are 3D
- PowerPoint icon disappears from Programs and Start lists
- Double-clicking stops working
- Function keys stop working
- Can't open attached presentations from within Outlook Express after applying Windows XP SP2
- MS PhotoEditor disappears
- Programs slow down after applying Windows XP SP1
- PowerPoint ruler shows inches instead of centimeters. Or vice versa.
- Centimeters are wrong
- There's no title master in my presentation
- Can't use my custom Blank Presentation after applying the SR-2 patch
All the FAQ and nothing but the FAQ