Hyperlink shown as a date field - how to do this ?

[Alu_GK]

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.

 

[Fred]

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.

 

[Alu_GK]

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

 

[Fred]

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.

 

[Alu_GK]

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]

Hello -
The Solution works.
Thank you very much.

 

[Alu_GK]

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