If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hyperlink shown as a date field - how to do this ?
Hello -
I Have a table that includes Date field, and Hyperlink for Document Status. I'm exporting this data to Excel (with the help of the query builder in Excel, and update the Excel from the access file everytime it opens). I want to create one field that will show the date, and will act like a hyperlink field. (e.g. Display text is the date, and hyperlink will remain linked.) Is anyone has an idea how to do it ? Thanks. -- Alu_GK |
#2
|
|||
|
|||
Hyperlink shown as a date field - how to do this ?
A little clarification of your question.....what specifically do you mean by
"Date" field? If you mean that the Access Field type is Data/time then your question fundamentally conflicts with self as such a field stores only date/time. If you just mean that the visible text of the field is a date, the hyperlink field type has three parts, one of them being the visible text and another being the normally hidden address of where it goes to and so then you can do that. |
#3
|
|||
|
|||
Hyperlink shown as a date field - how to do this ?
I have 2 fields. 1 - a Date field. 2 - a hyperlink field.
I want to create a third field, with the combination of this two cells. I need both cells to remain in their current state for the user interface, but for the report (exported file) I want them to be shown as one field. my question was if u know how to create the date value as the "display text" of the hyperlink field. I need to find a way to do this automatically, with a function or a macro that will enable me to present the hyperlink value with the date display. Hope I made my self clearer this time... :-) Thank you for your help :-) Alu -- Alu_GK "Fred" wrote: A little clarification of your question.....what specifically do you mean by "Date" field? If you mean that the Access Field type is Data/time then your question fundamentally conflicts with self as such a field stores only date/time. If you just mean that the visible text of the field is a date, the hyperlink field type has three parts, one of them being the visible text and another being the normally hidden address of where it goes to and so then you can do that. |
#4
|
|||
|
|||
Hyperlink shown as a date field - how to do this ?
I'm still confused but here are a couple notes:
If you are talking about modifying the portions of a hyperlink field programatically or with a query, I think that you can do that by just specifyin the 4 parts seperated by # signs. If you want to extract a particular portion of a hyperlink to put on a report, I don't know how to do that, although maybe the HyperLink part method / function will do that. Other people who read these know this 20 times better than me. Where I get confused is your discussion about a report. A report is printing on a piece of paper. Although it draws / displays data from the following items, it doesn't have objects like hyperlinks, "fields" or display text. And so I don't know what you mean by saying that you want to show two different items to be "shown as one field". Hope this helps a little. |
#5
|
|||
|
|||
Hyperlink shown as a date field - how to do this ?
Hey -
Thanks. I dodn't try your offer yet, but i think it can work. sorry about the confusion with the "report" - my "report" is an excel file that used by my managers as a digital media to see and work with the data (Sorting, filtering and doing things easly than in a printed doc...), that why it is a report to me. it is not a printed doc. 10x very much ! -- Alu_GK "Fred" wrote: I'm still confused but here are a couple notes: If you are talking about modifying the portions of a hyperlink field programatically or with a query, I think that you can do that by just specifyin the 4 parts seperated by # signs. If you want to extract a particular portion of a hyperlink to put on a report, I don't know how to do that, although maybe the HyperLink part method / function will do that. Other people who read these know this 20 times better than me. Where I get confused is your discussion about a report. A report is printing on a piece of paper. Although it draws / displays data from the following items, it doesn't have objects like hyperlinks, "fields" or display text. And so I don't know what you mean by saying that you want to show two different items to be "shown as one field". Hope this helps a little. |
#6
|
|||
|
|||
Hyperlink shown as a date field - how to do this ?
Hello -
The Solution works. Thank you very much. -- Alu_GK "Alu_GK" wrote: Hey - Thanks. I dodn't try your offer yet, but i think it can work. sorry about the confusion with the "report" - my "report" is an excel file that used by my managers as a digital media to see and work with the data (Sorting, filtering and doing things easly than in a printed doc...), that why it is a report to me. it is not a printed doc. 10x very much ! -- Alu_GK "Fred" wrote: I'm still confused but here are a couple notes: If you are talking about modifying the portions of a hyperlink field programatically or with a query, I think that you can do that by just specifyin the 4 parts seperated by # signs. If you want to extract a particular portion of a hyperlink to put on a report, I don't know how to do that, although maybe the HyperLink part method / function will do that. Other people who read these know this 20 times better than me. Where I get confused is your discussion about a report. A report is printing on a piece of paper. Although it draws / displays data from the following items, it doesn't have objects like hyperlinks, "fields" or display text. And so I don't know what you mean by saying that you want to show two different items to be "shown as one field". Hope this helps a little. |
#7
|
|||
|
|||
Hyperlink shown as a date field - how to do this ?
Hello -
The problem is that when i recieves it to the excel sheet (with the help of the query builder of Excel) then it is shown as a long string, with no hyperlink qualities, which mean it is just not useful to deliver to excel it that way. Do you know how can I deliver it to excel with the hyperlink qaulities that it should have. Thanks -- Alu_GK "Alu_GK" wrote: Hello - The Solution works. Thank you very much. -- Alu_GK "Alu_GK" wrote: Hey - Thanks. I dodn't try your offer yet, but i think it can work. sorry about the confusion with the "report" - my "report" is an excel file that used by my managers as a digital media to see and work with the data (Sorting, filtering and doing things easly than in a printed doc...), that why it is a report to me. it is not a printed doc. 10x very much ! -- Alu_GK "Fred" wrote: I'm still confused but here are a couple notes: If you are talking about modifying the portions of a hyperlink field programatically or with a query, I think that you can do that by just specifyin the 4 parts seperated by # signs. If you want to extract a particular portion of a hyperlink to put on a report, I don't know how to do that, although maybe the HyperLink part method / function will do that. Other people who read these know this 20 times better than me. Where I get confused is your discussion about a report. A report is printing on a piece of paper. Although it draws / displays data from the following items, it doesn't have objects like hyperlinks, "fields" or display text. And so I don't know what you mean by saying that you want to show two different items to be "shown as one field". Hope this helps a little. |
Thread Tools | |
Display Modes | |
|
|