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

A

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

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

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
 
F

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

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 !
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top