ok here is my problem. I have 2 databases and I have a form that is going to be used for personal inventory file. they will select from one or both databases and put it into a third database how about do i do this? Any Suggestions?
Thanks
Printable View
ok here is my problem. I have 2 databases and I have a form that is going to be used for personal inventory file. they will select from one or both databases and put it into a third database how about do i do this? Any Suggestions?
Thanks
You can open multiple databases in your program.
how?
If you've got 3 databases, you can use 3 data controls.
so there is no way except for putting 3 data conntrols in there to access those databases as one
Here is an example of opening two databases using DAOBoth gdbRWTS and gdbRWTU are dimensioned as Public Database.Code:'Open the databases
gsRWTSPath = App.Path + "\data\rwts.mdb"
gsRWTUPath = App.Path + "\data\rwtu.mdb"
Set gdbRWTS = Workspaces(0).OpenDatabase(gsRWTSPath)
Set gdbRWTU = Workspaces(0).OpenDatabase(gsRWTUPath)
------------------
Marty