 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 2005Can I copy a form to another form if they are basically the same?
If I want to set up two forms that have basically the same information is there a way to copy one to set up the other without recreating a whole new form? In the database window, select the form; hit Ctrl-C and then Ctrl-V, providing a new name for the second form. Then open it in design view and modify the Record Source property. OK, that's how to do it, but why do you want to do this? You could change the record source at runtime, or use filters/where clauses to filter what's displayed to the user.  SignatureJoan Wild Microsoft Access MVP > If I want to set up two forms that have basically the same > information is there a way to copy one to set up the other without > recreating a whole new form? That helps! But honestly, I don't know what you mean. I am so new to Access and I am using two different books to help me along as I build this database and it is kicking my rear! Every time I think I have it down I go to repeat a step and can't remember what I did the last time. It is going to be a very basic database to keep track of hard copy files and their locations (Contracts, reference materials, etc.) I have just never done this before. Sincerely, UGH Tammy > In the database window, select the form; hit Ctrl-C and then Ctrl-V, > providing a new name for the second form. Then open it in design view and [quoted text clipped - 7 lines] > > information is there a way to copy one to set up the other without > > recreating a whole new form? You may find that one of the templates at http://office.microsoft.com/en-us/templates/CT011366831033.aspx will suit what you need. Any of the collections databases (music, book, video). SignatureJoan Wild Microsoft Access MVP > That helps! But honestly, I don't know what you mean. I am so new > to Access and I am using two different books to help me along as I [quoted text clipped - 21 lines] >>> information is there a way to copy one to set up the other without >>> recreating a whole new form? Ms Wild, I am little unsure of how to make the template "my own" so to speak. Any helpful suggestions? Should I just transfer the tables and data from the one I started to the template or totally recreate the names and data in the template to match what I need it to say? I really appreciate your help!!! > In the database window, select the form; hit Ctrl-C and then Ctrl-V, > providing a new name for the second form. Then open it in design view and [quoted text clipped - 7 lines] > > information is there a way to copy one to set up the other without > > recreating a whole new form? I was thinking that you'd start with the template, and modify the names it uses. Only if the template will give you what you want. Otherwise, why don't you post what you have in your mdb i.e. names of the tables; how they're related. SignatureJoan Wild Microsoft Access MVP > Ms Wild, I am little unsure of how to make the template "my own" so > to speak. Any helpful suggestions? Should I just transfer the tables [quoted text clipped - 17 lines] >>> information is there a way to copy one to set up the other without >>> recreating a whole new form? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.