What would be the best way to do this or if this is doable at all.
I have ProjectsDatabase.mdb and there is a form frmDetailedProjectInfo.
Then in one of our other departments they have a database that has Projects as well, except for this database concentrates on the Programmer side of a project – ProjectProgramming.mdb This database is relatively large in itself and each project has its own database. I can’t really re-build or change anything on the other databases, it’s out of my control. So what I want to do is instead of importing all tables/queries/forms/reports I would like to have a place on frmDetailedProjectInfo (text box) in ProjectDatabase.mdb where a user would be able to type in Project1Programming.mdb and the click a button that would bring up a certain report from that database. I know this is really not error proof because a user would be able to type in wrong ProjectProgramming name and get the wrong report.
So may be there is a better way to do this, but I’m really not worried about the user making this type of mistake for now.
I looked into inserting a hyperlink, but I would have to add a new hyperlink each time they add a new Programming database.
Any suggestions/ideas would be greatly appreciated.
Thank you.
I have ProjectsDatabase.mdb and there is a form frmDetailedProjectInfo.
Then in one of our other departments they have a database that has Projects as well, except for this database concentrates on the Programmer side of a project – ProjectProgramming.mdb This database is relatively large in itself and each project has its own database. I can’t really re-build or change anything on the other databases, it’s out of my control. So what I want to do is instead of importing all tables/queries/forms/reports I would like to have a place on frmDetailedProjectInfo (text box) in ProjectDatabase.mdb where a user would be able to type in Project1Programming.mdb and the click a button that would bring up a certain report from that database. I know this is really not error proof because a user would be able to type in wrong ProjectProgramming name and get the wrong report.
So may be there is a better way to do this, but I’m really not worried about the user making this type of mistake for now.
I looked into inserting a hyperlink, but I would have to add a new hyperlink each time they add a new Programming database.
Any suggestions/ideas would be greatly appreciated.
Thank you.
