Solved

customize reports

Posted on 2013-12-28
4
247 Views
Last Modified: 2013-12-30
Is there a way to create your own customized report template?
0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 12

Expert Comment

by:pdebaets
ID: 39744203
Do you mean create a report layout in design view, only without any fields, then save it. Then copy it to a new name when you want to create a new report?
0
 

Author Comment

by:Connie Campbell-Pearson
ID: 39744227
I have always used the wizard and then had to change everything. I did experiment with a design as you said. I was wondering about customizing my own theme. Is that possible?
0
 
LVL 11

Expert Comment

by:Gregory Miller
ID: 39744229
You can define a single report as the Access default when you create a new report. This is not selectable at the time you want to create a new report however.
 
The only other way is to create a report and save it as a report and then copy and paste it into your project. It will immediately ask you to name it. This is how I do it anyway. I would be interested in finding a simpler way.
0
 
LVL 38

Accepted Solution

by:
PatHartman earned 500 total points
ID: 39745308
Yes.  Once you create the template, you tell Access to use it by setting the FormTemplate and ReportTemplate properties under the Object Designers section of Access Options in A2007 and A2010.  You can also do it with earlier versions but you probably get to the setting though Tools/Options.

What you can define with the templates is limited.  Here is what the help entry says:
When you create a form or report without using a wizard, Microsoft Access uses a template to define the default characteristics of the form or report.

The template determines which sections a form or report will have and defines each section's dimensions. The template also contains all the default property settings for the form or report and its sections and controls. However, a template doesn't create controls on a new form or report.

The default templates for forms and reports are called Normal. However, you can use any existing form or report as a template. You can also create a form or report to use only as a template. Changing the template doesn't have any effect on existing forms or reports.

Microsoft Access saves the settings for the Form Template and Report Template options in your Microsoft Access workgroup information file, not in your Microsoft Access database (the .mdb file) or Microsoft Access project (the .adp file). When you change an option setting, the change applies to any Access database or Access project you open or create.

If your templates are not in an Access database or Access project, Microsoft Access uses the Normal template for any new forms and reports you create. However, the names of your templates appear in the Form Template and Report Template options in every Access database or Access project in your database system, even if the templates are not in every Access database or Access project.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question