By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,097 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

One Query, One Form, about 15 databases

ChaseCox
100+
P: 294
How can I take a form I made that used one query, one database, and transport it to use about 15 databases, and a different query, but with the same info in the query and tables? Thanks!!!
Dec 19 '06 #1
Share this Question
Share on Google+
3 Replies


ChaseCox
100+
P: 294
How can I take a form I made that used one query, one database, and transport it to use about 15 databases, and a different query, but with the same info in the query and tables? Thanks!!!

I still need some help with this. Thanks!!!
Dec 20 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
How can I take a form I made that used one query, one database, and transport it to use about 15 databases, and a different query, but with the same info in the query and tables? Thanks!!!
Chase I'm not sure what you mean about 'use' 15 databases. If you just mean you want to use this form in each of them then export the form to the database and in the new database in form design view change the Record Source property of the form to the new query.

Just remember if any of the fieldnames are different, missing, etc. you will have a problem.

Mary
Dec 21 '06 #3

Expert 5K+
P: 8,434
Chase I'm not sure what you mean about 'use' 15 databases. If you just mean you want to use this form in each of them then export the form to the database and in the new database in form design view change the Record Source property of the form to the new query.

Just remember if any of the fieldnames are different, missing, etc. you will have a problem.
You might also want to attach the tables from the fifteen different databases to a "front end" database, then use a UNION query there to pull them together. You might not, too. :) There are performance issues involved.
Dec 22 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.