Here's our Microsoft Office Tip for.. November 6, 2000
Click Here to see a complete list of all of our previously released Tips!
Have you ever wanted to create a similar database object while writing a new database app? Its come up here from time to time. You can copy an object without using the Edit menu's Copy and Paste commands; and then simply select the object you want to copy and hold down the Ctrl key while you drag that object to the end of the object list and then release it. Access will create a duplicate and name it "Copy of filename."
For example, if you want to copy a report named MyReport, you'd select it, hold down the Ctrl key, and drag MyReport to the end of the report list. Access would then display a new report named "Copy of MyReport" in your report list. You can then rename the object and make the simple modifications you need to create the similar, but different report. Its a lot easier than recreating the whole report from scratch.