D
dawnecia
I have a main database which I use like a switchboard to
open objects in other databases. I can open all but one
database using this switchboard. In database1
(switchboard) there is a button (cmd1) that when clicked
should open database2 (created by another user). The
database opens I log in, after logging in the database
closes. The code behind it is as follow
private sub cmd1_click()
Dim objACC As New Access.Application
Set objACC = GetObject
("C:\databases\database2.mdb") 'database to be opened
objACC.DoCmd.RunMacro ("mcrOpenEntryForm") 'marco to
run
End Sub
This is the same code I use to open other databases except
the path and the macro name is different in each case.
I've checked everything I can think of including the
macro, to make sure I am not quitting the database; I've
put a breakpoint in the code and stepped through it as it
ran and I've checked the database properties.
Any suggestions?
Thanks
open objects in other databases. I can open all but one
database using this switchboard. In database1
(switchboard) there is a button (cmd1) that when clicked
should open database2 (created by another user). The
database opens I log in, after logging in the database
closes. The code behind it is as follow
private sub cmd1_click()
Dim objACC As New Access.Application
Set objACC = GetObject
("C:\databases\database2.mdb") 'database to be opened
objACC.DoCmd.RunMacro ("mcrOpenEntryForm") 'marco to
run
End Sub
This is the same code I use to open other databases except
the path and the macro name is different in each case.
I've checked everything I can think of including the
macro, to make sure I am not quitting the database; I've
put a breakpoint in the code and stepped through it as it
ran and I've checked the database properties.
Any suggestions?
Thanks