Solved "Hyperlink, coverage on a table design"

[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.

 

[vhung]

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

Thanks with the response you made,
This is the reason why i introduce this kind of approach because i still don't know how others think about it,.
i made something with the sample made by arnelgp, please see the attach file,.

 

[vhung]

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.

Hello, Arnel see it right by using a form, not to direct with table hyperlink,.

,with Arnel sample on MsgBox("Hello Word") using vba seems very good,
i tried it using macro it also works,.

 

[June7]

Still get same issues.

MsgBox and Table1 hyperlinks work.

I tried building macro but it tells me MacroTableManager already exists but I can't see it.

Copied table into my db and built macro. Now it works - except for records 1 and 2 - no form and no VBA.

At least it confirms Allen Browne example is correct.

Brought form over and that works as well - for all records.

 

[vhung]

Still get same issues.

MsgBox and Table1 hyperlinks work.

I tried building macro but it tells me MacroTableManager already exists but I can't see it.

Copied table into my db and built macro. Now it works - except for records 1 and 2 - no form and no VBA.

At least it confirms Allen Browne example is correct.

Brought form over and that works as well - for all records.

Now i see/confirmed how useful the hyperlink is, on a table field.
Applied on a form then the use of a macro and vba is also applicable,.

only i haven't known Allen Browne, sorry,.

 

[vhung]

Microsoft Access Tips for Casual Users​

Provided by Allen Browne
Introduction to Hyperlink fields

 

[arnelgp]

Hello, Arnel i made something with your sample please see it,.

very good vhung, your macro works well.
i added 2 more records on Table1, open Table table1 and click on the link.

 

[vhung]

very good vhung, your macro works well.
i added 2 more records on Table1, open Table table1 and click on the link.

Thanks Arnel,
Hyperlink on Table be on Form and could be in Report,.

i tried all objects from FORM TABLE REPORTS MODULE and others it goes through,
the last thing i try is to close the accdb using hyperlink, it made me consumed couples of test it fails,

then again by using other way a command on CloseDb ethier on a macro or vba should be executed too,
i made it, but only it's a two way, have to close the hyperlink table/form first before the CloseDb,.

using Hyperlink to open module or converted Macro is applicable only to accdb but not to accde,.

Should i say Hyperlink is to open/connect objects not to close,.