Importing forms and queries from another ACCESS db 1

[jpl458]

I have an Access application and I want to take a form and use it as the main form in a new application. Problem is the form has several other forms behind it, all which have queries, etc. Is there a way to move them all at once instead of moving each part on it's own, like with the VB editor. I know how to import and export, but a lot of queries have evolved and it will be a pain the neck to get all the parts moved if I have to select them from the import screen. (Don't remember what all the queries are named.

I shudda planned this better.

Thanks in advance

jpl

 

[PHV]

To know what you have to transfert you may have a look here:

http://mdbdoc.sourceforge.net/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jpl458]

Very cool, will download and get familiar. I thought of another way of creating the MDB without trying to figure out all that has to move. Make a copy of the big application and delete everything that's not needed in the big one. Sort of like sculpting, chip away everything that doesn't look like "The Thinker".

Thanks for the tip - looks to be a valuable tool. Just thought - will it work with linked tables? Seems like it would. Will find out anyway.

Thanks again.

jpl