Topics
Content Types
About 624 results
-
Copy hundreds of rows of Excel formulas in three steps
Copying formulas in Excel is a relatively simple operation - unless you need to copy down through dozens or even hundreds of cells. Here's a foolproof little trick that will knock ...
-
Use the Access Office Links tool to convert a report to an Excel worksheet
Here's a quick and easy trick for getting your Access report data into Excel - organized just the way you want.
-
Add sounds to your Access form events
Your forms don't have to be silent and boring -- Access lets you play a sound for any form event. Here's a quick look at how you can set up Access to play a sound each time a user ...
-
Prevent Excel from turning fractions into dates
Left to its own devices, Excel will convert your fractions into dates as soon as you enter them in your spreadsheet. See how you can work around this problem.
-
Automatically fill in Access text boxes based on a combo box selection
You can greatly enhance a form by having Access supply information based on the user's selection. Here's an example that will fill in an employee's first name and phone number when...
-
Move text to the next column permanently
Word may not be a full-featured layout program, but it does offer some tools that let you control the position of text on the page. See how to use a column setting to get that text...
-
Clear an Access combo box for entering the next record
You can have Access clear the selection from a combo box in a data entry form so that the user starts fresh with each new record. See how to make this user-friendly tweak.
-
Add data to an Excel worksheet from a Word table
If you have a workbook containing data that originates in Word, you can keep the data current with the help of Excel's Import External Data wizard. Here's a look at how to put this...
-
Spot invalid imported data with the help of a custom Excel function
Any time you have to manually review worksheet data looking for errors, something is going to slip through. Here's one handy safety net: a user-defined function that will flag one ...
-
Include parameter values in your Access report titles
You can create more informative titles for reports that are based on parameter queries. This simple technique will enable you to include the parameters in your report titles and he...