While Access 2003 and 2002 include a wizard for importing data from an Excel file into an Access table, you may want to create a command button that will perform all of the steps of the wizard for you. Mary Ann Richardson shows you what do to if you have to perform that function periodically.
It can be frustrating the numbered list in your Word document keeps starting at the wrong number — even if you select Restart Numbering from the shortcut menu. Rather than try to renumber, try this tip from Mary Ann Richardson.
You paste a table from Excel into your Word document and notice that half of it is cut off at the margin. Where did it go? The real problem is there is too much content to fit across the page — Mary Ann Richardson shows you how to fix it.
Save time from creating an Access report with tables and forms by simply converting your form to a report and then printing the report. Follow these steps from Mary Ann Richardson to convert an Access 2003/2002 form to a report for printing.
You realize that your Word document will fit in a smaller-sized sheet and doesn’t need to take up a letter-size memo. The good news is that you don’t have to reformat your Word document — simply print to scale. Here’s how.
When you create a table that ends at the bottom margin, Word automatically inserts a new blank page. If you turn on the Show/Hide button, it reveals a paragraph mark after the table. Follow these steps to eliminate the extra page.
If you have to send the same worksheet to a number of people every week, it probably takes you quite awhile to prepare the e-mail. If you have to do this for a number of reports, it can take even longer. Follow these steps to have Excel e-mail the reports for you.
In Word 2007, you can preview a change you’d like to make to a picture, such as rounded corners or a drop shadow, before you actually apply it. Mary Ann Richardson explains how.
After creating UserForm1 for one Excel application, you realize that you’ll want to use it again — with a few modifications — in another application. You do not need to recreate the form; simply export the code to a file that you can import later to the new application. Mary Ann Richardson explains how.
Access allows you to prevent users from inadvertently changing data on their forms. Here’s how to set the control properties called Enable and Locked to prevent data entry.