If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
copying access objects from file to file.
Hi,
I have an Access 2000 ADP with many forms, modules, class modules, and reports. I have another ADP with the same. I want to put the forms( with VBA code) of one of these into the other file. A simple copy and paste should work but when I copy and paste the form into the other project and try to run the form, I get errors: network connection has been lost. I would guess this is a microsoft glitch. how can I get my forms accompanying VBA code from one access file to another without breaking it. Also the copy breaks all the original forms too. thanks Chris |
#2
|
|||
|
|||
Go to the new database and use the File/Get Exterbal Data option from the
menu. This will bring a dialog box for you to choose the database to import from. Then pick the tables/forms/queries... that you want to import. "Chris" wrote: Hi, I have an Access 2000 ADP with many forms, modules, class modules, and reports. I have another ADP with the same. I want to put the forms( with VBA code) of one of these into the other file. A simple copy and paste should work but when I copy and paste the form into the other project and try to run the form, I get errors: network connection has been lost. I would guess this is a microsoft glitch. how can I get my forms accompanying VBA code from one access file to another without breaking it. Also the copy breaks all the original forms too. thanks Chris |
#3
|
|||
|
|||
Sorry Chris, not a Microsoft glitch, it is a Chris glitch
The correct way to do this is open the mdb where you want the object to be, then Use File-Get External Data from the menu, select the mdb where the objects are. You will then be presented a dialog where you can select the objects you want to import. "Chris" wrote: Hi, I have an Access 2000 ADP with many forms, modules, class modules, and reports. I have another ADP with the same. I want to put the forms( with VBA code) of one of these into the other file. A simple copy and paste should work but when I copy and paste the form into the other project and try to run the form, I get errors: network connection has been lost. I would guess this is a microsoft glitch. how can I get my forms accompanying VBA code from one access file to another without breaking it. Also the copy breaks all the original forms too. thanks Chris |
#4
|
|||
|
|||
another Chris glitch!, what is wrong with this guy?
anywho, thanks for the responses "Klatuu" wrote: Sorry Chris, not a Microsoft glitch, it is a Chris glitch The correct way to do this is open the mdb where you want the object to be, then Use File-Get External Data from the menu, select the mdb where the objects are. You will then be presented a dialog where you can select the objects you want to import. "Chris" wrote: Hi, I have an Access 2000 ADP with many forms, modules, class modules, and reports. I have another ADP with the same. I want to put the forms( with VBA code) of one of these into the other file. A simple copy and paste should work but when I copy and paste the form into the other project and try to run the form, I get errors: network connection has been lost. I would guess this is a microsoft glitch. how can I get my forms accompanying VBA code from one access file to another without breaking it. Also the copy breaks all the original forms too. thanks Chris |
#5
|
|||
|
|||
LOL, glad I could help.
"Chris" wrote: another Chris glitch!, what is wrong with this guy? anywho, thanks for the responses "Klatuu" wrote: Sorry Chris, not a Microsoft glitch, it is a Chris glitch The correct way to do this is open the mdb where you want the object to be, then Use File-Get External Data from the menu, select the mdb where the objects are. You will then be presented a dialog where you can select the objects you want to import. "Chris" wrote: Hi, I have an Access 2000 ADP with many forms, modules, class modules, and reports. I have another ADP with the same. I want to put the forms( with VBA code) of one of these into the other file. A simple copy and paste should work but when I copy and paste the form into the other project and try to run the form, I get errors: network connection has been lost. I would guess this is a microsoft glitch. how can I get my forms accompanying VBA code from one access file to another without breaking it. Also the copy breaks all the original forms too. thanks Chris |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't make a MDE file in access 2003 but can in Access 2000 even after converting to 2K3...Please help... | Ralph Malph | General Discussion | 7 | August 14th, 2005 06:21 AM |
share a database | jwb | General Discussion | 11 | April 4th, 2005 09:14 PM |
Encrypt AccesS File? | milest | General Discussion | 2 | February 9th, 2005 07:58 PM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |
Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |