Import Form

dtaylor

Active Member
Joined
Mar 21, 2002
Messages
379
Hello All,
How do you transfer a form and module via vba to another db?

I can do this with SQL but how do you transfer an object?

Thanks

Dan
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Do you need to do it via code?

If not, you can just right-click in the database window or go to File-Get External Data-Import, select the database, and then import the form. The form's module will be imported with the form.

If you really want to do it via code, look up the TransferDatabase method in Help.

HTH,

Russell
 
Upvote 0
Hi Russel,
Yes I know how to do this manually.......

I am breaking up one large DB (not the one we worked on last week) that is over 1 million lines. Well the file is too large to work with, so I am breaking up the db into multiple databases's (one for each of my locations - around 45 db) and would rather have the form tranferred with the main data (I have the creation of the db and the transferring of data automated and would perfer to have all automated..)

Thanks

Dan

Edit - The module I need transferred is not the form class module.
This message was edited by dtaylor on 2003-02-10 13:06
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,184
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top