Thursday, 24 May 2007

Copying Objects

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.

No comments:

Analytics and Statistic

Blog Archive