Problems with URL hyperlinks and nag screen

[John_G]

Using A2010.



Two questions:

I want to incorporate into my database context-sensitive help using HTML / website type structure. I can do that by setting the Hyperlink Address property or using the FollowHyperlink method, no problem with either of them.

The MS Access help states this about the addressing:

The HyperlinkAddress property can contain an absolute or a relative path to a target document. An absolute path is a fully qualified URL or UNC path to a document. A relative path is a path related to the base path specified in the Hyperlink Base setting in the Properties dialog box (available by clicking Database Properties on the File menu) or to the current database path.

So that I can move the help directory around, I want to use the relative path method as highlighted above in red.
The problem is that when I click the File tab, I don't see anything called "Database properties", so I can't set the base.

Where is it? Can I set that property using VBA in I open the initial form?

The second problem is that whenever I follow a hyperlink, either with a button or code, I get this infernal nag warning:



How can I make Access stop displaying that? If it can't be done, I might as well not put help in at all, my users wouldn't bother with it if they faced that all the time.

I tried adding the directory to the settings in the trust center, but it didn't work.

It doesn't have to be an HTML file, either - I set the same nag screen using a link to MS Word as well.

Is there a solution to either of these? I can get around the first one, but the nag screen is a major pain.

Thanks

John

[June7]

Was that info for Access 2003?

Database properties are found in: File > Options

Don't use FollowHyperlink. Review http://allenbrowne.com/func-GoHyperlink.html

[John_G]

June7 and Allen -

A great big thank-you for that security-warning fix. The code runs fine.

June7 - The help quote was cut-and-paste directly from the Access 2010 help. I can't find that Hyperlink Base setting anywhere. Not a major issue, though - its an easy enough workaround.

Thanks!

John

[June7]

I can't find it either.

The base could be hard-coded or can be in a table or use CurrentProject.Path method.