Help!!! Hyperlinks making me crazy

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

-----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
that opens another database. The message is "Hyperlinks
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.)
I am going crazy trying to solve this. I need the
database to open another database -- is there a way other
than the hyperlink approach?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top