Message-ID: <002401c0376f$27e39e20$330a0a0a@6014cwpza006>
From: "Adam Lang" <aalang@rutgersinsurance.com>
To: <pgsql-interfaces@postgresql.org>
Subject: Fw: Access, Postgresql, and hyperlinks
Date: Mon, 16 Oct 2000 08:46:51 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


----- Original Message -----
From: "Adam Lang" <aalang@rutgersinsurance.com>
To: <pgsql-interfaces@pgsql.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
>
>