Whether you design forms or reports, you will most likely need to make the same modification to more than one control at a time. Fortunately, you don’t have to modify each one separately. Here are some tricks for using multiple control selection in Access.
If you’ve ever added a logo or product image to an Access form, you know that an embedded form object can take up a lot of space in your database. Learn how to use an image’s Linked property to display a picture on your form without consuming too much space.
Isn’t it frustrating to do a task manually in Microsoft Excel when you know there must be a faster and easier method for accomplishing your goal? One Excel feature that will save you time is Autofill, which can generate a series of dates for your worksheets.
Are you tired of manually entering a time and date formula into each of your Microsoft Excel worksheets? Then learn how to shave time off your Excel work by creating a named Date/Time stamp formula.
If you often work on lengthy Microsoft Word documents that contain tables that are the same format, do you usually grumble when you have to reset the format? Learn how to ease your frustrations by setting your desired format as the default for all tables.
If users need to access data that is not on their forms, you could add a subform; or, you can add a command button that, when clicked, will pop open the form that contains the necessary data. Find out how to create a pop-up form in this Access tip.
If your Microsoft Access reports’ fields are being cut off at the right margin, you can resize the field control; however, this may print some of your data on a second page. Learn how to reduce the size of your margins so the last column of data stays on one page.
Are you tired of spending time navigating to the last Microsoft Word document you worked on? Then check out this timesaving tip that shows you how to create a desktop shortcut that will allow you to access your document with the click of a mouse.
Once you get the format of your Word document just right, you don’t want users (or colleagues) messing things up in any way. Learn how you can lock all formatting options in your Word 2003 documents so reviewers can enter comments without altering the format.
Once you create a fantastic looking chart in Microsoft Excel, you may decide that you want to reformat some existing charts to look just like it. Find out how to copy a chart’s format to another chart in five simple steps.
Although Microsoft Word’s features are often quite useful, sometimes you may find that a feature is superfluous to your task at hand. For instance, if you want to disable Word’s automatic capitalization feature in AutoCorrect, this tip will show you how.
Don’t you find that Microsoft Access’ Report formats based on forms or single-column lists are usually inadequate when you want to create an employee or client directory? Then check out this tip to learn how to create a multicolumn report of directory listings.