473,386 Members | 1,673 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Copy & Paste ACCESS Report Design

Simple question - I need several Reports which are all very similar to each other. I have designed the first Report. Now I want to know how I can copy & paste the first Report so that I can generate several other identical Reports. Then I plan to perform some minimal chages to the copied Report design. Do I copy/paste the Report itself, or do I copy/paste the Report design?
Jul 18 '11 #1
3 5923
ADezii
8,834 Expert 8TB
The following Code will produce 10 Copies of a Report named Employees, and the Copies will be named Employees_1 thru Employees_10. Adjust to specific Object Type and/or nomenclature.
Expand|Select|Wrap|Line Numbers
  1. Dim bytRptCtr As Byte
  2.  
  3. For bytRptCtr = 1 To 10
  4.   DoCmd.CopyObject , "Employees_" & CStr(bytRptCtr), acReport, "Employees"
  5. Next
Jul 18 '11 #2
Rabbit
12,516 Expert Mod 8TB
Similar in what way? You may not need 10 copies of the report.
Jul 19 '11 #3
Mihail
759 512MB
SAVE AS your report with different name (At design time). Make necessary changes in the new report.
Jul 19 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Nelgonde | last post by:
Apologies for the basic nature of this question but I'm very inexperienced in Java. I've been given the task of disabling the cut/copy/paste functions (Ctrl-X,C & V) in our java dialogs and...
2
by: Tim Hochberg | last post by:
During the recent, massive, painful Lisp-Python crossposting thread the evils of Python's whitespace based indentation were once again brought to light. Since Python' syntax is so incredibly...
1
by: Phil Stanton | last post by:
Can anybody help please Has anybody got any VBA routines to copy controls on a REPORT (Not a form) to the clipboard. There are somewhat complicated ones for copying RTF and images, but I would...
0
by: James | last post by:
Does annybody know how to disable clipboard copy and paste events in a Rich TextBox control. Thanks
6
by: NuB | last post by:
I have a winform and a menu on the form, It allows the users to copy and paste text from text boxes. I never had to do this before, how can I copy and paste text from one box to another?
0
by: Mr. Murad Jamal | last post by:
hi guys, I have a textbox & a button in an .aspx page, when I hit the button i want a selected text to be copied to the clipboard AND paste it into the last cursor position on the textbox BOTH AT...
6
by: rakeshvthu | last post by:
hi all, can we disable the copy and paste option in edit menu bar of browser my customer does not want copying using any technique so can any one help how to disable that options copy and...
0
by: kavi2012 | last post by:
Hi I used the following function to disable the cut, Copy & paste in the Textbox. It works fine for me when I use ctrl+C,ctrl+X & ctrl+V. function disable(e) { if(event.ctrlKey) { ...
5
by: Mon Ange | last post by:
Hi everyone, Although I do have some experience with Access I encounter a problem, which I could not solve yet. All search on the net did not bring up any result either, so I hope that someone in...
5
by: deve8ore | last post by:
Hello, I have a Word document called (), a named range that will open up a new Word doc dependent on what a user selects in Excel. Could someone please guide me on how to set up VBA code to...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.