Question hyperlink to a record in the same table

[naixixi]

Hi all,

I have a question. Hope that some one can help me with it.

Is there a way that I can use hyper link in a cell to another record in the same table? this can be easily done in excel hyper link. I have attached the screen shot for both excel and access.

Thank you very much!

Warmest regards,

Naixixi

 

[Minty]

No - you can't perform any coding within a table, you should be using a form to manipulate / search your data. Access is not a spreadsheet.

On a form you can easily link from one record to another.

 

[Ranman256]

you dont hyperlink in Access, you just open it using the key.

if a query, docmd.openquery "qsMyQuery", where the query opens using key as critieria
qsMyQuery = select * from table where [key]=123

if a form, open the form using the key
docmd.openform "fMyForm",,,"[key]=123"

 

[naixixi]

No - you can't perform any coding within a table, you should be using a form to manipulate / search your data. Access is not a spreadsheet.

On a form you can easily link from one record to another.

Thank you very much for your reply. How to link from one record to another on a form? Can it function like a hyperlink? Thank you!

 

[naixixi]

you dont hyperlink in Access, you just open it using the key.

if a query, docmd.openquery "qsMyQuery", where the query opens using key as critieria
qsMyQuery = select * from table where [key]=123

if a form, open the form using the key
docmd.openform "fMyForm",,,"[key]=123"

Thank you very much for your reply. Can I use docmd.openform as something like a hyperlink that I click on, then it will direct me to a record?
Thanks a lot!

 

[Minty]

If you have a form with a list of records on it you can make any field look like a hyperlink (Blue Font Underlined) and simply add a double click event to it.
The event can then open another form, go to a related record on the same form, put the cat out etc etc

 

[naixixi]

If you have a form with a list of records on it you can make any field look like a hyperlink (Blue Font Underlined) and simply add a double click event to it.
The event can then open another form, go to a related record on the same form, put the cat out etc etc

Thank you! That sounds like what I want. Can I view all the records in the form in a table format instead of viewing one record at a time? Thanks a lot!

 

[Minty]

Yes use a continuous form - it can be made to look just like a datasheet, or (much more limiting) use datasheet view.

 

[naixixi]

Yes use a continuous form - it can be made to look just like a datasheet, or (much more limiting) use datasheet view.

Thank you very much Minty. In datasheet view, can I add double click event to a single record so that when double click, another record will be open? And can I add another double click event to another cell in the same field so that a different record will be open when I double click?
I don't want one field has the same event, but the field for each record has different event. Is that feasible? I want to link record to record. For example, A,B,C are three records in the same table, A is calculated from B and C. I want to add two "hyperlink" in record A that link to B and C, add one "hyperlink" each to record B and C that link to A.

Thanks a lot!

 

[Minty]

Access wouldn't know that A was calculated from B. To be honest it sounds like your data isn't normalised - as that type of calculation should not be stored.
Can you post up your data structure - table names, fields and what they are storing ?

 

[naixixi]

Access wouldn't know that A was calculated from B. To be honest it sounds like your data isn't normalised - as that type of calculation should not be stored.
Can you post up your data structure - table names, fields and what they are storing ?

Hi Minty,

Yes, my data is not normalized. I will need to manually set the rules for every hyperlink, but there is not many. I just want to know if I can add different link in different record and majority of the record do not have link?

Thanks very much.

 

[Minty]

Without seeing some real sample data I don't know how you would be best to approach this, you are trying to force a Access table to behave like a spreadsheet, which it isn't.

Post up some real data examples, with exactly what you are trying to achieve in plain English - don't get all database or spreadsheet speak on us

 

[naixixi]

Without seeing some real sample data I don't know how you would be best to approach this, you are trying to force a Access table to behave like a spreadsheet, which it isn't.

Post up some real data examples, with exactly what you are trying to achieve in plain English - don't get all database or spreadsheet speak on us

Sure. I have attached two screenshots, one is datasheet view and the other is continuous view. There are three records here, loss ratio, premium and loss, and three fields, element name, description and elements. Elements lists the elements that are related. Loss ratio is calculated from premium and loss. Therefore, the element for loss ratio has premium. I want to have a hyperlink that when I press premium in the loss ratio record, it will direct me to the premium record. If I press the loss ratio in the element field of premium record, it will link to the loss ratio record, with ID 2. If I press the loss ratio in the element field of loss record, it will link to the loss ratio record as well.

Hope I have made myself clear. Thanks a lot.

 

[naixixi]

Do let me know whether you feel this can be done in Access or not.

 

[Minty]

I'm afraid it's not making complete sense to me. Can you describe what you are trying to achieve with your actual data. This looks to me to simply be background calculation information rather than actual data. If it is then I don't think you are approaching this in the correct fashion.

Maybe an example of the actual data and results you currently have in a spreadsheet?

 

[naixixi]

I'm afraid it's not making complete sense to me. Can you describe what you are trying to achieve with your actual data. This looks to me to simply be background calculation information rather than actual data. If it is then I don't think you are approaching this in the correct fashion.

Maybe an example of the actual data and results you currently have in a spreadsheet?

This is the actual data that need to be used. It is not used for calculation, but for documentation. Everything is in text. I just want to add the hyperlink I described before, but not any calculation. Very simple.

 

[Minty]

Okay - Can you take a step back as it's not clear what your objective is here. Please describe in simple terms what you are trying to do with the database you are building.
At the moment all I can see is a table with three fields that don't seem to have any final outcome or use.

What purpose do they serve in the wider scheme of things?