Search results

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.

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

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

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.

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

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!

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!

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!

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