Hyperlinks on a form

[Rita]

Hi,

I have a form that is bound to a table within my database. One of the
fields(called Table_Name) in the form contains the names of some of the
tables held within the database. On double-clicking the table name
within the form, this should cause the table to be opened in datasheet
view. I know this can be achieved by turning the text data type to a
hyperlink data type.

The problem I'm experiencing is somewhat different as the table names
within the form do not correlate to the names of the table in the
database (don't ask why, it will take too long to explain, and, no they
cannot be changed!!). For example, within the form and it's underlying
table, we could have for the table name "APPLE" whereas within the
database it would be called "APPLE_PIE". So, when the table name APPLE
is double-clicked within the form, I concatenate _PIE to form
APPLE_PIE.

Does anyone know if the followhyperlink method can be used to open the
table APPLE_PIE and how it can be achieved using VBA?

Thanks

Rita

 

[Rick Brandt]

Hi,

I have a form that is bound to a table within my database. One of the
fields(called Table_Name) in the form contains the names of some of the
tables held within the database. On double-clicking the table name
within the form, this should cause the table to be opened in datasheet
view. I know this can be achieved by turning the text data type to a
hyperlink data type.

The problem I'm experiencing is somewhat different as the table names
within the form do not correlate to the names of the table in the
database (don't ask why, it will take too long to explain, and, no they
cannot be changed!!). For example, within the form and it's underlying
table, we could have for the table name "APPLE" whereas within the
database it would be called "APPLE_PIE". So, when the table name APPLE
is double-clicked within the form, I concatenate _PIE to form
APPLE_PIE.

Does anyone know if the followhyperlink method can be used to open the
table APPLE_PIE and how it can be achieved using VBA?

The Hyperlink is one of the more useless features added to Access. Just use
Text fields ands the OpenTable method.

 

[Rita]

The Hyperlink is one of the more useless features added to Access. Just use
Text fields ands the OpenTable method.

Rick,

Many thanks for the tip. It's working now.

Rita