[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines


Home
Whats New!
Need a database?
Tips via email
Learn VBA
Questions Answered
Access Tips Index
What is MS Access

Copying Objects

 

The following tip, copying objects, is short and, for some of you, very basic, but it is one of those things that if you do not know you can waste a lot of time.

What happens if you are building a database and you would like all the forms or reports to be the same colour, with the same headings, pictures, background, formatting etc.? Well, you could build each form or report from scratch or you could build the form or report up to a particular point then use this form or report as a template for the rest of your forms or reports.

To copy a form or a report, etc.

Open the database and select ‘Forms’ or ‘Reports’ objects, then select the specific form or report, without opening it.

Then, you can either click ‘Copy’ then ‘Paste’ on the toolbar, or you can use ‘Ctrl’ and ‘C’ to copy and then ‘Ctrl’ and ‘V’ to paste.

A window will open where you will have to name your new form, report, table etc.

Give it an applicable name and then close the window by clicking on ‘OK’.

The new form or report will be created.

 

 

Do you like this tip? Subscribe to my Newsletter to receive tips via email. Click Here to subscribe.

 

www.simply-access.com (c) 2002 - 2009