R
ReferenceMan
Well, there are several ways to open another database
from the currently opened.
If you need to open it as a current database you can use
the SendKeys command:
Dim strFileName as string
strFileName = "C:\SomeNewDatabase.mdb"
SendKeys "{F11}%FO" & strFileName & "{enter}"
If you need to open it as a new instance of the Access,
you can use the Shell Command:
dim strAccessPlusFileLocation as string
strAccessPlusFileLocation = "C:\Program Files\Microsoft
Office\OFFICE11\msaccess.exe C:\SomeNewDatabase.mdb"
X = Shell("C:\Program Files\Microsoft Office\OFFICE11
\msaccess.exe C:\SomeNewDatabase.mdb")
Note: your msaccess.exe and somenewdatabase location may
be different from the one on the example.
You can also try this:
Dim accApp As New Access.Application
accApp.OpenCurrentDatabase ("C:\SomeNewDatabase.mdb")
accApp.Visible = True
But it did not worked for me.
Hope, it helps.
ReferenceMan
can be harmful to your computer and data...". Both the
originating database and the database that I'm trying to
open have been digitally signed by a trusted source.)
than the hyperlink approach?
from the currently opened.
If you need to open it as a current database you can use
the SendKeys command:
Dim strFileName as string
strFileName = "C:\SomeNewDatabase.mdb"
SendKeys "{F11}%FO" & strFileName & "{enter}"
If you need to open it as a new instance of the Access,
you can use the Shell Command:
dim strAccessPlusFileLocation as string
strAccessPlusFileLocation = "C:\Program Files\Microsoft
Office\OFFICE11\msaccess.exe C:\SomeNewDatabase.mdb"
X = Shell("C:\Program Files\Microsoft Office\OFFICE11
\msaccess.exe C:\SomeNewDatabase.mdb")
Note: your msaccess.exe and somenewdatabase location may
be different from the one on the example.
You can also try this:
Dim accApp As New Access.Application
accApp.OpenCurrentDatabase ("C:\SomeNewDatabase.mdb")
accApp.Visible = True
But it did not worked for me.
Hope, it helps.
ReferenceMan
that opens another database. The message is "Hyperlinks-----Original Message-----
Does anyone know how to get rid of or work around the hyperlink error message?
(The message displays whenever I click on a hyperlink
can be harmful to your computer and data...". Both the
originating database and the database that I'm trying to
open have been digitally signed by a trusted source.)
database to open another database -- is there a way otherI am going crazy trying to solve this. I need the
than the hyperlink approach?