Msgbox
19 Stories
Fix what the wizards miss when you upsize Access apps to SQL Server
Insight Here are some suggestions for upsizing your database applications.
Add sound to your Access form events
Techguide It takes only a few simple steps to have Access play a sound for any form event. Find out how in this article.
Tags: Microsoft Office
Correct a Word document when lists won’t renumber correctly
Techguide A few simple steps will help you make sure the numbered list in your Word document sorts the way it should.
Tags: Microsoft Office
Use Wingdings to add graphics to Access forms and reports
Techguide You can insert a symbol or picture into a form or report, but embedded graphics consume a lot of resources.
Tags: Microsoft Office, Error, Microsoft Corp., Code, MsgBox, keyboard shortcut, Graphics, vbOKOnly, Alan Wood, Insert
Quickly delete every nth row in Excel
Techguide Susan Harkins explains how to use AutoFilter to delete specific rows in a worksheet.
Tags: Microsoft Office, Row, Column, MsgBox, Microsoft Corp., OrderID, Microsoft Word Override Word, Goto, Clear, Microsoft Excel
Control where Word hyphenates a word
Techguide Follow this tip to determine where Word hyphenates your content.
Tags: Microsoft Office, Microsoft Corp., MsgBox, C, vbOKOnly, command button, Tools Menu, Microsoft Excel 2007, Microsoft Excel, Microsoft Access
Prevent duplicates when entering data into Excel
Techguide Duplicate values, when not valid entries, return erroneous summaries and totals. Here's what to do to prevent duplicates in a specific range using Excel's Validation feature.
Tags: Microsoft Office, MsgBox, Entry, Microsoft Excel 2007, Microsoft Excel, job, Microsoft Access, Microsoft Office, Microsoft Word, HTML
How to use the At and Ln indicators in Word's status bar
Techguide At and Ln are used in automating special format requirements. Here's what you need to know.
Tags: Microsoft Office, Form, Cell, Database, Microsoft VBA, File Menu, Microsoft Excel, Microsoft Access, window, spreadsheet
Clear an Access combo box for entering the next record
Techguide Have Access clear the selection from a combo box in a data entry form so that you start fresh with each new record. See how to make this user-friendly tweak.
Tags: Microsoft Office, C, keyboard shortcut, Clear, Microsoft Excel 2007, e-mail, keyboard, Microsoft Excel, Microsoft Access, Microsoft Office
Fill Word form fields with Access data
Techguide When you need to bring your Access data into a Word form, a little VBA can expedite the task. Susan Harkins walks through an example to demonstrate the process.
Tags: Microsoft Office, Table, Form, Record, Microsoft VBA, File Menu, Microsoft Excel, Microsoft Access, Microsoft Office, Microsoft Word
Add sounds to your Access form events
Techguide Access lets you play a sound for any form event. Find out how to do it in this step-by-step guide.
Tags: Microsoft Office, keyboard shortcut, shortcut menu, Mouse, Microsoft Excel, toolbar, Microsoft Access, dialog box, window, Microsoft Office
Macro keeps e-mail addresses updated
Insight Keeping your Outlook contacts updated can be a real chore, between moves, buyouts, and mergers. This handy macro automates domain name changes in multiple contacts' e-mail addresses.
How to keep others from printing an Excel worksheet
Techguide Excel does not offer a built-in feature that inhibits print requests, but you can use a macro to cancel print jobs.
Tags: Microsoft Office
Project 98 Cost and Number rollups
Insight While Microsoft Project 2002 and 2000 both allow users to have cost and number rollups, 98 does not. Since many organizations still use Project 98, consultants could be asked to find a way to make this feature work. Here's a macro that does it.
Move endnotes to the end of a Word document
Techguide After creating a Word document, you may find that the notes you so laboriously created belong at the end. Mary Ann Richardson explains how to move the endnotes where they belong.
Tags: Microsoft Office
Jump to
1 2
