• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1292
  • Last Modified:

How can I make a copy of a form with Access 2010

In Access 2003 I could go to forms in database window and copy a form and paste with another name to make a backup, before I started changing the first form.
In Access 2010 I  dont seem to be able to do that.
Is there a way?
0
Fritz Paul
Asked:
Fritz Paul
1 Solution
 
Fritz PaulAuthor Commented:
OK I found it. I think.
I copy the form and then click on "File" and select "Save object as".
Seems like a step backwards to me.
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
You can also open a form/report in design view then do a save as
0
 
Jeffrey CoachmanMIS LiasonCommented:
Or you can do this in VBA:

Docmd.CopyObject

From the VBA help Files:
Syntax:
expression.CopyObject(DestinationDatabase, NewName, SourceObjectType, SourceObjectName)

See the VBA Help files for more info and a sample code snippet.

;-)

JeffCoachman
0
 
Helen FeddemaCommented:
Or you can install my Extras Plus add-in, which works with Access 2010 (as well as earlier versions), and allows you to make copies of database objects with incrementing numbers (among other features).  It can be downloaded from this link:

http://www.helenfeddema.com/Files/code20.zip

Here is a screen shot of the Access 2010 QAT with the Add-ins menu:
Copying-an-Object.bmp
0
 
Fritz PaulAuthor Commented:
This works almost as good as Access 2003, where you can left click copy right click paste.
But this is easy enough.
Thanks for the other accurate tips.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now