Hyperlink address property

[KimTong via AccessMonster.com]

Hi,

Can we use Hyperlink address property on Label Form to run the table (e.g:
Table1) in my current database?. If anybody can help me, I am very
appriciated.


KT

 

[jahoobob via AccessMonster.com]

Are you asking if you can place a hyperlink on a form that will open a table
in your db. The answer to that is yes. When you place the hyperlink on the
form you will have a chance to designate objects in the current db.

 

[KimTong via AccessMonster.com]

I saw on Access Help, they have feature to run Excel file like:

HyperlinkAddress Hyperlink SubAddress Description
C:\Finance\First Quarter.xls Sheet1!TotalSales in the Microsoft
Excel spreadsheet "First

Quarter.xls" on range named 'TotalSales'

But I don't how run table in current Acces files


KT

 

[jahoobob via AccessMonster.com]

Maybe I don't understand what you mean by run table. A table can be opened
or queried but not run. My post explained how to place a hyperlink on a form
to a table that when selected will open that table.

I saw on Access Help, they have feature to run Excel file like:

HyperlinkAddress Hyperlink SubAddress Description
C:\Finance\First Quarter.xls Sheet1!TotalSales in the Microsoft
Excel spreadsheet "First

Quarter.xls" on range named 'TotalSales'

But I don't how run table in current Acces files

KT

Hi,

[quoted text clipped - 3 lines]

KT

 

[KimTong via AccessMonster.com]

Yes, I mean: placing a hyperlink on form to open the table/query. Your prev
answer didn't explain more detail how to do it, even you sadi they have
designated to do it.

Thank you, anyway.

KF

Maybe I don't understand what you mean by run table. A table can be opened
or queried but not run. My post explained how to place a hyperlink on a form
to a table that when selected will open that table.

I saw on Access Help, they have feature to run Excel file like:

[quoted text clipped - 13 lines]

 

[jahoobob via AccessMonster.com]

With the form opened in design view, select the Insert Hyperlink icon on the
Form Design toolbar. When you slect it you will be givien a chance to locate
that to which wish to link. You will see a list of choices under Link to:,
one of which is Object in this database. Slect that one then select the +
beside Tables adn the select the table you want from the list.
Hope this helps

Yes, I mean: placing a hyperlink on form to open the table/query. Your prev
answer didn't explain more detail how to do it, even you sadi they have
designated to do it.

Thank you, anyway.

KF

Maybe I don't understand what you mean by run table. A table can be opened
or queried but not run. My post explained how to place a hyperlink on a form

[quoted text clipped - 5 lines]

 

[KimTong via AccessMonster.com]

It's work. Thank you very much...

KT

With the form opened in design view, select the Insert Hyperlink icon on the
Form Design toolbar. When you slect it you will be givien a chance to locate
that to which wish to link. You will see a list of choices under Link to:,
one of which is Object in this database. Slect that one then select the +
beside Tables adn the select the table you want from the list.
Hope this helps

Yes, I mean: placing a hyperlink on form to open the table/query. Your prev
answer didn't explain more detail how to do it, even you sadi they have

[quoted text clipped - 9 lines]

 

[jahoobob via AccessMonster.com]

You are welcome. It is nice when someone lets us know when something works.
It also tells someone who does a search on the same issue that it does the
job.

It's work. Thank you very much...

KT

With the form opened in design view, select the Insert Hyperlink icon on the
Form Design toolbar. When you slect it you will be givien a chance to locate

[quoted text clipped - 8 lines]