"Hyperlink, coverage on a table design" (2 Viewers)

[vhung]

Hello AWF!
Let me share my little exploration on a "Table Hyperlink"

I design a simple split form where source table has field named Hyperlink,
as I go through, I've found out that this field has the access inside/outside MS Access
though sometimes need to execute macro/converted code,

example: i need to open Linked Table Manager, usually needed a command button to open it,
but in some way by using the table hyperlink field, can open it as selected from the list.

If anyone has explored it, in same or more than i did, please let me know on how it use to be,.
Constructive Comments and suggestions is highly appreciated,.

 

[June7]

Not clear to me what you are asking.
Do you want to know how the Hyperlink works to open Linked Table Manager?
The hyperlink actually triggers a macro that opens the LTM.

I tried setting up a Hyperlink field that would open Access objects and it is not working. This tutorial says it should http://allenbrowne.com/casu-09.html

 

[arnelgp]

i think it is impossible to accomplish if you are using a bare-naked table.
but if you use a Form (datasheet form, open dsTable1 form for example)
you can capture the Click event and redirect it's action.

 

[June7]

I get error 2046 "The command or action 'LinkedTableManager' isn't available now." Command works fine in another db. I think this download got corrupted because getting other weird behavior - PropertySheet insists on displaying when form in Datasheet View.

Why does Allen Browne indicate hyperlink click could open Access objects? Does not indicate VBA is needed.