Ability to use w Multiple Db - Microsoft Access AI Builder


	Back to Access AI Builder Comments List

Upload Images Link Email

Ability to use w Multiple Db

Sandra Truax

10 months ago

I just spent about 20+ hours on modifing your code so that it would work when form & code is copied to my other databases, and I woke up this morning with the realization that when you come out with an update, all my work is down the drain. I say that to ask... Could you possibly make it so that a database could be selected using a combo box and it populate the Tables, etc. using that database?

	Sandra Truax OP 10 months ago
Okay, would this work? If I used your code in my other databases to udate the FormListT and the QueryListT, then copy those two tables to your database, and remove the code from your database that updates those two tables, that would work, right?

	Alex Hedley 10 months ago
Would work better as an Access AddIn (.accda) That way it could access any db you open.

	Sandra Truax OP 10 months ago
Thanks Alex, but you are talking way over my head. I'll see if I can do some research and figure out how. Thanks for pointing me in the right direction.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access AI Builder.