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

From: lance (here_at_there.com)
Date: 05/14/04

  • Next message: YYZ: "Re: setting hyperlink value in DAO 3.51 using an update query" 
    Date: Fri, 14 May 2004 15:35:18 -0500

    when the query is executed using this string, the link works fine (word
    wrap!):

    UPDATE Points SET Points.TypeOfPoint = "DGPS",Points.JobNumber =
    204444400,Points.SurveyTech = "Billy Bob",Points.PartyChief = "Rajin
    Thibadeaux",Points.ClientName = "Yo Mommas Investment Company",Points.County
    = "Harris", Points.ProjectDatum = "NAD27", Points.ProjectProjection = "TX
    South Central Zone", Points.FIPS = 4204, Points.UTM_Zone = 15,
    Points.TypeofJob = "As-Built Pipeline",Points.ProjectUnits = "US-Ft",
    Points.Hyperlink = "c:\id.jpg#c:\id.jpg", Points.Date = #02/23/2004# WHERE
    Points.ID_In_Project = 1;

    but not when the query uses this string:

    UPDATE Points SET Points.Hyperlink = "c:\id.jpg#c:\id.jpg" WHERE
    Points.ID_In_Project = 1;

    again, it's just the link that isn't passed.

    lance

    "lance" <here@there.com> wrote in message
    news:uHnNd6eOEHA.2468@TK2MSFTNGP11.phx.gbl...
    > the query runs fine from within access just as it is, though. it's when
    > applied from VB that the link isn't registered.
    >
    > lance
    >
    > "Jeff Johnson [MVP: VB]" <i.get@enough.spam> wrote in message
    > news:eRGVXUeOEHA.2920@tk2msftngp13.phx.gbl...
    > >
    > > "lance" <here@there.com> wrote in message
    > > news:eNUWpPeOEHA.3348@TK2MSFTNGP09.phx.gbl...
    > >
    > > > but the value after the "#" sign isn't being set as the link. am i
    > > missing
    > > > something?
    > >
    > > You might be better off asking in an Access group.
    > >
    > >
    >
    >

  • Next message: YYZ: "Re: setting hyperlink value in DAO 3.51 using an update query"

    Relevant Pages

    • Re: Problems with Delete Command
      ... The SQL could get fairly messy if you need to construct it in code, ... ContactID, and WebComID, and create your on-the-fly SQL on that saved query, ... to find the list of ContactIDs from the junction table, ... This is a style/readability thing: if you are going to use string ...
      (microsoft.public.access.tablesdbdesign)
    • Re: Need help with Code Please!!!
      ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
      (microsoft.public.access.formscoding)
    • Re: Need help with Code Please!!!
      ... putting the query SQL itself in here maybe it will help you understand what I ... the actual string that gets built at the end of the SQ1 build process. ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ... Dim qd As QueryDef 'object ref to query item ...
      (microsoft.public.access.formscoding)
    • Re: Need help with Code Please!!!
      ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
      (microsoft.public.access.formscoding)
    • Re: Error using " in .open with ADODB.Recordset
      ... recordset but I'm getting hung up on the SQL statement. ... query that has a string as a condition. ... Dim mrk As String ...
      (microsoft.public.data.ado)
    Loading