Fw: Access, Postgresql, and hyperlinks

----- Original Message -----
From: "Adam Lang" <aalang(at)rutgersinsurance(dot)com>
To: <pgsql-interfaces(at)pgsql(dot)org>
Sent: Monday, October 09, 2000 11:57 AM
Subject: Access, Postgresql, and hyperlinks

> I am curious if anyone can try this. Required is Postgres via ODBC on a
> windows box and Access 2000 (which I don't have).
>
> Apparently Access added a property to text fields named IsHyperlink. Can
> someone see if it works? (Have a text field in postgres that is a
> hyperlink, link an Access 2000 front end to it and have a text field
display
> data and set the IsHyperlink property to true and see if you can "click"
on
> the field and it is treated like a hyperlink.)
>
> Quoted from:
> http://www.officevba.com/features/1999/09/vba199909rd_f/vba199909rd_f.asp
>
> "Because Access projects rely on SQL Server data types, they don't
directly
> support hyperlinks. You can type hyperlinks into a table in the same
format
> as a traditional Access database, but the fields don't behave as if they
> contain hyperlinks. Unlike Jet, SQL Server doesn't have a hyperlink data
> type. Microsoft offers a workaround by introducing an IsHyperlink property
> for text boxes and combo boxes on a form in an Access project. With this
> property set to True, a form control interprets hyperlink address
> specifications as hyperlinks. The IsHyperlink property is available with
> both the new .adp file and the traditional .mdb file. As with other
> properties mentioned in this article, you can set the IsHyperlink property
> manually at design time, or programmatically at run time. A form control
> with its IsHyperlink property set to True shows the display text for the
> hyperlink, and clicking its contents updates the view with the hyperlink's
> target address."
>
> I really would appreciate it. If this is inappropriate to the list, I
> apologize.
>
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
>
>