Re: setting hyperlink value in DAO 3.51 using an update query

From: Jeff Johnson [MVP: VB] (i.get_at_enough.spam)
Date: 05/14/04 

Date: Fri, 14 May 2004 10:54:27 -0400

"lance" <here@there.com> wrote in message
news:ute0cEcOEHA.556@tk2msftngp13.phx.gbl...

> i'm trying to set the hyperlink value in an access database using DA0 3.51
> on a field who's data type is set to hyperlink (table was created in
> access2000, and converted to a previous version via the tools menu. my
> program interacts with the converted database). using an update query
like
> such....
>
> UPDATE Points SET Points.Hyperlink = "c:\id.jpg#c:\id.jpg" WHERE
> Points.ID_In_Project = 1;
>
> but the value after the "#" sign isn't being set as the link. am i
missing
> something?

What "previous version" was the database converted to and does that previous
version support the hyperlink data type?

Relevant Pages

  • Re: field for an email address
    ... I have changed the data type to text, ... change the event to SendObject. ... >> enter all the email addresses again in Outlook and send ... >> I set the field up as a hyperlink field, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Displaying database fields
    ... SELECT query you originally suggested.' ... >> For the hyperlink substitute, do I create the query in ... What data type do I ... >Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.client)
  • Re: setting hyperlink value in DAO 3.51 using an update query
    ... > program interacts with the converted database). ... version support the hyperlink data type? ...
    (microsoft.public.vb.general.discussion)
  • RE: Hyperlinks
    ... textbox, it should navigate you to the URL or file. ... Click event of that button to follow the hyperlink to the URL or file. ... I have a field of the correct data type in my ...
    (microsoft.public.access.gettingstarted)
  • Re: Update HyperlinkAddress through Update-Queries
    ... The hyperlink address is just a string. ... The data type of the column ... UPDATE queries don't display data. ...
    (microsoft.public.access.queries)
Loading