Getting the Hyperlink Field Property

[Guest]

I have a field that has a datatype of HYPERLINK. For each value in that
field, the Text and Address is different. For example, the text might say
"Microsoft", but the address is "http://www.microsoft.com".

I'd like to make sure that all the address urls are unique, but I can't
figure out the easieist way (or any way) to access the address property of
the hyperlink field without doing it one-by-one.

I would greatly appreciate any suggestions.

Thanks.

 

[Allen Browne]

Use HyperlinkPart().

1. Create a query using this table.

2. Depress the Total button on the toolbar (upper Sigma icon.)
Access adds a Total row to the grid.

3. Type this into a fresh column in the Field row:
HyperlinkPart([MyField], 2)
replacing MyField with the name of your hyperlink field.
Accept Group By in the Total row.
In the Criteria row, enter:
<> ""

4. Drag your primary key field into the grid.
In the Total row under this field, choose Count.
In the Criteria row, enter:

1

5. (Optional.) Drag the hyperlink field into the Grid.
In the Total row, choose First.
This will let you see the display text for one of the matches.

 

[Guest]

Thanks, Allen. I really appreciate the help. It was exactly what I needed.

- Doug

Use HyperlinkPart().

1. Create a query using this table.

2. Depress the Total button on the toolbar (upper Sigma icon.)
Access adds a Total row to the grid.

3. Type this into a fresh column in the Field row:
HyperlinkPart([MyField], 2)
replacing MyField with the name of your hyperlink field.
Accept Group By in the Total row.
In the Criteria row, enter:
<> ""

4. Drag your primary key field into the grid.
In the Total row under this field, choose Count.
In the Criteria row, enter:

1

5. (Optional.) Drag the hyperlink field into the Grid.
In the Total row, choose First.
This will let you see the display text for one of the matches.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a field that has a datatype of HYPERLINK. For each value in that
field, the Text and Address is different. For example, the text might say
"Microsoft", but the address is "http://www.microsoft.com".

I'd like to make sure that all the address urls are unique, but I can't
figure out the easieist way (or any way) to access the address property of
the hyperlink field without doing it one-by-one.

I would greatly appreciate any suggestions.

Thanks.