Do I need to convert a hyperlink field to text to change it?
in [Queries]
|
Prev: Passthrough queries and "Select Data Source" dialogue box
Next: Crosstab - What am I doing wrong?
From: Gina Whipp on 17 Sep 2009 10:33 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: Jim08 on 17 Sep 2009 10:44 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 10:52 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: Jim08 on 17 Sep 2009 11:10 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 11:20 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
|
Next
|
Last
Pages: 1 2 3 Prev: Passthrough queries and "Select Data Source" dialogue box Next: Crosstab - What am I doing wrong? |