Prev: Passthrough queries and "Select Data Source" dialogue box
Next: Crosstab - What am I doing wrong?
From: Jim08 on 16 Sep 2009 20:01
This is giving me a syntax error

Update [table4] Set
Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")

From: Gina Whipp on 16 Sep 2009 20:14
Jim08,

Looks like a missing *(*, tey the below...

Update [table4] Set
Hyperlinkpart(([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Jim08" <Jim08(a)discussions.microsoft.com> wrote in message
news:1B8B3C90-1735-4BF9-883C-F6751047F62B(a)microsoft.com...
> This is giving me a syntax error
>
> Update [table4] Set
> Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
>


From: Jim08 on 17 Sep 2009 09:16
Gina,
Thanks for the try but no go.
I did find I had commas where I should of had periods but still get a syntax
error.
Have you ever seen a hypertext field updated this way?
Thanks
Jim

"Gina Whipp" wrote:

> Jim08,
>
> Looks like a missing *(*, tey the below...
>
> Update [table4] Set
> Hyperlinkpart(([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
>
>
> --
> Gina Whipp
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "Jim08" <Jim08(a)discussions.microsoft.com> wrote in message
> news:1B8B3C90-1735-4BF9-883C-F6751047F62B(a)microsoft.com...
> > This is giving me a syntax error
> >
> > Update [table4] Set
> > Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
> >
>
>
>
From: Gina Whipp on 17 Sep 2009 09:42
Jim,

No I have never seen a hypertext field updated that way but that doesn't
mean much... I get surprised here everyday. When you get the Syntax Error
does the cursor move to a specific spot OR perhaps show you something to
indicate what is going on?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Jim08" <Jim08(a)discussions.microsoft.com> wrote in message
news:1D34857F-D059-49CE-B94D-4DCAA84B7B14(a)microsoft.com...
> Gina,
> Thanks for the try but no go.
> I did find I had commas where I should of had periods but still get a
> syntax
> error.
> Have you ever seen a hypertext field updated this way?
> Thanks
> Jim
>
> "Gina Whipp" wrote:
>
>> Jim08,
>>
>> Looks like a missing *(*, tey the below...
>>
>> Update [table4] Set
>> Hyperlinkpart(([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
>>
>>
>> --
>> Gina Whipp
>>
>> "I feel I have been denied critical, need to know, information!" -
>> Tremors
>> II
>>
>> http://www.regina-whipp.com/index_files/TipList.htm
>>
>> "Jim08" <Jim08(a)discussions.microsoft.com> wrote in message
>> news:1B8B3C90-1735-4BF9-883C-F6751047F62B(a)microsoft.com...
>> > This is giving me a syntax error
>> >
>> > Update [table4] Set
>> > Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
>> >
>>
>>
>>


From: Jim08 on 17 Sep 2009 10:17
Gina,
I get no help with the error and the cursor goes to the open paren.
Thanks
Jim

"Gina Whipp" wrote:

> Jim,
>
> No I have never seen a hypertext field updated that way but that doesn't
> mean much... I get surprised here everyday. When you get the Syntax Error
> does the cursor move to a specific spot OR perhaps show you something to
> indicate what is going on?
>
> --
> Gina Whipp
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "Jim08" <Jim08(a)discussions.microsoft.com> wrote in message
> news:1D34857F-D059-49CE-B94D-4DCAA84B7B14(a)microsoft.com...
> > Gina,
> > Thanks for the try but no go.
> > I did find I had commas where I should of had periods but still get a
> > syntax
> > error.
> > Have you ever seen a hypertext field updated this way?
> > Thanks
> > Jim
> >
> > "Gina Whipp" wrote:
> >
> >> Jim08,
> >>
> >> Looks like a missing *(*, tey the below...
> >>
> >> Update [table4] Set
> >> Hyperlinkpart(([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
> >>
> >>
> >> --
> >> Gina Whipp
> >>
> >> "I feel I have been denied critical, need to know, information!" -
> >> Tremors
> >> II
> >>
> >> http://www.regina-whipp.com/index_files/TipList.htm
> >>
> >> "Jim08" <Jim08(a)discussions.microsoft.com> wrote in message
> >> news:1B8B3C90-1735-4BF9-883C-F6751047F62B(a)microsoft.com...
> >> > This is giving me a syntax error
> >> >
> >> > Update [table4] Set
> >> > Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")
> >> >
> >>
> >>
> >>
>
>
>
 |  Next  |  Last
Pages: 1 2 3
Prev: Passthrough queries and "Select Data Source" dialogue box
Next: Crosstab - What am I doing wrong?