Prev: Passthrough queries and "Select Data Source" dialogue box
Next: Crosstab - What am I doing wrong?
From: Jim08 on 17 Sep 2009 12:00
Gina, Gina, Gina,
I am soooo sorry. You are so good and I am such a dope.
I checked the table and I had changed the field from hyperlink to text and
had not changed it back. I changed it back to hyperlink and the SQL works!
I defiantly owe you a beer.
Thank you so much
Jim




"Gina Whipp" wrote:

> Jim,
>
> Was think that was my next step... Please tell Access version, and field
> data types so mine can match yours.
>
> --
> 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:AAB48E2A-42AA-4188-A146-6AE7690AC1BE(a)microsoft.com...
> > Sorry the last paren got clipped in the copy paste
> > Hyperlinkpart([table4].[hype],0)=Replace(Hyperlinkpart([table4].[hype],0),"tempest","trinity"))
> > is what is in the SQL
> > would you consider creating a table with one field table4.hype and try it?
> > thanks
> > Jim
> >
> > "Gina Whipp" wrote:
> >
> >> Ji,
> >>
> >> You still had too few parenthesis'. Remember for every opening OR
> >> closing
> >> you MUST have one that corresponds.
> >>
> >>
> >> 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:AAFA6F2D-281A-454A-BE81-C07BF7738A5A(a)microsoft.com...
> >> >
> >> >
> >> > Hyperlinkpart([table4].[hype],0)=Replace(Hyperlinkpart([table4].[hype],0),"tempest","trinity")
> >> > Thanks so much for your time
> >> > Jim
> >> >
> >> > "Gina Whipp" wrote:
> >> >
> >> >> Jim,
> >> >>
> >> >> RE-copy/paste what you are using now...
> >> >>
> >> >> --
> >> >> 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:3A704B88-9285-4CEB-88E7-AD848B32C70B(a)microsoft.com...
> >> >> > 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")
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
From: Gina Whipp on 17 Sep 2009 14:47
Jim,

No worries... we have ALL made those kind of mistakes! Glad to know it's
working!

--
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:2743A7FD-197D-4335-945E-76C2C4B5ABA2(a)microsoft.com...
> Gina, Gina, Gina,
> I am soooo sorry. You are so good and I am such a dope.
> I checked the table and I had changed the field from hyperlink to text and
> had not changed it back. I changed it back to hyperlink and the SQL works!
> I defiantly owe you a beer.
> Thank you so much
> Jim
>
>
>
>
> "Gina Whipp" wrote:
>
>> Jim,
>>
>> Was think that was my next step... Please tell Access version, and field
>> data types so mine can match yours.
>>
>> --
>> 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:AAB48E2A-42AA-4188-A146-6AE7690AC1BE(a)microsoft.com...
>> > Sorry the last paren got clipped in the copy paste
>> > Hyperlinkpart([table4].[hype],0)=Replace(Hyperlinkpart([table4].[hype],0),"tempest","trinity"))
>> > is what is in the SQL
>> > would you consider creating a table with one field table4.hype and try
>> > it?
>> > thanks
>> > Jim
>> >
>> > "Gina Whipp" wrote:
>> >
>> >> Ji,
>> >>
>> >> You still had too few parenthesis'. Remember for every opening OR
>> >> closing
>> >> you MUST have one that corresponds.
>> >>
>> >>
>> >> 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:AAFA6F2D-281A-454A-BE81-C07BF7738A5A(a)microsoft.com...
>> >> >
>> >> >
>> >> > Hyperlinkpart([table4].[hype],0)=Replace(Hyperlinkpart([table4].[hype],0),"tempest","trinity")
>> >> > Thanks so much for your time
>> >> > Jim
>> >> >
>> >> > "Gina Whipp" wrote:
>> >> >
>> >> >> Jim,
>> >> >>
>> >> >> RE-copy/paste what you are using now...
>> >> >>
>> >> >> --
>> >> >> 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:3A704B88-9285-4CEB-88E7-AD848B32C70B(a)microsoft.com...
>> >> >> > 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")
>> >> >> >> >> >
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>


First  |  Prev  | 
Pages: 1 2 3
Prev: Passthrough queries and "Select Data Source" dialogue box
Next: Crosstab - What am I doing wrong?