If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Code to open a DB
All
I've a form with four command buttons. Selecting the first button allows the user to use the current DB. However, clicking any of the other three buttons should close the current DB and open up a new DB, e.g. DB_2.mdb, DB_3.mdb etc... Preferable the user should not notice the current DB has closed. I cannot use the same DB s there are chinese walls issues and the data needs to be ring-fenced at all times. Regards Chris |
#2
|
|||
|
|||
On 25 Aug 2005 06:51:57 -0700, AFKAFB wrote:
All I've a form with four command buttons. Selecting the first button allows the user to use the current DB. However, clicking any of the other three buttons should close the current DB and open up a new DB, e.g. DB_2.mdb, DB_3.mdb etc... Preferable the user should not notice the current DB has closed. I cannot use the same DB s there are chinese walls issues and the data needs to be ring-fenced at all times. Regards Chris Application.FollowHyperlink "c:\FolderName\Db2.mdb" DoCmd.Close acForm, Me.Name -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
All forms open when viewing form code | Jeff Oppenheim via AccessMonster.com | Using Forms | 2 | June 20th, 2005 08:02 PM |
Make Change Case in Excel a format rather than formula | Kevin | Worksheet Functions | 1 | March 18th, 2005 08:53 PM |
Ms-Access 2003 | RC | General Discussion | 23 | January 19th, 2005 08:22 PM |
Power Point Pack and Go | scott | Powerpoint | 17 | October 4th, 2004 05:57 AM |
Dbl Click Code - open a form | JohnLute | Using Forms | 12 | June 17th, 2004 03:10 PM |