ExternalDbAutomation.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 09 Jul 2008 at 10:43pm |
The sample set consists of two mdb files, representing local and external db's respectively. Access XP version incorporates programmatic insertion of password argument for opening the external db (In earlier versions, password argument is not available for OpenCurrentDatabase method). So long as both db's are in the same folder, the local db will automatically detect the path of external db Clicking the command button captioned "Go To External Db", on switchboard form in local db, hides the local access application and results in either of the following - (a) If external db is not yet open, a new instance of access application is created, in which external db is opened and its switchboard form is displayed. (b) If external db is already open, it gets un-hidden and its switchboard form is displayed. In external db, opening of form F_Reports results in loading of all available report names (from AllReports collection) in the list box, facilitating print/preview. In external db, clicking the go-back button (or closing the switchboard form) results in hiding of external db and un-hiding of local db. Any of the following actions in local db ensures closure of external db (if still open) - (a) Click command button for closing external db. (b) Close switchboard form of local db. (c) click command button for closing local db. References - DAO 3.6
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |