Can't Follow the Hyperlink Warning Message

[CiceroINFJ]

I have a very simple database (no VB code) and the following problem:

I have a Form1 which has a label control on it whose hyperlink property is
filled out and points to a macro in the same database (Object In This
Databse). The macro opens a Form2. As you may have guessed, my Form1 has a
number of hyperlinks like this one and the user can click on any hyperlink
he/she chooses to open other forms/reports. I did this so that I would not
have to use a whole bunch of buttons. Besides, a hyperlink can describe the
contents of the form or report the user is about to open; the buttons on the
other hand must be relatively big if I want to type us a lot of text in them.
Using a laundry list of text labels with a whole bunch of "Open" buttons was
an option I considered in the past as well and did not like.

Here is the problem. When I click on the hyperlink, the underlying macro
gets executed and the Form2 opens just fine, with one additional nuisance -
Access 2007 throws a warning stating that such and such Access file Can't
Follow the Hyperlink macro name such and such. It does though... Access 2007
executes the macro called on by the hyperlink no problem. Why the message?

I tried several tactics to get rid of the stupid warning and I don't seem to
be able to find a solution for it. I tried the trust center; my location is
"trusted". My macro security level is low (set to Enable All Macros). I can't
think of anything else I can do to get rid of the warning.

Is there any way I can get rid of this silly annoyance? This wasn't the case
in Access 2003 (this file was built in Access 2003; I am not ready to convert
it to 2007 yet as people at work do not have Access 2007 yet).

Thanks for your help.

 

[Pete D.]

See SetWarnings off but make sure you turn the back on afterwards. Also dig
into what may be causing the error, might be hyperlink format isn't just
right but windows figures it out after raising the error code.