A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

copying access objects from file to file.



 
 
Thread Tools Display Modes
  #1  
Old August 24th, 2005, 04:36 PM
Chris
external usenet poster
 
Posts: n/a
Default 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  
Old August 24th, 2005, 05:57 PM
Eric Blitzer
external usenet poster
 
Posts: n/a
Default

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  
Old August 24th, 2005, 05:59 PM
Klatuu
external usenet poster
 
Posts: n/a
Default

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  
Old August 24th, 2005, 06:36 PM
Chris
external usenet poster
 
Posts: n/a
Default

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  
Old August 24th, 2005, 06:51 PM
Klatuu
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 04:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.